postgres-operator-examples/cn-accounts-backup.yaml at b239632b2422b7aff7e2adf71f05a9ed7e3566c1 · CrunchyData/postgres-operator-examples · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
apiVersion: postgres-operator.crunchydata.com/v1beta1
kind: PostgresCluster
metadata:
  name: cn-accounts-backup
  namespace: postgres-operator
spec:
  image: registry.developers.crunchydata.com/crunchydata/crunchy-postgres-gis:ubi8-16.2-3.4-0
  postgresVersion: 16
  instances:
  - name: instance1
    replicas: 1
    dataVolumeClaimSpec:
      accessModes:
      - ReadWriteOnce
      storageClassName: local-path
      resources:
        requests:
          storage: 20Gi
  monitoring:
    pgmonitor:
      exporter:
        image: registry.developers.crunchydata.com/crunchydata/crunchy-postgres-exporter:ubi8-5.6.0-0
  patroni:
    leaderLeaseDurationSeconds: 120
    syncPeriodSeconds: 10
    port: 8008
    dynamicConfiguration:
      loop_wait: 10
      ttl: 120
      retry_timeout: 60
      postgresql:
        parameters:
          log_timezone: Europe/Warsaw
          timezone: Europe/Warsaw
        pg_hba:
        - local all postgres peer
        - hostssl replication _crunchyrepl all cert
        - hostssl postgres _crunchyrepl all cert
        - host all _crunchyrepl all reject
        - host all ccp_monitoring 127.0.0.0/8 scram-sha-256
        - host all ccp_monitoring ::1/128 scram-sha-256
        - host all ccp_monitoring all reject
        - hostssl all _crunchypgbouncer all scram-sha-256
        - host all _crunchypgbouncer all reject
        - host all all 0.0.0.0/0 md5
        - hostssl all all all scram-sha-256
        - local all all md5
  port: 5432
  proxy:
    pgBouncer:
      image: registry.developers.crunchydata.com/crunchydata/crunchy-pgbouncer:ubi8-1.21-3
      port: 5432
      replicas: 1
  service:
    type: LoadBalancer
    metadata:
      annotations:
        metallb.universe.tf/address-pool: general-pool
      labels:
        my-label: value2
  users:
  - name: accounts
    databases:
    - postgres
    options: SUPERUSER