Postgresql: VMware vPostgres Cheatsheet

Some of the default vPostgres binaries and data paths for VMware products. Feel free to source the environment file. These are just for my own handy references.

If you have default port other than 5432, you may need that in the startup as well.

vCenter
Home	/opt/vmware/vpostgres/9.3/bin/
Data	/storage/db/vpostgres
Start	/opt/vmware/vpostgres/9.3/bin/postgres -D /storage/db/vpostgres

vMware vCloud Automation Center (VCAC)
Home	/opt/vmware/vpostgres/9.2/bin/
Data	/var/vmware/vpostgres/current/pgdata
Start	/opt/vmware/vpostgres/9.2/bin/pg_ctl -D /var/vmware/vpostgres/current/pgdata start

Hyperic
Home	/opt/vmware/vpostgres/9.1/bin
Data	/opt/vmware/vpostgres/9.1/data
Start	/opt/vmware/vpostgres/current/bin/pg_ctl -D ../data start
Stop	/opt/vmware/vpostgres/current/bin/pg_ctl -D ../data stop

vCloud Director
Home	/opt/vmware/vpostgres/9.0/bin
Data	Opt/aurora/data/db
Start	(as root) service aurora_mon start

NSX
Home	/opt/vmware/vpostgres/9.1/bin/
Data	/common/db/vshield
Start	sudo -u xxxxx /opt/vmware/vpostgres/9.1/bin/pg_ctl -D /common/db/vshield start