Switching Rails app from SQLite to Postgres for local development

Question

I have a little Rails app that is deployed on Heroku. They require a Postgres database, which was not a problem to switch from SQLite3 on their side, but now I can't develop locally without pushing to Heroku every time I want to see changes. I downloaded and installed all of the Postgres assets including the little MenuBar app that keeps a server running and have been all over documentation. Any help?

Dipak Panchal · Accepted Answer · 2012-10-16 07:00:02Z

1

try this

write in your gemfile

group :development do
  gem "sqlite3"
end
group :production do
 gem 'pg'
end

when you are working on development mode then it used sqlite3 and while you are working on production mode then it used pg

answered Oct 16, 2012 at 7:00

Dipak Panchal

6,0344 gold badges34 silver badges69 bronze badges

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

1 Comment

ohayon Over a year ago

i tried that and it didnt seem to work. is there a specific way to get into "development mode" #n00b

Collectives™ on Stack Overflow

Switching Rails app from SQLite to Postgres for local development

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related