This workshop will be retired on May 1, 2025.

Heads up! To view this whole video, sign in with your Courses Plus account or enroll in your free 7-day trial. Sign In Enroll

Rails and PostgreSQL in Production

Well done!

You have completed Rails and PostgreSQL in Production!

Sign up for Treehouse Back to Library

Installing PostgreSQL in Development

0:57 with Jay McGavren

It's a good idea to test the database you'll use in production in your development environment first. Let's install PostgreSQL on your development system.

MacOS with Homebrew

brew install postgresql
brew services start postgresql

Ubuntu Linux

sudo apt-get install postgresql libpq-dev
sudo -u postgres createuser --superuser <your_dev_username>

Other OSes

Visit the postgresql.org downloads page and click the link to the binary package for your OS.

Related Discussions

Have questions about this video? Start a discussion with the community and Treehouse staff.

Sign up

    Related Discussions

    Have questions about this video? Start a discussion with the community and Treehouse staff.

    Sign up

    It's a good idea to test the database you'll use in production in your 0:00
    development environment first. 0:03
    So we're going to need to install postgresql to our development machine. 0:05
    I'm using Mac OS with homebrew here, but you can see the teacher's 0:09
    notes if you want info on installing it to other operating systems. 0:12
    If you have Mac OS 10 and homebrew, it's as simple as typing 0:16
    brew install and the package you wanna install, postgresql. 0:21
    It will download them and install the software packages it needs, and 0:32
    then when it's complete, it'll print some post install directions for you. 0:35
    You should make sure to read those directions. 0:41
    In this case, there's one command in particular that we need to be sure to 0:43
    run to actually start postgresql and that's brew services start postgresql. 0:47
    I'll just copy and paste it here. 0:51

    You need to sign up for Treehouse in order to download course files.

    Sign up

      You need to sign up for Treehouse in order to set up Workspace

      Sign up