blob: 4f62d31a770168157adcc38cab7b156543206efb (
plain) (
blame)
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
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
|
---
- set_fact:
postgres_version: "{{ postgres_cluster.version }}"
postgres_cluster_name: "{{ postgres_cluster.name }}"
postgres_port: "{{ postgres_cluster.port }}"
postgres_fsync_enabled: "{{ postgres_cluster.fsync_enabled }}"
postgres_archive_enabled: "{{ postgres_cluster.archive_enabled }}"
postgres_wal_level: "{{ postgres_cluster.wal_level|default('logical') }}"
postgres_max_replication_slots: "{{ postgres_cluster.max_replication_slots | default(10) }}"
postgres_extra_config: "{{ postgres_cluster.extra_config | default({}) }}"
barman_directory: "{{ postgres_cluster.barman_directory | default(None) }}"
postgres_primary: "{{ postgres_cluster.primary | default(None) }}"
postgres_checksums: "{{ postgres_cluster.checksums | default(True) }}"
- name: Install postgresql version {{ postgres_version }}
apt: name=postgresql-{{ postgres_version }}
when: ansible_distribution_release != 'NA'
- name: Install pg_repack version {{ postgres_version }}
apt: name=postgresql-{{ postgres_version }}-repack
when:
- ansible_distribution_release != 'NA'
- postgres_version in ['9.3', '9.4', '9.5', '9.6', '10', '11', '12']
- name: Set initdb options
set_fact: postgres_initdb_option="{% if postgres_checksums %}--data-checksums{% endif %}"
- name: Create postgres cluster {{ postgres_version }}/{{ postgres_cluster_name }} if needed
command: /usr/bin/pg_createcluster {{ postgres_version }} {{ postgres_cluster_name }} -- {{ postgres_initdb_option }}
args:
creates: /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/
- name: Check postgres server key
stat: path=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.key
register: server_key
- name: Copy snakeoil key in postgres dir
copy:
src=/etc/ssl/private/ssl-cert-snakeoil.key
dest=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.key
remote_src=true
owner=postgres
group=postgres
mode="0600"
when: not server_key.stat.exists or server_key.stat.islnk
- name: Check postgres server certificate
stat: path=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.crt
register: server_crt
- name: Copy snakeoil certificate in postgres dir
copy:
src=/etc/ssl/certs/ssl-cert-snakeoil.pem
dest=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.crt
remote_src=true
owner=postgres
group=postgres
mode="0644"
when: not server_crt.stat.exists or server_crt.stat.islnk
- name: Add standby clone from barman script
include: postgres-standby-barman.yml
when: postgres_barman_server is defined and postgres_primary.restore_barman_directory is defined
- name: Add standby clone from pg_basebackup
include: postgres-standby-basebackup.yml
when: postgres_primary and postgres_primary.pg_basebackup is defined
- name: Determine SSD or rotational disks
raw: 'lsblk --noheadings --nodeps --raw --output=rota | grep -q 1'
check_mode: no
ignore_errors: yes
register: rotational_disk
- name: Set specific random page cost for SSDs
set_fact:
postgres_specific_random_page_cost: "1.0"
when:
- rotational_disk.failed is defined
- rotational_disk.failed
- name: Upload postgresql.conf
template: src=postgresql.{{ postgres_version }}.conf.j2 dest=/etc/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/postgresql.conf
- name: Upload pg_hba.conf
template: src=pg_hba.conf.j2 dest=/etc/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/pg_hba.conf
- name: Upload recovery.conf
template: src=recovery.conf.j2 dest=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/recovery.conf owner=postgres group=postgres mode=0600
when: postgres_primary and postgres_version is version('12', '<')
no_log: True
- name: Define secondary nodes as secondaries with corresponding signal files
file:
path: "{{ item }}"
state: touch
when: postgres_primary and postgres_version is version('12', '>=')
with_items:
- /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/standby.signal
- name: Create log file
file:
path={{ postgres_log_dir }}/postgresql-{{ postgres_version }}-{{ postgres_cluster_name }}.log
state=touch
owner=postgres
group=adm
when: postgres_log_dir is defined and postgres_log_dir
- name: Create log symlink for pg_lsclusters
file: dest=/etc/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/log src={{ postgres_log_dir }}/postgresql-{{ postgres_version }}-{{ postgres_cluster_name }}.log state=link
when: postgres_log_dir is defined and postgres_log_dir
|
