Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 10 down vote favorite
2

I'm a DB noob so please be kind with me.

I'm having some issues pushing my SQLite DB to Heroku via taps gem. Talking with them, they told me one of the solutions could be converting locally my DB from SQLite to PostgreSQL. Is there an easy way to do so?

Thanks

More info: - DB from Rails app - I'm on Mac OS X - Just installed PostgreSQL via macports

share|improve this question
 
I'll do my best –  Leonardo Dario Perna Nov 24 '10 at 11:40
1  
Now there's a better way - use the taps gem as described in railscasts.com/episodes/342-migrating-to-postgresql –  jpwynn Oct 14 '12 at 20:28

1 Answer

up vote 8 down vote accepted

sqlite3 development.db .dump | psql dbname username

share|improve this answer
2  
note that some datatypes need to be converted ,stackoverflow.com/a/4581921/1099531 –  Pineapple Under the Sea Sep 7 '12 at 6:51

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.