Increasing the PostgreSQL
archive_timeout on OpenShift and Cloud Pak for
Increase change the
so that accumulated wal files do not cause a disk-space issue during a network
About this task
PostgreSQL sends its wal archives to the backup location (S3 or local PVC)
whenever the configured
archive_timeout period elapses. By default, the
archive_timeout is set to 60 seconds. During a network outage, the files cannot be
transferred and instead accumulate on the current server, and could cause a disk-space issue.
archive_timeout value helps to mitigate this issue by creating
archive files less frequently.
For information on tracking the Postgres disk space, see Monitoring Postgres disk usage.
Complete the following steps to increase the PostgreSQL
Get the name of the
pghaconfig map by running the following command:
oc -n <APIC_namespace> get cm -l pgha-config='true'
The response looks like the following example:
NAME DATA AGE apis-produ-d18f3f0-0d18f3f0-postgres-pgha-config 5 22d
Edit the config map by running the following command:
oc -n <APIC_namespace> edit configmap <config-map-name>
In the command, replace
NAMEreturned in step 1.
The value must be an integer, and represents the number of seconds that must elapse before the archive file is generated.
- Save the file and exit the editor.
The configuration is updated automatically; archives will be generated and pushed every