postgres play

- name: add postgres repo key
  apt_key: data="{{ lookup('file', 'ACCC4CF8_apt.postgresql.org.asc') }}" state=present

- name: add postgres apt repo
  apt_repository: repo='deb http://apt.postgresql.org/pub/repos/apt/ bionic-pgdg main'
    state=present
    update_cache=yes

- name: install prerequisites
  apt: name={{item}}
  with_items:
    - postgresql-{{ postgres_version }}
    - postgresql-client-{{ postgres_version }}
    - postgresql-contrib-{{ postgres_version }}
    - postgresql-client-common
    - postgresql-common
    - python-psycopg2
    - python3-psycopg2

- name: postgres config
  template: >
    src={{ item }}
    dest=/etc/postgresql/{{ postgres_version }}/main/
    owner=postgres
    group=postgres
    mode=640
  with_items:
    - pg_hba.conf
    - postgresql.conf
  notify:
    - reload postgres

- name: start postgres and enable auto-start
  service:
    name: "{{ postgres_daemon }}"
    state: started
    enabled: yes

- name: create db users
  become: yes
  become_user: postgres
  postgresql_user: >
    encrypted=no
    name={{ item.name }}
    password={{ item.password }}
    port=5452
    role_attr_flags={{ item.flags }}
  with_items:
    - name: dev
      password: "{{ creds.postgres...secret }}"
      flags: SUPERUSER,LOGIN