SHA256
forked from course-team/tjhlp-gitea
74 lines
1.9 KiB
YAML
74 lines
1.9 KiB
YAML
---
|
|
# roles/postgresql/tasks/main.yml
|
|
# PostgreSQL 安装与配置
|
|
|
|
- name: 禁用系统自带的 postgresql 模块
|
|
command: dnf module disable postgresql -y
|
|
register: pg_module_disable
|
|
changed_when: "'Nothing to do' not in pg_module_disable.stdout"
|
|
failed_when: false
|
|
|
|
- name: 安装 PostgreSQL 官方仓库 RPM
|
|
dnf:
|
|
name: "https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm"
|
|
state: present
|
|
disable_gpg_check: yes
|
|
|
|
- name: 安装 PostgreSQL {{ postgresql_version }}
|
|
dnf:
|
|
name:
|
|
- postgresql{{ postgresql_version }}-server
|
|
- postgresql{{ postgresql_version }}
|
|
- python3-psycopg2
|
|
state: present
|
|
|
|
- name: 检查 PostgreSQL 数据目录是否已初始化
|
|
stat:
|
|
path: "/var/lib/pgsql/{{ postgresql_version }}/data/PG_VERSION"
|
|
register: pg_data_dir
|
|
|
|
- name: 初始化 PostgreSQL 数据库集群
|
|
command: "/usr/pgsql-{{ postgresql_version }}/bin/postgresql-{{ postgresql_version }}-setup initdb"
|
|
when: not pg_data_dir.stat.exists
|
|
|
|
- name: 部署 pg_hba.conf
|
|
template:
|
|
src: pg_hba.conf.j2
|
|
dest: "/var/lib/pgsql/{{ postgresql_version }}/data/pg_hba.conf"
|
|
owner: postgres
|
|
group: postgres
|
|
mode: "0600"
|
|
notify: 重启 PostgreSQL
|
|
|
|
- name: 启用并启动 PostgreSQL 服务
|
|
systemd:
|
|
name: "postgresql-{{ postgresql_version }}"
|
|
state: started
|
|
enabled: yes
|
|
|
|
- name: 等待 PostgreSQL 就绪
|
|
wait_for:
|
|
port: 5432
|
|
delay: 2
|
|
timeout: 30
|
|
|
|
- name: 创建 Gitea 数据库用户
|
|
become: true
|
|
become_user: postgres
|
|
community.postgresql.postgresql_user:
|
|
name: "{{ gitea_db_user }}"
|
|
password: "{{ gitea_db_password }}"
|
|
state: present
|
|
no_log: true
|
|
|
|
- name: 创建 Gitea 数据库
|
|
become: true
|
|
become_user: postgres
|
|
community.postgresql.postgresql_db:
|
|
name: "{{ gitea_db_name }}"
|
|
owner: "{{ gitea_db_user }}"
|
|
encoding: UTF-8
|
|
lc_collate: en_US.UTF-8
|
|
lc_ctype: en_US.UTF-8
|
|
state: present
|