---
- name: Package cache updated
  shell: pkg update -f

- name: PostgreSQL packages installed
  pkgng:
    name: "postgresql12-server postgresql12-client postgresql12-contrib py37-psycopg2"
    state: present

- name: PostgreSQL enabled
  shell: sysrc postgresql_enable="YES"

- name: PostgreSQL access file patched
  patch:
    src: pg_hba.conf.patch
    dest: /var/db/postgres/data12/pg_hba.conf
  become_user: postgres
  notify: PostgreSQL restarted

- name: PostgreSQL config file patched
  patch:
    src: postgresql.conf.patch
    dest: /var/db/postgres/data12/postgresql.conf
  become_user: postgres
  notify: PostgreSQL restarted

- name: PBP database exists
  postgresql_db:
    name: "pbp"
    state: present
  become_user: postgres

- name: 15Five database exists
  postgresql_db:
    name: "fifteen5"
    state: present
  become_user: postgres

- name: 15Five database has btree_gist extension
  postgresql_ext:
    name: btree_gist
    db: fifteen5
  become_user: postgres

- name: 15Five database has btree_gin extension
  postgresql_ext:
    name: btree_gin
    db: fifteen5
  become_user: postgres

- name: 15Five database has ltree extension
  postgresql_ext:
    name: ltree
    db: fifteen5
  become_user: postgres

- name: 15Five database has hstore extension
  postgresql_ext:
    name: hstore
    db: fifteen5
  become_user: postgres

- name: 15Five database exists
  postgresql_db:
    name: "fifteen5_jail"
    state: present
  become_user: postgres

- name: 15Five database has btree_gist extension
  postgresql_ext:
    name: btree_gist
    db: fifteen5_jail
  become_user: postgres

- name: 15Five database has btree_gin extension
  postgresql_ext:
    name: btree_gin
    db: fifteen5_jail
  become_user: postgres

- name: 15Five database has ltree extension
  postgresql_ext:
    name: ltree
    db: fifteen5_jail
  become_user: postgres

- name: 15Five database has hstore extension
  postgresql_ext:
    name: hstore
    db: fifteen5_jail
  become_user: postgres