stack.basicstack.de/apps/kaneo/kaneo-postgres-deployment.yaml

apiVersion: apps/v1
kind: Deployment
metadata:
  name: kaneo-postgres
  namespace: kaneo
  labels:
    app: kaneo
    component: database
spec:
  replicas: 0
  strategy:
    type: Recreate
  selector:
    matchLabels:
      app: kaneo
      component: database
  template:
    metadata:
      labels:
        app: kaneo
        component: database
    spec:
      affinity:
        nodeAffinity:
          requiredDuringSchedulingIgnoredDuringExecution:
            nodeSelectorTerms:
            - matchExpressions:
              - key: csi.hetzner.cloud/location
                operator: In
                values:
                - fsn1
      containers:
      - name: postgres
        image: postgres:16-alpine
        ports:
        - name: postgres
          containerPort: 5432
        env:
        - name: POSTGRES_DB
          value: kaneo
        - name: POSTGRES_USER
          value: kaneo
        - name: POSTGRES_PASSWORD
          valueFrom:
            secretKeyRef:
              name: kaneo-db-credentials
              key: postgres-password
        - name: PGDATA
          value: /var/lib/postgresql/data/pgdata
        resources:
          requests:
            cpu: 100m
            memory: 256Mi
          limits:
            cpu: "1"
            memory: 1Gi
        livenessProbe:
          exec:
            command:
            - pg_isready
            - -U
            - kaneo
            - -d
            - kaneo
          initialDelaySeconds: 30
          periodSeconds: 10
        readinessProbe:
          exec:
            command:
            - pg_isready
            - -U
            - kaneo
            - -d
            - kaneo
          initialDelaySeconds: 5
          periodSeconds: 5
        volumeMounts:
        - name: data
          mountPath: /var/lib/postgresql/data
      volumes:
      - name: data
        persistentVolumeClaim:
          claimName: kaneo-postgres-data