Latest Posts



Translate

Total Pageviews

Wednesday, 24 May 2017

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