postgres-k8s/pooler.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
46
47
---
# Read-Write pooler — connects to the primary
apiVersion: postgresql.cnpg.io/v1
kind: Pooler
metadata:
  name: postgres-pooler-rw
  namespace: data
spec:
  cluster:
    name: postgres-cluster
  # "rw" targets the primary instance only
  type: rw
  instances: 2

  pgbouncer:
    poolMode: transaction
    parameters:
      max_client_conn: "200"
      default_pool_size: "25"
      reserve_pool_size: "5"
      reserve_pool_timeout: "5"
      server_idle_timeout: "600"
      client_idle_timeout: "600"

---
# Read-Only pooler — connects to the replica(s)
apiVersion: postgresql.cnpg.io/v1
kind: Pooler
metadata:
  name: postgres-pooler-ro
  namespace: data
spec:
  cluster:
    name: postgres-cluster
  # "ro" targets read-only replica instances only
  type: ro
  instances: 2

  pgbouncer:
    poolMode: transaction
    parameters:
      max_client_conn: "200"
      default_pool_size: "25"
      reserve_pool_size: "5"
      reserve_pool_timeout: "5"
      server_idle_timeout: "600"
      client_idle_timeout: "600"