Swap out sqlite for postgres in a fresh Rails install

sqliteToPostgres.md

Gemfile

• Delete the line with sqlite and replace it with:

gem 'pg'

database.yml

• assuming your app name is "ror", replace with:

default: &default
  adapter: postgresql
  username:
  password:
  host: localhost

development:
  <<: *default
  database: ror_development

# Warning: The database defined as "test" will be erased and
# re-generated from your development database when you run "rake".
# Do not set this db to the same as development or production.
test:
  <<: *default
  database: ror_test

production:
  <<: *default
  database: ror_production

Run:

bundle
bin/rake db:setup
bin/rake db:migrate