From afb26e0f90ecb8be40b67ced65f6f8d1ed9f6bdb Mon Sep 17 00:00:00 2001
From: Jakub Czajka <jakub@ekhem.eu.org>
Date: Wed, 27 Sep 2023 22:57:22 +0200
Subject: [PATCH] Add a script for configuring postgres.

---
 server/postgres.yaml | 33 +++++++++++++++++++++++++++++++++
 1 file changed, 33 insertions(+)
 create mode 100644 server/postgres.yaml

diff --git a/server/postgres.yaml b/server/postgres.yaml
new file mode 100644
index 0000000..553d53d
--- /dev/null
+++ b/server/postgres.yaml
@@ -0,0 +1,33 @@
+# Copyright (c) 2023 Jakub Czajka <jakub@ekhem.eu.org>
+# License: GPL-3.0 or later.
+
+- name: Checkout configuration
+  command: |
+    git --work-tree=/tmp --git-dir=/srv/git/server.git checkout main --force \
+      postgres/*
+  become: yes
+- name: Install postgres
+  package:
+    name:
+      - postgresql
+    state: latest
+  become: yes
+- name: Ensure postgres directory structure exists
+  file:
+    path: "/etc/postgresql/13/main/"
+    state: directory
+  become: yes
+- name: Copy to /etc/postgresql/13/main
+  copy:
+    src: "/tmp/postgres/{{ item }}"
+    dest: "/etc/postgresql/13/main"
+    remote_src: true
+  become: true
+  with_items:
+    - pg_hba.conf
+    - postgresql.conf
+- name: Restart postgres
+  service:
+    name: postgresql
+    state: restarted
+  become: yes
-- 
2.39.5