Files
home-ops/cluster/apps/database/cloudnative-pg/cluster.yaml
2023-05-18 00:51:02 -05:00

56 lines
1.3 KiB
YAML

---
apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: postgres
namespace: database
spec:
instances: 3
primaryUpdateStrategy: unsupervised
storage:
size: 15Gi
storageClass: ceph-block
superuserSecret:
name: postgres-superuser
bootstrap:
recovery:
source: postgres-backup
postgresql:
parameters:
max_connections: "800"
shared_buffers: "512MB"
monitoring:
enablePodMonitor: true
backup:
retentionPolicy: 30d
barmanObjectStore:
wal:
compression: bzip2
maxParallel: 8
destinationPath: s3://postgresql/
endpointURL: http://minio.default:9000
serverName: "postgres-v2"
s3Credentials:
accessKeyId:
name: postgres-minio
key: MINIO_ACCESS_KEY
secretAccessKey:
name: postgres-minio
key: MINIO_SECRET_KEY
externalClusters:
- name: postgres-backup
barmanObjectStore:
wal:
compression: bzip2
maxParallel: 8
destinationPath: s3://postgresql/
endpointURL: http://minio.default:9000
serverName: "postgres-v1"
s3Credentials:
accessKeyId:
name: postgres-minio
key: MINIO_ACCESS_KEY
secretAccessKey:
name: postgres-minio
key: MINIO_SECRET_KEY