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 http://railscasts.com/episodes/342-migrating-to-postgresql — jpw, Oct 14 '12 at 20:28

score 20 · Accepted Answer · answered Nov 22 '10 at 17:22

20

sqlite3 development.db .dump | psql dbname username

answered Nov 22 '10 at 17:22

jxpx777

3,632
4
27
43

7

note that some datatypes need to be converted ,http://stackoverflow.com/a/4581921/1099531 – Jürgen Paul Sep 07 '12 at 06:51
To connect to a psql database: `psql -h -p -U ` You will be prompted for a password. – franklin Mar 11 '16 at 04:23

score 8 · Answer 2 · answered Jan 11 '16 at 16:12

8

Sequel will help you

gem install sequel

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

answered Jan 11 '16 at 16:12

Mikhail Chuprynski

2,404
2
29
42

Was Very helpful – NAREN PUSHPARAJU Aug 31 '18 at 13:35

How to migrate from SQLite to PostgreSQL (Rails)

2 Answers2

Linked