After upgrading to vCenter Server Appliance 5.5 update 2, you experience these symptoms: The vCenter Server Appliance fails or becomes unresponsive In the /storage/db/vpostgres/pg_log file, you see large number of entries similar to:
This issue is resolved in vCenter Server 5.5 Update 3b.
In the vCenter Server Appliance 5.5 update 2, the ODBC driver used to connect to the embedded vCenter Server database was updated to vPostgres ODBC 9.0.17.0 to correct a runtime error in previous versions of the vCenter Server Appliance. However, the current version installed has led to an increase in logging in the pg_log file. Resolution This issue is resolved in vCenter Server 5.5 Update 3b, available at VMware Downloads.
To work around this issue if you do not want to upgrade, modify the message level of the postgresql.conf file to error.
To modify the postgresql.conf file: Backup the vpostgres database or create a snapshot of the virtual machine. For more information, see Backing up and restoring the vCenter Server Appliance vPostgres database (2034505). Log in to the vCenter Server Appliance console as root. Run this command to stop the VMware VitrualCenter Server service:
service vmware-vpxd stop
Run this command to stop the embedded vCenter Server database service:
service vmware-vpostgres stop
Run this command to backup the original postgresql.conf file:
cp /storage/db/vpostgres/postgresql.conf /storage/db/vpostgres/postgresql.conf.orig
Open the /storage/db/vpostgres/postgresql.conf file in a text editor and locate this line:
log_min_messages = warning
Modify the line from step 5 to:
#log_min_messages = warning
log_min_messages = error
Save the changes and exit the text editor.
Remove all but the two newest log files from the /storage/db/vpostgres/pg_log file using the rm command:
For example:
rm /storage/db/vpostgres/pg_log/postgresql-YYYY-MM-DD_xxxxxx.log
Run this command to start the embedded vCenter Server database service:
service vmware-vpostgres start
Run this command to start the VMware VirtualCenter Server service:
service vmware-vpxd start