psql-deploy.yml

kind: Deployment
apiVersion: apps/v1
metadata:
  name: psql
  labels:
    app: psql
    part-of: authentik
  annotations:
    keel.sh/policy: force
    keel.sh/trigger: poll
    keel.sh/pollSchedule: "@hourly"
    keel.sh/match-tag: true
spec:
  replicas: 1
  selector:
    matchLabels:
      app: psql
      part-of: authentik
  template:
    metadata:
      labels:
        app: psql
        part-of: authentik
    spec:
      affinity:
        nodeAffinity:
          preferredDuringSchedulingIgnoredDuringExecution:
          - weight: 1
            preference:
              matchExpressions:
              - key: disktype
                operator: In
                values:
                - ssd
      serviceAccountName: authentik
      containers:
      - name: psql
        image: postgres:latest
        ports:
        - name: psql
          containerPort: 5432
        env:
        - name: POSTGRES_HOST_AUTH_METHOD
          value: "trust"
        - name: POSTGRES_USER
          valueFrom:
            secretKeyRef:
              name: authentik
              key: POSTGRES_USER
        - name: POSTGRES_PASSWORD
          valueFrom:
            secretKeyRef:
              name: authentik
              key: POSTGRES_PASSWORD
        - name: POSTGRES_DB
          valueFrom:
            secretKeyRef:
              name: authentik
              key: POSTGRES_DB
        - name: PGDATA
          value: /var/lib/postgresql/data/pgdata
        volumeMounts:
        - name: authentik-psql
          mountPath: /var/lib/postgresql/data
        - name: authentik-secrets
          mountPath: "/mnt/vault"
          readOnly: true
        resources:
          limits:
            memory: 150Mi
          requests:
            memory: 100Mi
      volumes:
      - name: authentik-psql
        persistentVolumeClaim:
          claimName: authentik-psql
      - name: authentik-secrets
        csi:
          driver: "secrets-store.csi.k8s.io"
          readOnly: true
          volumeAttributes:
            secretProviderClass: "authentik"