VoyenceControl: /var partition filling up due to excessive logging in server.postmaster

Products

• VMware

Issue/Introduction

Symptoms:


How do I disable the escape string warnings for postgres?

/var partition filling up due to excessive logging in server.postmaster

WARNING (server.postmaster):

WARNING:  nonstandard use of \\ in a string literal at character

Environment

VMware Smart Assurance - NCM

Cause

The escape_string_warning configuration parameter for postgres is on by default and can, in certain environments, cause excessive logging in the server.postmaster log.

Resolution

You will need to disable the escape_string_warning configuration parameter for postgres.
 

1. Open the $VOYENCE_HOME/db/controldb/data/postgresql.conf file for editing.
    
2. Locate the escape_string_warning parameter.  It should look similar to the below line:
   
   #escape_string_warning = off
   
    
3. Remove the comment from the line so that it reads as follows:
   
   escape_string_warning = off
   
    
4. Save your changes to the file.
   
    
5. Restart all services on the application/database server.
   
   /etc/init.d/vcmaster restart