1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
---
- name: Add password in pgpass
ansible.builtin.include_role:
name: manage_dbserver
tasks_from: manage_pgpass
vars:
pg_pgpass_values:
- user: "{{ pg_replication_user }}"
password: "{{ pg_replication_user_password }}"
create: true
- name: Create standby
ansible.builtin.shell: >
PGAPPNAME={{ inventory_hostname }} {{ pg_basebackup }}
args:
creates: "{{ pg_data }}/PG_VERSION"
become: true
become_user: "{{ pg_owner }}"
async: 180000
poll: 60
- name: Enable and start the service
ansible.builtin.systemd:
name: "{{ pg_service }}"
daemon_reload: true
state: started
enabled: true
become: true
- name: Update standby hba config
ansible.builtin.include_role:
name: manage_dbserver
tasks_from: manage_hba_conf
vars:
pg_hba_ip_addresses: "{{ pg_allow_ip_addresses }}"
|
