Postgres partition /var/vmware/vpostgres full due to postgresql log file

Products

• VMware Cloud Director

Issue/Introduction

• The Postgres partition /var/vmware/vpostgres on the VMware Cloud Director (VCD) cell is full.
• The partition is full due the /var/vmware/vpostgres/14/pgdata/log/postgresql-##.log  huge size.
• Despite increasing the embedded PostgreSQL capacity as per documentation Increase the Capacity of the Embedded PostgreSQL Database on Your VMware Cloud Director Appliance ,the partition gets full quickly.

Environment

VMware Cloud Director 10.6.x

Cause

The log_statement parameter in in Postgres was temporary changed to 'all' for troubleshooting purposes leading to excessive log generation and disk space.

Resolution

Check the log_statement parameter in PostgreSQ as below:

1. SSH the VCD primary cell
2. Connect to the database running the command below:
   
   db
   
   
3. Run the query below to check the log_statement configuration:
   
   SHOW log_statement;
   
   By default the log_statement parameter in VCD postgres DB is set to "none" and below is the expected result:
   
   vcloud=# SHOW log_statement;
 log_statement 
---------------
 none
(1 row)


4. If the result from step 3 shows one of the below options proceed with step 5:
   
   ddl
mod
all
   
   

5. SSH the VCD primary cell

6. Connect to the database running the command below:

   db

    

7. Run the query below to set the log_statement back to none as default:

   SET log_statement = 'none';


8. Run the query below to check the log_statement has been correctly reconfigured:
   
   SHOW log_statement;