If your deployment uses an internal database and you plan to switch to an external database, you can extract the existing data from the database and add it to a new external database.

Prepare the external database server. See Configure a PostgreSQL Database.

1

Log in as the root user.

2

Go to the /opt/vmware/vpostgres/current/bin directory.

3

Run the ./pg_dump -U postgres -w --clean -f /tmp/db_dump.data saas command.

4

Copy the db_dump.data file to the newly prepared external database server.

scp /tmp/db_dump.data

5

Log in as the root user on the external database server.

6

Go to the /opt/vmware/vpostgres/current/bin directory.

7

Run the db_dump.data command.

./psql -U postgres -w -d saas -f /tmp/db_dump.data

You might see DROP and ALTER commands while the db_dump.data command runs.