Search code examples
ruby-on-railssqlitepostgresqlherokudatabase-migration

How to migrate from SQLite to PostgreSQL (Rails)

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

Solution

  • sqlite3 development.db .dump | psql dbname username