From 18fb0ea7db48788619757682cce7fedf43d6299d Mon Sep 17 00:00:00 2001
From: Someone <someone@somenet.org>
Date: Sat, 23 Aug 2025 23:53:00 +0200
Subject: [PATCH] roles/server/postgresql/tasks

---
 roles/server/postgresql/tasks/main.yml | 15 ++++++++++++++-
 1 file changed, 14 insertions(+), 1 deletion(-)

diff --git a/roles/server/postgresql/tasks/main.yml b/roles/server/postgresql/tasks/main.yml
index 335eb29..d1f3362 100644
--- a/roles/server/postgresql/tasks/main.yml
+++ b/roles/server/postgresql/tasks/main.yml
@@ -23,7 +23,20 @@
   tags: "online"
   ignore_errors: "{{ignore_online_errors | bool}}"
 
-# TODO: upgrade or init
+
+- name: upgrade cluster
+  command: "pg_upgradecluster --locale='C.UTF8' -v 17 {{postgresql_server_upgrade_from}} main"
+  args:
+    creates: "/etc/postgresql/17/main/postgresql.conf"
+  when: postgresql_server_upgrade_from != ""
+
+
+- name: init cluster
+  command: "pg_createcluster --locale='C.UTF8' 17 main"
+  args:
+    creates: "/etc/postgresql/17/main/postgresql.conf"
+  when: postgresql_server_upgrade_from == ""
+
 
 - name: copy postgresql.conf
   copy:
-- 
2.47.2