PostgreSQL import from backup

09.Apr.2014

To import database dump into your PostgreSQL database, you can use following command:

1
pg_restore -i -h localhost -p 5432 -U username -d old_db -v database_backup.sql

Notice that port and username may be different for your PostgreSQL installation.