annotate 20-kube/06-postgres.yaml @ 17:768a373ff151

add postgres for session storage
author drewp@bigasterisk.com
date Sun, 09 Apr 2023 16:35:33 -0700
parents
children 76e097b3e248
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
17
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
1 apiVersion: v1
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
2 kind: PersistentVolume
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
3 metadata:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
4 name: pomerium-db-data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
5 labels:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
6 type: local
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
7 spec:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
8 storageClassName: manual
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
9 hostPath:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
10 path: "/opt/pomerium-db"
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
11 capacity:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
12 storage: 50Gi
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
13 accessModes:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
14 - ReadWriteOnce
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
15 persistentVolumeReclaimPolicy: Retain
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
16 claimRef:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
17 namespace: pomerium
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
18 name: pomerium-db-data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
19 ---
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
20 apiVersion: v1
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
21 kind: PersistentVolumeClaim
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
22 metadata:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
23 namespace: pomerium
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
24 name: pomerium-db-data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
25 spec:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
26 storageClassName: ""
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
27 volumeName: "pomerium-db-data"
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
28 accessModes:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
29 - ReadWriteOnce
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
30 resources:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
31 requests:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
32 storage: 50Gi
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
33 ---
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
34 apiVersion: apps/v1
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
35 kind: Deployment
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
36 metadata:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
37 namespace: pomerium
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
38 name: pomerium-db
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
39 spec:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
40 replicas: 1
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
41 strategy: {type: Recreate}
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
42 selector:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
43 matchLabels:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
44 app: pomerium-db
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
45 template:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
46 metadata:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
47 labels:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
48 app: pomerium-db
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
49 annotations:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
50 prometheus.io/scrape: "false"
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
51 spec:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
52 volumes:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
53 - name: pomerium-db-data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
54 persistentVolumeClaim:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
55 claimName: pomerium-db-data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
56 containers:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
57 # see /my/serv/photoprism/deploy.yaml for exporter example (for mariadb)
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
58 - name: pomerium-db
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
59 image: postgres:14.2-alpine3.15
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
60 env:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
61 - {name: POSTGRES_PASSWORD, value: admin}
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
62 - {name: POSTGRES_DB, value: pomerium}
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
63 ports:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
64 - containerPort: 5432
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
65 volumeMounts:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
66 - name: pomerium-db-data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
67 mountPath: /var/lib/postgresql/data
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
68 affinity:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
69 nodeAffinity:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
70 requiredDuringSchedulingIgnoredDuringExecution:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
71 nodeSelectorTerms:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
72 - matchExpressions:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
73 - key: "kubernetes.io/hostname"
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
74 operator: In
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
75 values: ["ditto"]
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
76 ---
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
77 apiVersion: v1
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
78 kind: Service
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
79 metadata:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
80 namespace: pomerium
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
81 name: pomerium-db
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
82 spec:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
83 ports:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
84 - port: 5432
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
85 targetPort: 5432
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
86 selector:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
87 app: pomerium-db
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
88 ---
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
89 apiVersion: v1
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
90 kind: Secret
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
91 metadata:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
92 namespace: pomerium
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
93 name: postgres-connection-key
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
94 type: Opaque
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
95 stringData:
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
96 connection: postgresql://pom:pom@pomerium-db/pomerium