Transfer local PostgreSql database to heroku

Question

I uploaded my application to heroku, recently im using PostgreSql also on my local machine, now i would like to know how i also can push my database with the existing records to Heroku? Is this possible?

Also it would be intresting if i can adopt my sql database to PostgreSql?

Thanks!

possible duplicate of Transfer initial PostgreSQL database from development to Heroku production — mu is too short
– mu is too short, Commented Nov 3, 2013 at 19:49

David Aldridge · Accepted Answer · 2013-11-03 19:49:52Z

1

You can use pg_restore to push a dump file from a local database to an Heroku database.

If you go to the Herokue Postgres page for the database they give connection settings for a number of utilities, one of them being pg_restore. The command will look similar to:

PGPASSWORD=jyb4fhiwyeioghfwc7hw pg_restore --verbose --clean --no-acl --no-owner -h ec2-23-254-171-15.eu-west-1.compute.amazonaws.com -U hqfy134fblqwheb -d sdjhufhqwuf -p 5432 [YOUR_DATA_FILE]

Just substitute in the name of your local file. If the Heroku database is completely empty you can omit the -clean option and save some time.

answered Nov 3, 2013 at 19:49

David Aldridge

52.5k8 gold badges73 silver badges99 bronze badges

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

Collectives™ on Stack Overflow

Transfer local PostgreSql database to heroku

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related