apiVersion: postgres-operator.crunchydata.com/v1beta1
kind: PostgresCluster
metadata:
  name: postgres
spec:
  image: quay.io/wundercomm/wundercomm-postgres:centos8-supabase-14.2-1
  postgresVersion: 14
  instances:
    - name: postgres
      replicas: 1
      dataVolumeClaimSpec:
        storageClassName: longhorn
        accessModes:
        - "ReadWriteOnce"
        resources:
          requests:
            storage: 1Gi
      affinity:
        nodeAffinity:
          requiredDuringSchedulingIgnoredDuringExecution:
            nodeSelectorTerms:
            - matchExpressions:
              - key: sapian-k3s-role
                operator: In
                values:
                - server
  users:
  - name: arpagon
    databases:
      - arpagon
    options: "SUPERUSER"
  - name: synapse
    databases:
      - synapse
  - name: keycloak
    databases:
      - keycloak
      - postgres
  - name: strapi
    databases:
      - strapi
      - postgres
  - name: mautrix-whatsapp
    databases:
      - mautrix-whatsapp
  - name: maubot
    databases:
      - maubot
  backups:
    pgbackrest:
      image: registry.developers.crunchydata.com/crunchydata/crunchy-pgbackrest:centos8-2.36-1
      repos:
      - name: repo1
        volume:
          volumeClaimSpec:
            storageClassName: longhorn
            accessModes:
            - "ReadWriteOnce"
            resources:
              requests:
                storage: 1Gi