Total Pageviews

My YouTube Channel

Wednesday, 24 May 2017

Monitor PostgreSQL DB Status in vSphere 6.5

SSH > vCenter Server Appliance > Login


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

No comments:

Post a Comment