How to restore postgresql db on Heroku

Question

I'm totally new to Heroku and Postgres and I'm trying to figure out how to restore and access the Postgres db in Heroku. I do have backup that taken fro pgAdmin III .backup file.

Any help with how to restore the Postgres db in Heroku would be greatly appreciated.

This solution may be relevant to some people: stackoverflow.com/questions/42433414/… — Nah
– Nah, Commented Feb 24, 2017 at 10:20

user3272686 · Accepted Answer · 2016-04-29 20:55:26Z

2

Restore to local database

Load the dump into your local database using the pg_restore tool. If objects exist in a local copy of the database already, you might run into inconsistencies when doing a pg_restore. Pg_restore does not drop all of the objects in the database when loading the dump. This will usually generate some warnings, due to differences between your Heroku database and a local database, but they are generally safe to ignore.

$ pg_restore --verbose --clean --no-acl --no-owner -h localhost -U myuser -d mydb latest.dump

answered Apr 29, 2016 at 20:55

user3272686

8492 gold badges12 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nick Kahn Over a year ago

i have .backup not dump, how would i create dump?

Collectives™ on Stack Overflow

How to restore postgresql db on Heroku

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related