Live to Code

code to live

Manually Backing up and Restoring a PostgreSQL Database

08 Feb 2013 | ,

I often find I am creating dumps of data and restoring it to another database, but not frequently enough that I can remember the syntax off the top of my head.

Dump PostgreSQL database to a file

$ pg_dump -h [db_host] -c [db_name] > /where/to/dump/db_name_dump.sql

If the database to be restored doesn't already exist, create it

$ psql template1

Restore PostgreSQL database from the dump file

$ psql -h [db_host] [db_name] < db_name_dump.sql