Troubleshooting PostgreSQL issues


Use the information in this topic to troubleshoot issues related to PostgreSQL: 

PostgreSQL is running out of disk and applications fail to connect to the PostgreSQL server.

Scope

This issue occurs when the pg_wal directory in the PG (Postgres) PVC consumes all the available space in the /data/pg_wal directory.

Workaround

To resolve the issue, make sure that the replication state is active for secondary PostgreSQL instances, check the PostgreSQL logs, and take corrective actions. 
For more information, see PostgreSQL is running out of disk space due to pg_wal (Write-Ahead Logging)

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*