How to migrate PostgreSQL data to Heroku

Question

I'm moving from EC2 to Heroku, and I got a shared database so I cannot use psql to restore the database.

Any ideas or strategies to move this?

The only option I can think of right now would be to dump the data in Django (they use JSON for that) and migrate.

I have a Django app and a 20GB shared PostgreSQL database.

Dmitry Shevchenko · Accepted Answer · 2012-03-05 05:31:59Z

1

answered Mar 5, 2012 at 5:31

Dmitry Shevchenko

32.5k10 gold badges60 silver badges63 bronze badges

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

2 Comments

It's a shame that this method means that you have to put the data at URL, such as S3. Is there a solution to push locally stored data up to Heroku?

@GreenAsJade not that I know of, you could put it in dropbox or something.

John Beynon · Accepted Answer · 2012-03-04 21:41:52Z

0

First up, I'll just state I'm a Ruby guy not Python so can't talk authoritatively for Python but may be able to point you in the right direction.

To get data into Heroku shared DBs you have two options,

heroku db:push - May be Ruby only but allows you to push contents of local db (whatever it is) into your shared database on Heroku.
heroku pgbackups:restore - allows you to restore a dump of a PostGres database into your heroku db.

If you're already using mySQL then you could look at ClearDB addon as a solution - this permits direct access via mySQL tools.

answered Mar 4, 2012 at 21:41

John Beynon

37.5k8 gold badges92 silver badges97 bronze badges