Rails 4 - How To Use Sqlite3 In Development And Postgresql In Production W/heroku

I am trying to deploy to Heroku but can't because the default sqlite3 server is still in place. Detected sqlite3 gem which is not supported on Heroku. https://devcenter.herok

Solution 1:

Don't do it. You are just going to run into problems down the road. Use the same database in production and development. There are a lot of resources available in documenting the switch from a sqlite to postgres database.

Take the time and switch.

Have a look at this Rails Cast.

http://railscasts.com/episodes/342-migrating-to-postgresql?view=asciicast

Solution 2:

Try using this for your production DB

production:adapter:postgresqlhost:localhostencoding:unicodedatabase:my_production_databasepool:5username:password:

You can leave username and password blank