Heroku: Dump Postgres database into local SQLite3 database for Rails project

Question

Is there way to dump heroku postgres database and import the data into my local SQLite database?

I tried using https://github.com/ludicast/yaml_db and heroku db:pull with no success. I am developing on Windows 7.

Are you only after the data? You could export data as csv from Postgres and import data as csv to SQLite3. — epylinkn, Jul 17 '13 at 11:58
Figuring out how to use Postgres in Dev is also probably a worthwhile experiment - it runs natively on Windows postgresql.org/download. — mikeryz, Jul 17 '13 at 14:57

Logesh · Accepted Answer · 2013-07-17 13:45:55Z

up vote 2 down vote accepted

Please read through

and follow those to export.

answered Jul 17 '13 at 13:45

Logesh
247118

This is one of my favorites Heroku blog posts. – mikeryz Jul 17 '13 at 14:55

Well I did install Postgres. It is gonna be a lesson not to sidestep the problems. Thank you all. – ivs Jul 18 '13 at 5:57

1 Answer