apiVersion: postgres-operator.crunchydata.com/v1beta1
kind: PostgresCluster
metadata:
  name: pg
spec:
  postgresVersion: 14
  instances:
    - name: "instance1"
      replicas: 2
      dataVolumeClaimSpec:
        accessModes:
        - "ReadWriteOnce"
        resources:
          requests:
            storage: "100Gi"
      resources:
        limits:
          cpu: "1000m"
          memory: "2Gi"
      affinity:
        nodeAffinity:
          requiredDuringSchedulingIgnoredDuringExecution:
            nodeSelectorTerms:
            - matchExpressions:
              - key: topology.kubernetes.io/zone
                operator: In
                values:
                - ssdnodes-seattle
  backups:
    pgbackrest:
      configuration:
      - secret:
          name: pg-pgbackrest-secret
      global:
        repo2-path: /pgbackrest/dbs/pg/repo2
      repos:
      - name: repo1
        volume:
          volumeClaimSpec:
            accessModes:
            - "ReadWriteOnce"
            resources:
              requests:
                storage: "100Gi"
      - name: repo2
        s3:
          bucket: "postgres-k3s-sapian-cloud"
          endpoint: "s3.us-east-1.amazonaws.com"
          region: "us-east-1"
      # affinity:
      #   nodeAffinity:
      #     requiredDuringSchedulingIgnoredDuringExecution:
      #       nodeSelectorTerms:
      #       - matchExpressions:
      #         - key: topology.kubernetes.io/zone
      #           operator: In
      #           values:
      #           - ssdnodes-seattle
  users:
    - databases:
      - arpagon
      name: arpagon
      options: SUPERUSER
    - databases:
      - sapian
      name: sapian
      options: SUPERUSER
    - databases:
      - foreman
      name: foreman
    - databases:
      - keycloak
      name: keycloak
    - databases:
      - gitea
      name: gitea
    - databases:
      - hedgedoc
      name: hedgedoc
    - databases:
      - matrix
      name: matrix
    - databases:
      - matrix-slack
      name: matrix-slack
    - databases:
      - ncdroe
      name: ncdroe
    - databases:
      - pg
      name: pg
    - databases:
      - postgres
      name: postgres
    - databases:
      - gogs
      name: gogs
  openshift: false