# Source: postgrescluster/templates/postgres.yaml
apiVersion: postgres-operator.crunchydata.com/v1beta1
kind: PostgresCluster
metadata:
  name: pg-pitr
spec:
  dataSource:
    postgresCluster:
      clusterName: pg
      repoName: repo1
      options:
      - --type=time
      - --target="2023-05-26 12:59:13-05"
  postgresVersion: 14
  instances:
    - name: "instance1"
      replicas: 1
      dataVolumeClaimSpec:
        storageClassName: longhorn-ssdnodes-seattle
        accessModes:
        - "ReadWriteOnce"
        resources:
          requests:
            storage: "240Gi"
      resources:
        limits:
          cpu: "1000m"
          memory: "2Gi"
      affinity:
        nodeAffinity:
          requiredDuringSchedulingIgnoredDuringExecution:
            nodeSelectorTerms:
            - matchExpressions:
              - key: sapian-k3s-role
                operator: In
                values:
                - agent
              - key: sapian-agent-dc
                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:
            storageClassName: longhorn-ssdnodes-seattle
            accessModes:
            - "ReadWriteOnce"
            resources:
              requests:
                storage: "200Gi"
      - name: repo2
        s3:
          bucket: "postgres-k3s-sapian-cloud"
          endpoint: "s3.us-east-1.amazonaws.com"
          region: "us-east-1"
  monitoring:
    pgmonitor:
      exporter:
        image: registry.developers.crunchydata.com/crunchydata/crunchy-postgres-exporter:ubi8-5.2.0-0
  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
  patroni:
    dynamicConfiguration:
      postgresql:
        pg_hba:
          - "hostnossl all all all md5"