A chart to provision a Crunchy Postgres cluster.
| Parameter | Description | Default |
|---|---|---|
fullnameOverride |
Override release name | crunchy-postgres |
crunchyImage |
Crunchy Postgres image | |
postgresVersion |
Postgres version | 14 |
| Parameter | Description | Default |
|---|---|---|
instances.name |
Instance name | ha (high availability) |
instances.replicas |
Number of replicas | 2 |
instances.dataVolumeClaimSpec.storage |
Amount of storage for each PVC | 480Mi |
instances.requests.cpu |
CPU requests | 1m |
instances.requests.memory |
Memory requests | 256Mi |
instances.limits.cpu |
CPU limits | 100m |
instances.limits.memory |
Memory limits | 512Mi |
instances.replicaCertCopy.requests.cpu |
replicaCertCopy CPU requests | 1m |
instances.replicaCertCopy.requests.memory |
replicaCertCopyMemory requests | 32Mi |
instances.replicaCertCopy.limits.cpu |
replicaCertCopyCPU limits | 50m |
instances.replicaCertCopy.limits.memory |
replicaCertCopy Memory limits | 64Mi |
pgBackRest site Crunchy pgBackRest docs
| Parameter | Description | Default |
|---|---|---|
pgBackRest.image |
Crunchy pgBackRest | |
pgBackRest.retention |
Number of backups/days to keep depending on retentionFullType | 2 |
pgBackRest.retentionFullType |
Either 'count' or 'time' | count |
pgBackRest.repos.schedules.full |
Full backup schedule | 0 8 * * * |
pgBackRest.repos.schedules.incremental |
Incremental backup schedule | 0 0,4,12,16,20 * * * |
pgBackRest.repos.schedules.volume.addessModes |
Access modes | ReadWriteOnce |
pgBackRest.repos.schedules.volume.storage |
Access modes | 64Mi |
pgBackRest.repos.schedules.volume.storageClassName |
Storage class name modes | netapp-file-backup |
pgBackRest.repoHost.requests.cpu |
CPU requests | 1m |
pgBackRest.repoHost.requests.memory |
Memory requests | 64Mi |
pgBackRest.repoHost.limits.cpu |
CPU limits | 50m |
pgBackRest.repoHost.limits.memory |
Memory limits | 128Mi |
pgBackRest.sidecars.requests.cpu |
sidecars CPU requests | 1m |
pgBackRest.sidecars.requests.memory |
sidecars Memory requests | 64Mi |
pgBackRest.sidecars.limits.cpu |
sidecars CPU limits | 50m |
pgBackRest.sidecars.limits.memory |
sidecars Memory limits | 128Mi |
pgBackRest.s3.enabled |
Enables the s3 repo backups | false |
pgBackRest.s3.createS3Secret |
Creates the s3 secret based on key and keySecret | true |
pgBackRest.s3.s3Secret |
The secret name to be created or read from | s3-pgbackrest |
pgBackRest.s3.s3Path |
The path inside the bucket where the backups will be saved to, set it to / to use the root of the bucket. |
/dbbackup |
pgBackRest.s3.s3UriStyle |
Style of URL to use for S3 communication. More Info | path |
pgBackRest.s3.bucket |
The bucket to use for backups | bucketName |
pgBackRest.s3.endpoint |
The endpoint to use, for example s3.ca-central-1.amazonaws.com | endpointName |
pgBackRest.s3.region |
The region to use, not necessary if your S3 system does not specify one | ca-central-1 |
pgBackRest.s3.key |
The key to use to access the bucket. MUST BE KEPT SECRET | s3KeyValue |
pgBackRest.s3.keySecret |
The key secret for the key set above. MUST BE KEPT SECRET | s3SecretValue |
Patroni docs Crunchy Patroni docs
| Parameter | Description | Default |
|---|---|---|
patroni.postgresql.pg_hba |
pg_hba permissions | "host all all 0.0.0.0/0 md5" |
crunchyImage |
Crunchy Postgres image | ...crunchy-postgres:ubi8-14.7-0 |
patroni.parameters.shared_buffers |
The number of shared memory buffers used by the server | 16MB |
patroni.parameters.wal_buffers |
The number of disk-page buffers in shared memory for WAL | 64KB |
patroni.parameters.min_wal_size |
The minimum size to shrink the WAL to | 32MB |
patroni.parameters.max_wal_size |
Sets the WAL size that triggers a checkpoint | 64MB |
patroni.parameters.max_slot_wal_keep_size |
Sets the maximum WAL size that can be reserved by replication slots | 128MB |
A lightweight connection pooler for PostgreSQL
pgBouncer site Crunchy Postgres pgBouncer docs
| Parameter | Description | Default |
|---|---|---|
proxy.pgBouncer.image |
Crunchy pgBouncer image | |
proxy.pgBouncer.replicas |
Number of replicas | 2 |
proxy.pgBouncer.requests.cpu |
CPU requests | 1m |
proxy.pgBouncer.requests.memory |
Memory requests | 64Mi |
proxy.pgBouncer.limits.cpu |
CPU limits | 50m |
proxy.pgBouncer.limits.memory |
Memory limits | 128Mi |
Crunchy Postgres PG Monitor docs
| Parameter | Description | Default |
|---|---|---|
pgmonitor.enabled |
Enable PG Monitor (currently only PG exporter) | false |
pgmonitor.exporter.requests.cpu |
PG Monitor CPU requests | 1m |
pgmonitor.exporter.requests.memory |
PG Monitor Memory requests | 64Mi |
pgmonitor.exporter.limits.cpu |
PG Monitor CPU limits | 50m |
pgmonitor.exporter.limits.memory |
PG Monitor Memory limits | 128Mi |
A Prometheus exporter for PostgreSQL
| Parameter | Description | Default |
|---|---|---|
pgmonitor.exporter.image |
Crunchy PG Exporter image | |
pgmonitor.exporter.requests.cpu |
CPU requests | 1m |
pgmonitor.exporter.requests.memory |
Memory requests | 64Mi |
pgmonitor.exporter.limits.cpu |
CPU limits | 50m |
pgmonitor.exporterr.limits.memory |
Memory limits | 128Mi |