← back to oleingemann.com

How to import data a Postgres DB with from a backup file

I use PostgresQL for most of my projects, and hence I need to swap the data, use a backup file or do other types of data migration. I’ll be writing this post while I do this operation so I can save the commands until next time.

Ended up using the following command to load the data from the .dump file

pg_restore -d mylocaldatabase-development /Users/oleingemann/Downloads/db.dump –no-privileges –no-owner

← back to oleingemann.com