3 postgres_version: "{{ postgres_cluster.version }}"
4 postgres_cluster_name: "{{ postgres_cluster.name }}"
5 postgres_port: "{{ postgres_cluster.port }}"
6 postgres_fsync_enabled: "{{ postgres_cluster.fsync_enabled }}"
7 postgres_archive_enabled: "{{ postgres_cluster.archive_enabled }}"
8 postgres_wal_level: "{{ postgres_cluster.wal_level|default('logical') }}"
9 postgres_max_replication_slots: "{{ postgres_cluster.max_replication_slots | default(10) }}"
10 postgres_extra_config: "{{ postgres_cluster.extra_config | default({}) }}"
11 barman_directory: "{{ postgres_cluster.barman_directory | default(None) }}"
12 postgres_primary: "{{ postgres_cluster.primary | default(None) }}"
13 postgres_checksums: "{{ postgres_cluster.checksums | default(True) }}"
15 - name: Install postgresql version {{ postgres_version }}
16 apt: name=postgresql-{{ postgres_version }}
17 when: ansible_distribution_release != 'NA'
19 - name: Install pg_repack version {{ postgres_version }}
20 apt: name=postgresql-{{ postgres_version }}-repack
22 - ansible_distribution_release != 'NA'
23 - postgres_version in ['9.3', '9.4', '9.5', '9.6', '10', '11', '12']
25 - name: Set initdb options
26 set_fact: postgres_initdb_option="{% if postgres_checksums %}--data-checksums{% endif %}"
28 - name: Create postgres cluster {{ postgres_version }}/{{ postgres_cluster_name }} if needed
29 command: /usr/bin/pg_createcluster {{ postgres_version }} {{ postgres_cluster_name }} -- {{ postgres_initdb_option }}
31 creates: /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/
33 - name: Check postgres server key
34 stat: path=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.key
37 - name: Copy snakeoil key in postgres dir
39 src=/etc/ssl/private/ssl-cert-snakeoil.key
40 dest=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.key
45 when: not server_key.stat.exists or server_key.stat.islnk
47 - name: Check postgres server certificate
48 stat: path=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.crt
51 - name: Copy snakeoil certificate in postgres dir
53 src=/etc/ssl/certs/ssl-cert-snakeoil.pem
54 dest=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/server.crt
59 when: not server_crt.stat.exists or server_crt.stat.islnk
61 - name: Add standby clone from barman script
62 include: postgres-standby-barman.yml
63 when: postgres_barman_server is defined and postgres_primary.restore_barman_directory is defined
65 - name: Add standby clone from pg_basebackup
66 include: postgres-standby-basebackup.yml
67 when: postgres_primary and postgres_primary.pg_basebackup is defined
69 - name: Determine SSD or rotational disks
70 raw: 'lsblk --noheadings --nodeps --raw --output=rota | grep -q 1'
73 register: rotational_disk
75 - name: Set specific random page cost for SSDs
77 postgres_specific_random_page_cost: "1.0"
79 - rotational_disk.failed is defined
80 - rotational_disk.failed
82 - name: Upload postgresql.conf
83 template: src=postgresql.{{ postgres_version }}.conf.j2 dest=/etc/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/postgresql.conf
85 - name: Upload pg_hba.conf
86 template: src=pg_hba.conf.j2 dest=/etc/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/pg_hba.conf
88 - name: Upload recovery.conf
89 template: src=recovery.conf.j2 dest=/var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/recovery.conf owner=postgres group=postgres mode=0600
90 when: postgres_primary and postgres_version is version('12', '<')
93 - name: Define secondary nodes as secondaries with corresponding signal files
97 when: postgres_primary and postgres_version is version('12', '>=')
99 - /var/lib/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/standby.signal
101 - name: Create log file
103 path={{ postgres_log_dir }}/postgresql-{{ postgres_version }}-{{ postgres_cluster_name }}.log
107 when: postgres_log_dir is defined and postgres_log_dir
109 - name: Create log symlink for pg_lsclusters
110 file: dest=/etc/postgresql/{{ postgres_version }}/{{ postgres_cluster_name }}/log src={{ postgres_log_dir }}/postgresql-{{ postgres_version }}-{{ postgres_cluster_name }}.log state=link
111 when: postgres_log_dir is defined and postgres_log_dir