IBM Support

pgsql filling up /var partition



pgsql filling up /var partition

Resolving The Problem

We have encountered an issue at a customer site where pgsql is filling up the /var partition, causing pgsql to fail, and unable to restart. Specifically, the /var/lib/pgsql/9.0/data/pg_wal (the write-ahead log directory) has filled up due to a 16 MB log file being written every 10 minutes. In an install at a different site, a log file is only being written two to three times a day. No options in the postgresql.conf file have been changed.

This is because the postgresql WAL log archive mode set to on and causes all WAL log be saved in filesystem and make the files system run out of space, and therefore causes postgresql down and all kusu commands failes.
The solution for this issue is:
1. Stop postgresql on installer:
# service postgresql-9.0 stop
2. Remove all files under /var/lib/pgsql/9.0/data/pg_wal/
3. edit /var/lib/pgsql/9.0/data/postgresql.conf and change the line of
archive_command = 'cp %p /var/lib/pgsql/9.0/data/pg_wal/%f'
archive_command = '/bin/true'
4. startup postgresql on installer:
# service postgresql-9.0 start

[{"Product":{"code":"SSZUCA","label":"IBM Spectrum Cluster Foundation"},"Business Unit":{"code":"BU010","label":"Systems - Storage"},"Component":"--","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"3.0.1","Edition":""},{"Product":{"code":"SSZUCA","label":"IBM Spectrum Cluster Foundation"},"Business Unit":{"code":"BU010","label":"Systems - Storage"},"Component":null,"Platform":[{"code":"","label":""}],"Version":"","Edition":""}]

Document Information

Modified date:
16 September 2018