Setting up Rails to use PostgreSQL
A short guide to setting up your Rails project to use the PostgreSQL database
The default database that comes out of the box is Sqlite3 but what if you want to use PostgreSQL?
This is a quick guide on how to configure your Yaml file to allow for PostgreSQL.
First off add the PostgreSQL Gem to your Gemfile.
Then navigate to
RAILS_ROOT >> config >> database.yml
In here you will want to add your details for PostgreSQL.
You can set what you want each database to be called and it’s really important that your test database is not called the same as your development or production databases as the test database is wiped clean after each test is ran.
To avoid most of this setup though you can just run the following command when you set up a new Rails project:
With this command Rails will put the PostgreSQL Gem into your Gemfile and do a lot of the setup in
database.yml for you. Clever old Rails!