- name: Install postgres
  package:
    name:
      - postgresql
      - postgresql-server
      - python3-psycopg2
    state: present
  become: true

- name: Init postgreql DB
  shell: /usr/bin/postgresql-setup --initdb
  ignore_errors: true
  become: true

- name: Start postgres
  service:
    name: postgresql
    state: started
  become: true

- name: Wait for the service to be up
  pause:
    seconds: 15

- name: Setup a postgres admin password 
  shell: psql -c "ALTER USER postgres WITH PASSWORD 'mypassword';"
  become_user: postgres
  become: true
  environment:
    PGPASSWORD: mypassword

- name: Create the database for zuul
  shell: createdb --owner=postgres zuul
  register: cmd
  failed_when: cmd.rc != 0 and not "'already exists' in cmd.stderr"
  # ignore_errors: true
  become_user: postgres
  become: true
  environment:
    PGPASSWORD: mypassword

- name: Enable auth access
  shell: sed -i 's|127.0.0.1/32            ident|127.0.0.1/32            md5|' /var/lib/pgsql/data/pg_hba.conf
  become: true

- name: Restart postgres
  service:
    name: postgresql
    state: restarted
  become: true

- name: Ensure postgres access
  shell: psql -h 127.0.0.1 -U postgres zuul -c "\dt"
  environment:
    PGPASSWORD: mypassword