postgresql/tasks/main.yaml
author Luke Hoersten <luke@hoersten.org>
Sun, 04 Feb 2024 20:27:19 -0600
changeset 227 2e0366f2dcbe
parent 40 b42b417751e5
permissions -rw-r--r--
Tons of updates to fix migration to new server.

---

- name: install postgresql
  become: yes
  apt: name="{{postgresql_apt_packages}}"

- name: configure postgresql data dir
  become: yes
  lineinfile:
    path: "{{postgresql_config_path}}"
    regexp: "^data_directory = "
    line: "data_directory = '{{postgresql_data_dir}}'"
  notify: restart postgres

- name: create postgresql data dir
  become: yes
  file:
    path: "{{postgresql_data_dir}}"
    state: "directory"
    mode: "0700"
    owner: "postgres"
    group: "postgres"
  notify: restart postgres

- name: check if postgresql data dir is new
  become: yes
  find: path='{{postgresql_data_dir}}'
  register: filesFound

- name: initialize pg data dir
  become: yes
  become_user: "postgres"
  command: "{{postgresql_initidb_path}} -D {{postgresql_data_dir}}"
  when: filesFound == 0

- name: ensure postgresql is started
  become: yes
  systemd: name="postgresql" enabled="yes" state="started"