Bummer! This is just a preview. You need to be signed in with a Pro account to view the entire video.

Preview

Start a free Basic trial
to watch this video

Sign up for Treehouse

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.

  • 0:00

    It's a good idea to test the database you'll use in production in your

  • 0:03

    development environment first.

  • 0:05

    So we're going to need to install postgresql to our development machine.

  • 0:09

    I'm using Mac OS with homebrew here, but you can see the teacher's

  • 0:12

    notes if you want info on installing it to other operating systems.

  • 0:16

    If you have Mac OS 10 and homebrew, it's as simple as typing

  • 0:21

    brew install and the package you wanna install, postgresql.

  • 0:32

    It will download them and install the software packages it needs, and

  • 0:35

    then when it's complete, it'll print some post install directions for you.

  • 0:41

    You should make sure to read those directions.

  • 0:43

    In this case, there's one command in particular that we need to be sure to

  • 0:47

    run to actually start postgresql and that's brew services start postgresql.

  • 0:51

    I'll just copy and paste it here.

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

Sign up