Monitor PostgreSQL DB Status in vSphere 6.5

SSH > vCenter Server Appliance > Login

shell

ps aux | grep postgres

• The executable directory is /opt/vmware/vpostgres/current/bin.
• The database directory is /storage/db/vpostgres.

If your database were clustered, you would also see a -p XXXX string with the port number for
TCP/IP communication between the cluster nodes at the end of the first line.

• see a logger process listed, which indicates that PostgreSQL logging is enabled and running.
• checkpointer
• writer
• wal writer (write-ahead logging writer) 
• autovacuum launcher
• stats collector