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

If your client cannot connect to the vFabric Postgres appliance or to a vFabric Postgres server installed using RPMs, follow these steps to troubleshoot the issue.

1

Ping the server IP from your client.

2

Verify that Postgres 9.1 is running by running the following command on the command line.

ps ax | grep postgres
3

Try to connect a local PostgresSQL client to the vFabric Postgres server.

4

Review the logs in /var/vmware/vpostgres/current/pgdata/pg_log

If the database transactions per seconds are less than expected, follow these steps to troubleshoot the issue.

1

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

2

Look for missing indexes in your SQL queries.

3

Analyze concurrent queries for conflicts.

4

Increase the number of vCPUs and/or memory.

5

As a last resort, turn off synchronous_commit in var/vmware/vpostgres/current/pgdata/postgresql.conf and restart the appliance. Monitor for performance changes. See the Postgres documentation for details.