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

Before you begin

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

About this task

Important:

You can transfer data from the internal database to an external PostgreSQL database only.

Procedure

  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.