homelab/ansible/roles/postgres/tasks/main.yml

---
- 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 db initalized
  shell: /usr/local/etc/rc.d/postgresql initdb
  ignore_errors: yes

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

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

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

- name: Postgres config file permissions fixed
  file:
    path: /var/db/postgres/data12/postgresql.conf
    owner: postgres
    group: postgres

- name: Pg_hba config file permissions fixed
  file:
    path: /var/db/postgres/data12/pg_hba.conf
    owner: postgres
    group: postgres

- name: Postgres user password set
  postgresql_user:
    name: postgres
    password: "{{ postgres_db_pass }}"

- name: PBP user exists
  postgresql_user:
    name: pbp
    password: "{{ pbp_db_pass }}"
    role_attr_flags: CREATEDB,NOSUPERUSER,LOGIN

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

- name: 15Five user exists
  postgresql_user:
    name: fifteen5
    password: "{{ fifteenfive_db_pass }}"
    role_attr_flags: CREATEDB,NOSUPERUSER,LOGIN

- name: 15Five database exists
  postgresql_db:
    name: "fifteen5"
    state: present
    owner: fifteen5
  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: gogs user exists
  postgresql_user:
    name: gogs
    password: "{{ gogs_db_pass }}"
    role_attr_flags: NOSUPERUSER,LOGIN

- name: gogs database exists
  postgresql_db:
    name: "gogs"
    state: present
    owner: gogs
  become_user: postgres

- name: miniflux user exists
  postgresql_user:
    name: miniflux
    password: "{{ miniflux_db_pass }}"
    role_attr_flags: NOSUPERUSER,LOGIN

- name: miniflux database exists
  postgresql_db:
    name: "miniflux"
    state: present
    owner: miniflux
  become_user: postgres