Seems this isn't documented very well or discussed much online from what I can see.
Here's what I found so far:
commands to backup postgress database on the Analytics VM (dbase VM):
#su - postgres
#pg_dumpall | gzip -c > /data/pgsql/vcops_pg_dump_all_gz
Then I'll backup the VMs.
To automate this I'll put the postgress dumpall command in to run under the postgres cron scheduler.
Kudos to postgress help from NixCraft.
VMware Docs (see 'round page 116)
So to restore I'd recover the VMs using my backup software, and if needed go back to the database dump and recover it with:
(stop vCOPs service if not already stopped first) from admin linux login, run "vcops-admin start"
#gunzip /data/pgsql/vcops_pg_dump_all.gz
#psql -f /data/pgsql/vcops_pg_dump_all postgres
