How to migrate from SQLite to PostgreSQL (Rails)

Question

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

Now there's a better way - use the taps gem as described in railscasts.com/episodes/342-migrating-to-postgresql — jpw
– jpw, Commented Oct 14, 2012 at 20:28

jxpx777 · Accepted Answer · 2010-11-22 17:22:07Z

20

sqlite3 development.db .dump | psql dbname username

answered Nov 22, 2010 at 17:22

jxpx777

3,6414 gold badges30 silver badges43 bronze badges

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

2 Comments

Jürgen Paul Over a year ago

note that some datatypes need to be converted ,stackoverflow.com/a/4581921/1099531

franklin Over a year ago

To connect to a psql database: psql -h <host> -p <port> -U <username> <database> You will be prompted for a password.

Mikhail Chuprynski · Accepted Answer · 2016-01-11 16:12:04Z

8

Sequel will help you

gem install sequel

sequel -C sqlite://db/development.sqlite3 postgres://username:password@localhost/dbname

answered Jan 11, 2016 at 16:12

Mikhail Chuprynski

2,5113 gold badges31 silver badges43 bronze badges

1 Comment

NAREN PUSHPARAJU Over a year ago

Was Very helpful

Collectives™ on Stack Overflow

How to migrate from SQLite to PostgreSQL (Rails)

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related