src.nth.io/

summaryrefslogtreecommitdiff
path: root/postgresql
diff options
context:
space:
mode:
Diffstat (limited to 'postgresql')
-rw-r--r--postgresql/defaults/main.yaml1
-rw-r--r--postgresql/tasks/main.yaml11
2 files changed, 12 insertions, 0 deletions
diff --git a/postgresql/defaults/main.yaml b/postgresql/defaults/main.yaml
index 8a208b7..de97031 100644
--- a/postgresql/defaults/main.yaml
+++ b/postgresql/defaults/main.yaml
@@ -2,6 +2,7 @@
# migrate PG version with pg_upgradecluster (see manpage)
postgresql_version: "14"
+postgresql_initidb_path: "/usr/lib/postgresql/{{postgresql_version}}/bin/initdb"
postgresql_config_path: "/etc/postgresql/{{postgresql_version}}/main/postgresql.conf"
postgresql_data_dir: "/var/lib/postgresql/{{postgresql_version}}/main"
postgresql_apt_packages:
diff --git a/postgresql/tasks/main.yaml b/postgresql/tasks/main.yaml
index 6195840..6efa491 100644
--- a/postgresql/tasks/main.yaml
+++ b/postgresql/tasks/main.yaml
@@ -22,6 +22,17 @@
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"