Migrating your vCloud Director 9.5 SQL Database to PostgreSQL

Before you start the migration its a good idea to snapshot the vCloud Director cells and manually backup the SQL database. Next you need to stop the vCloud Director services. You do this by connecting to each cell via SSH and running the following command.

Service vmware-vcd stop

Next we need to browse to the directory of the cell management tool. Enter the following,

cd /opt/vmware/vcloud-director/bin

Run the ls command and you will see the cell-management-tool located in the directory.

Then run the following command to start the database migration,

./cell-management-tool dbmigrate -dbhost 192.168.1.63 -dbport 5432 -dbuser vcloud -dbname vcloud -dbpassword ‘password123’ -verbose

Replace the dbhost ip with the ip address or hostname of you postgresql server, then update your dbuser account, dbname and your password.

If the migration starts successfully you should see the following output,

Once complete you will see the Database Migration Succeeded prompt. Check that no items failed or skipped.

Next we need to run the reconfigure database command on each of the vCloud Director cells.

/opt/vmware/vcloud-director/bin/cell-management-tool reconfigure-database

Then restart the vcloud director cell.

Service vmware-vcd restart

That’s about it, you have just migrated your vCloud Director SQL database to Postgresql!

LINKEDIN

Leave a Reply

Your email address will not be published. Required fields are marked *

LINKEDIN