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"
    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
  notify: PostgreSQL restarted

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