postgres-k8s/cluster.yaml at main · danielfoord/postgres-k8s · 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
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
  name: postgres-cluster
  namespace: data
spec:
  # 1 primary + 2 read replicas
  instances: 3

  imageName: ghcr.io/cloudnative-pg/postgresql:18

  # Superuser secret (postgres user)
  superuserSecret:
    name: postgres-superuser

  # Bootstrap: create the app database and user on first init
  bootstrap:
    initdb:
      database: appdb
      owner: app
      secret:
        name: postgres-app

  # Per-instance storage
  storage:
    storageClass: standard
    size: 2Gi

  postgresql:
    parameters:
      # Allow enough connections for PGBouncer server-side pool
      max_connections: "200"
      # Logging
      log_min_duration_statement: "1000"  # log queries over 1s

  # Async replication — primary does not wait for replicas before acking writes
  minSyncReplicas: 0
  maxSyncReplicas: 0

  # WAL archiving via the Barman Cloud Plugin (replaces deprecated barmanObjectStore)
  plugins:
    - name: barman-cloud.cloudnative-pg.io
      isWALArchiver: true
      parameters:
        barmanObjectName: seaweedfs-store