---
- name: postgresql-packages | Manage the postgresql packages installation
  when:
    - ansible_distribution_file_variety == "Debian"
    - not postgresql_client_only
  tags: ['postgresql', 'postgres']
  block:
    - name: postgresql-packages | Install the postgresql server packages on Deb systems
      ansible.builtin.apt:
        pkg: "{{ postgresql_pkgs }}"
        state: present
        cache_valid_time: 3600
      notify: Restart postgresql

- name: postgresql-packages | Manage the postgresql client installation
  when:
    - ansible_distribution_file_variety == "Debian"
    - postgresql_client_only
  tags: ['postgresql', 'postgres', 'postgres_client']
  block:
    - name: postgresql-packages | Install the postgresql client packages on Deb systems
      ansible.builtin.apt:
        pkg: postgresql-client
        state: present
        cache_valid_time: 3600

- name: postgresql-packages | EL server packages
  when:
    - not psql_el_install_scl_version
    - not postgresql_client_only
    - ansible_distribution_file_variety == "RedHat"
  tags: ['postgresql', 'postgres']
  block:
    - name: postgresql-packages | Install the postgresql EL packages from the pgdg repository
      ansible.builtin.yum:
        pkg: "{{ psql_el_pgdg_packages }}"
        state: present
    - name: postgresql-packages | Print the DATA directory
      ansible.builtin.debug:
        msg: "Postgresql data directory: {{ psql_el_data_dir }}"

    - name: postgresql-packages | Create the postgresql data directory if it is not in the default place
      ansible.builtin.file:
        dest: "{{ psql_el_data_dir }}"
        owner: postgres
        group: postgres
        mode: "700"
        state: directory
      when: psql_use_alternate_data_dir

    - name: postgresql-packages | Crate a systemd directory to customize the postgresql startup unit
      ansible.builtin.file:
        dest: "/etc/systemd/system/postgresql-{{ psql_version }}.service.d"
        owner: root
        group: root
        mode: "755"
        state: directory
      when: psql_use_alternate_data_dir

    - name: postgresql-packages | Crate a postgresql systemd unit environment file
      ansible.builtin.template:
        src: postgresql-service-environment.conf.j2
        dest: "/etc/systemd/system/postgresql-{{ psql_version }}.service.d/environment.conf"
        owner: root
        group: root
        mode: "644"
      when: psql_use_alternate_data_dir
      notify: Reload systemd
    - name: postgresql-packages | Postgresql install flush handlers
      ansible.builtin.meta: flush_handlers

    - name: postgresql-packages | Init the db if needed on EL systems
      ansible.builtin.command: /usr/pgsql-{{ psql_version }}/bin/postgresql-{{ psql_version }}-setup initdb
      args:
        creates: '{{ psql_el_data_dir }}/postgresql.conf'

- name: postgresql-packages | EL server packages from SCL
  when:
    - psql_el_install_scl_version
    - ansible_distribution_file_variety == "RedHat"
    - not postgresql_client_only
  tags: ['scl', 'postgresql', 'postgres']
  block:
    - name: postgresql-packages | Install the postgresql scl packages on EL
      ansible.builtin.yum:
        pkg: "{{ psql_el_scl_packages }}"
        state: present

    - name: postgresql-packages | Init the db if needed on EL systems
      ansible.builtin.command: /opt/rh/rh-postgresql{{ psql_version }}/root/usr/bin/postgresql-setup --initdb
      args:
        creates: '{{ psql_el_data_dir }}/postgresql.conf'

- name: postgresql-packages | EL client packages
  when:
    - not psql_el_install_scl_version
    - postgresql_client_only
    - ansible_distribution_file_variety == "RedHat"
  tags: ['postgresql', 'postgres', 'postgres_client']
  block:
    - name: postgresql-packages | Install the postgresql client from the pgdg repository on EL systems
      ansible.builtin.yum:
        pkg: "postgresql{{ psql_version }}"
        state: present

- name: postgresql-packages | EL client packages from SCL
  when:
    - psql_el_install_scl_version
    - ansible_distribution_file_variety == "RedHat"
    - postgresql_client_only
  tags: ['scl', 'postgresql', 'postgres', 'postgres_client']
  block:
    - name: postgresql-packages | Install the postgresql scl client package on EL systems
      ansible.builtin.yum:
        pkg: "{{ item }}"
        state: present
      loop:
        - "rh-postgresql{{ psql_version }}-runtime"
        - "rh-postgresql{{ psql_version }}-postgresql"