95 lines
2.1 KiB
YAML
95 lines
2.1 KiB
YAML
kind: "postgresql"
|
|
apiVersion: "acid.zalan.do/v1"
|
|
metadata:
|
|
name: "rm-psql"
|
|
labels:
|
|
team: rm
|
|
app: rm-pgsql
|
|
resource-group: rm-pgsql
|
|
spec:
|
|
teamId: "rm"
|
|
dockerImage: ghcr.io/zalando/spilo-16:3.2-p2
|
|
numberOfInstances: 2
|
|
spiloRunAsUser: 101
|
|
spiloRunAsGroup: 103
|
|
spiloFSGroup: 103
|
|
postgresql:
|
|
version: "16"
|
|
parameters:
|
|
hot_standby_feedback: "on"
|
|
max_standby_archive_delay: 300s
|
|
max_standby_streaming_delay: 300s
|
|
max_connections: "300"
|
|
log_rotation_size: '1024000'
|
|
log_min_duration_statement: '1000'
|
|
volume:
|
|
size: "5Gi"
|
|
storageClass: "longhorn"
|
|
users:
|
|
rmu:
|
|
- superuser
|
|
- createdb
|
|
preparedDatabases:
|
|
rm:
|
|
defaultUsers: true
|
|
extensions:
|
|
pgcrypto: public
|
|
patroni:
|
|
pg_hba:
|
|
- local all all trust
|
|
- host all all 0.0.0.0/0 md5
|
|
- host all all ::1/128 md5
|
|
enableLogicalBackup: false
|
|
enableConnectionPooler: false
|
|
# enableReplicaConnectionPooler: true
|
|
connectionPooler:
|
|
numberOfInstances: 2
|
|
mode: "transaction"
|
|
schema: "pooler"
|
|
user: "pooler"
|
|
resources:
|
|
requests:
|
|
cpu: 300m
|
|
memory: 100Mi
|
|
limits:
|
|
cpu: "1"
|
|
memory: 100Mi
|
|
resources:
|
|
requests:
|
|
cpu: "0.4"
|
|
memory: "500Mi"
|
|
limits:
|
|
cpu: "0.8"
|
|
memory: "1Gi"
|
|
# tolerations:
|
|
# - key: postgres
|
|
# operator: Exists
|
|
# effect: NoSchedule
|
|
sidecars:
|
|
- name: "zalando-exporter"
|
|
image: "wrouesnel/postgres_exporter"
|
|
ports:
|
|
- name: exporter
|
|
containerPort: 9187
|
|
protocol: TCP
|
|
resources:
|
|
limits:
|
|
cpu: 100m
|
|
memory: 256M
|
|
requests:
|
|
cpu: 50m
|
|
memory: 128M
|
|
env:
|
|
- name: "DATA_SOURCE_URI"
|
|
value: "localhost:5432/rm?sslmode=disable"
|
|
- name: "DATA_SOURCE_USER"
|
|
valueFrom:
|
|
secretKeyRef:
|
|
name: postgres.rm-psql
|
|
key: username
|
|
- name: "DATA_SOURCE_PASS"
|
|
valueFrom:
|
|
secretKeyRef:
|
|
name: postgres.rm-psql
|
|
key: password
|