← back to oleingemann.com
← 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