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.
2
-
Are you only after the data? You could export data as csv from Postgres and import data as csv to SQLite3.epylinkn– epylinkn2013-07-17 11:58:09 +00:00Commented Jul 17, 2013 at 11:58
-
1Figuring out how to use Postgres in Dev is also probably a worthwhile experiment - it runs natively on Windows postgresql.org/download.mikeryz– mikeryz2013-07-17 14:57:17 +00:00Commented Jul 17, 2013 at 14:57
Add a comment
|
1 Answer
Please read through
https://devcenter.heroku.com/articles/heroku-postgres-import-export
and follow those to export.
Though the above link can be used to export alone, it does not have solution for the entire process. So you can look on the similar question and its solution
3 Comments
mikeryz
This is one of my favorites Heroku blog posts.
ivs
Well I did install Postgres. It is gonna be a lesson not to sidestep the problems. Thank you all.
Michael
The question is about exporting a pgsql dumpfile and importing it on sqlite. This documentation page has nothing to do with that, it just shows how to do the first part... the puzzling part is the second one ! I don't understand why this answer is accepted :( !