Rails switch database

Question

I've found info explaining how to set up a Rails application from the beginning using a PostgreSQL database. But I have an application already built. Any advice on steps to take to change my existing application to use PostgreSQL rather than SQLite?

Answer 1

If you're using Rails 6+ you can do this:

rails db:system:change --to=postgresql

where postgresql would be the DB you want.

This was enabled by this commit.

Answer 2

Install the pg gem in your Gemfile

gem 'pg'

change the database.yml file to use your database ex.

adapter: postgresql
database: db_name
pool:
timeout:
host: localhost
username: username
password: password

db_name, username, and password values are what you have set your postgresql database too