Veritas VOM Postgres playground

VOM add system user habdbsync for db service

+DB Connect

su -l habdbsync -c"/opt/VRTSsfmcs/pgsql/bin/psql -p 5636 -d SFMdb3"

+DB Dump

 su -l habdbsync -c"/opt/VRTSsfmcs/pgsql/bin/pg_dump -p 5636 -d SFMdb3" > /tmp/SFMdb3.sql


+GET Service Group Name and Status
connect to db and run
SELECT hc_id, name, state from p_vcs_servicegroup;


 PS
Linux
VOM v7