Migrating Data from Another Database

The new PostgreSQL High Availability setup has the database mmsuite but with no data. If you have a pre-existing database, you need to migrate the data to the new setup.

Create a dump using pg_dump:

pg_dump -U postgres -p [pre-existing-database-port] -O mmsuite > mmsuite_dump.sql

If you’ve already created the mmsuite database on the HA PostgreSQL server, you should first delete it and then recreate it:

psql -U postgres -p [port] -c "DROP DATABASE mmsuite;"
psql -U postgres -p [port] -c "CREATE DATABASE mmsuite ENCODING = 'UTF8' LC_CTYPE = 'POSIX' LC_COLLATE='POSIX' TEMPLATE template0;"

Finally execute the commands in the dump file to copy the data:

psql -U postgres -p [port] -d mmsuite -f mmsuite_dump.sql