We will be going through how to setup Postgres locally on mac. We will cover the following:

• Starting Postgres
• Using psql to interact with database in command-line
• Creating your first database.
• Manage Data (Create Table, Inserting Data, Viewing Data)
• Stopping Postgres

Let's start off with making sure we have Postgres installed locally. Open up terminal on mac and run postgres --version. You should see the version information outputted.

If you don't see the postgres version or need to install it still. Check out the Install Postgres on Mac post. Now that we have that out of the way, let's continue.

Step 1

In terminal, run the following command. It will start Postgres locally.
brew services start postgresql

Step 2

Next, let's go into the Postgres server now that it's up and running. Run the following:

PostGres has grown a lot recently in popularity, as a free alternative to enterprise relational databases such as Oracle SQL, and also as a database to get a new application cranking very quickly that comes filled with features and easy to setup.

Now let's get one of the best databases ever up and running on your Mac. As a developer, I think you owe it to yourself to have Postgres installed :)

1. Open Terminal

2.   Now copy and paste brew install postgresql then hit enter.

3.    Last, in Terminal, copy and paste postgres --version and hit enter.

You should see the PostGres version output in your console. This is good news. You're ready to go. You can create your database and start storing data. Checkout PostGres Documentation to learn more about all you can do with the PostGres database.