annotate config/06-postgres.yaml @ 24:b53ab97e8979

reorganize, and add two retry loops to try to get everything to startup in one 'inv run'
author drewp@bigasterisk.com
date Thu, 08 Jun 2023 10:50:01 -0700
parents 20-kube/06-postgres.yaml@76e097b3e248
children
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
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
41 strategy: { type: Recreate }
17
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:
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
61 - { name: POSTGRES_PASSWORD, value: admin }
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
62 - { name: POSTGRES_DB, value: pomerium }
17
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
63 ports:
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
64 - containerPort: 5432
17
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
65 volumeMounts:
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
66 - name: pomerium-db-data
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
67 mountPath: /var/lib/postgresql/data
17
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:
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
72 - matchExpressions:
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
73 - key: "kubernetes.io/hostname"
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
74 operator: In
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
75 values: ["ditto"]
17
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:
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
84 - port: 5432
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
85 targetPort: 5432
17
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
19
76e097b3e248 reformat
drewp@bigasterisk.com
parents: 17
diff changeset
95 stringData:
17
768a373ff151 add postgres for session storage
drewp@bigasterisk.com
parents:
diff changeset
96 connection: postgresql://pom:pom@pomerium-db/pomerium