tasks/postgres-cluster.yml

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