How to backup and restore VCO appliance (Postgres)

[#1]

** UPDATE **  New versions of scripts.  Last versions had a typo on the removal of old files.

Hello,

Is there an official KB on how to backup and restore the VCO appliance using the Postgres?  Similar how to backup the VCSA (http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=203450...

Thanks

I do not think there is a KB since the appliance is not supported in production using the embedded DB.

Disclaimer: the following is not an official KB and is totally unsupported! Use it at your own risk!

Backing up/restoring Postgres database in vCO 5.1 appliance is similar to backup/restore of VCSA as described in the above KB article, with the following differences:

• database location -> /var/lib/pgsql/data
• EMB_DB_INSTANCE, EMB_DB_USER, EMB_DB_PASSWORD -> take a look at file /opt/vmo/appliance/dbd/create_db.sql

Hope this helps,

Ilian

Thanks for the help.

I have attached 2 scripts.

bash_backup_vco_vmware.sh (run on the VCO appliance = backs up the vmware database)

bash_transfer_backups_vco.sh (runs on a remote file server = copies the backups to itself)

****Updated scripts.****

Included section to include the .pgpass file instructions

Nice.

Could you upload these 2 scripts in the 'Documents' section of this forum? This way, it will be easier to discover/refer to them in the future.

This document was generated from the following discussion: How to backup and restore VCO appliance (Postgres)