9.1

Troubleshooting 8

Use the options listed in this section to analyze connection or performance problems.

Issue: Client Cannot Connect

Perform the following steps if your client cannot connect to the vPostgres 9.1 Appliance.

Ping the server IP from your client.

Verify that Postgres 9.1 is using "ps ax | grep post".

Try to connect a local PostgresSQL client to the database.

Review the database logs in /var/vmware/vpostgres/9.1/pgdata/pg_log

Issue: Database Transactions Per Second are Less Than Expected

Make sure your PGDATA VMDK is on a high-performance datastore.

Look for missing indexes in your SQL queries.

Analyze concurrent queries for conflicts.

Increase the number of vCPUs and/or memory.

Test by turning off synchronous_commit in var/vmware/vpostgres/9.1/pgdata/postgresql.conf and restarting

the appliance.

VMware, Inc.