From 8c40e0d0f46a641bdce723642f31ac1cfb6c26b4 Mon Sep 17 00:00:00 2001
From: Joe Banks <joe@jb3.dev>
Date: Sat, 27 Apr 2024 00:39:55 +0100
Subject: Upgrade to PostgreSQL 16 and move to databases namespace

---
 .../databases/postgresql/deployment.yaml           | 47 ++++++++++++++++++++++
 1 file changed, 47 insertions(+)
 create mode 100644 kubernetes/namespaces/databases/postgresql/deployment.yaml

(limited to 'kubernetes/namespaces/databases/postgresql/deployment.yaml')

diff --git a/kubernetes/namespaces/databases/postgresql/deployment.yaml b/kubernetes/namespaces/databases/postgresql/deployment.yaml
new file mode 100644
index 0000000..bf1f246
--- /dev/null
+++ b/kubernetes/namespaces/databases/postgresql/deployment.yaml
@@ -0,0 +1,47 @@
+apiVersion: apps/v1
+kind: Deployment
+metadata:
+  name: postgres
+  namespace: databases
+spec:
+  replicas: 1
+  strategy:
+    type: Recreate
+  selector:
+    matchLabels:
+      app: postgres
+  template:
+    metadata:
+      labels:
+        app: postgres
+    spec:
+      containers:
+        - name: postgres
+          image: ghcr.io/owl-corp/psql_extended:16
+          imagePullPolicy: "Always"
+          ports:
+            - name: postgres
+              containerPort: 5432
+          envFrom:
+            - secretRef:
+                name: postgres-env
+          args: ["-c", "config_file=/etc/postgresql/postgresql.conf"]
+          volumeMounts:
+            - name: postgres-data
+              mountPath: /var/lib/postgresql/data
+              subPath: pgdata
+            - name: postgres-config
+              mountPath: /etc/postgresql
+            - name: dshm
+              mountPath: /dev/shm
+      volumes:
+        - name: postgres-data
+          persistentVolumeClaim:
+            claimName: postgres-storage
+        - name: postgres-config
+          configMap:
+            name: postgres-config
+        - name: dshm
+          emptyDir:
+            medium: Memory
+            sizeLimit: 2Gi
-- 
cgit v1.2.3