hello
How to migrate a PostgreSQL Database
How to migrate a PostgreSQL Database
Migrate a PostgreSQL Database
Migrate a PostgreSQL database using pg_dump and psql #
- Take a backup of your database
Use the command below to back up your database.
Code block
pg_dump -h <hostname> -p <port> -U <dbuser> -d <database> -f <backup file path>
Example:
pg_dump -h postgresql-5428-0.cloudclusters.net -p 10018 -U pgs -d pgs -f /tmp/pgs.bak
- Restore the database
psql -h <hostname> -p <port> -U <dbuser> -d <database> -f <desired file path>`
Example:
psql -h postgresql-5428-0.cloudclusters.net -p 10018 -U pgs -d pgs -f /tmp/pgs.bak