Rails 3.1 - migrating dev from mySQL to PostgreSQL

Question

Till recently i've needed to run the dev environment for my Heroku (postgres) app on mySQL.

Obviously this is not ideal (running dev and production on different dbs) and, as the original restriction has been taken away, i'm looking for the best strategy/instruction-set for moving my dev environment over to postgres and either migrating the mySQL data across, or pulling the production data into the new dev db.

What is the best route?

Thanks in advance for any help or direction!

Neil Middleton · Accepted Answer · 2012-02-08 14:57:03Z

2

Best bet is to take the simple route.

Install postgres
Setup your local codebase to look at the new database
rake db:setup
heroku db:pull --app <your production app>

answered Feb 8, 2012 at 14:57

Neil Middleton

22.3k19 gold badges84 silver badges137 bronze badges

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

Collectives™ on Stack Overflow

Rails 3.1 - migrating dev from mySQL to PostgreSQL

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