current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 1 down vote favorite

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!

share|improve this question

1 Answer 1

up vote 2 down vote accepted

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>
share|improve this answer
    
yep - kept it simple and was pretty fast to do. thanks. –  user1051849 Feb 9 '12 at 13:59

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.