Install Postgres locally in MacOS

Reading Time: < 1 minutes

Install using Brew package manager

brew update
brew install postgres

Config file


Useful commands

brew services start postgresql
brew services restart postgresql
brew services stop postgresql

psql command

“psql is a terminal-based front-end to PostgreSQL. It enables you to type in queries interactively, issue them to PostgreSQL, and see the query results.”

Run psql and you will see the following error

$ psql
psql: error: could not connect to server: FATAL:  database "andrescanavesi" does not exist

So let’s create a db with that name in order to play with it

createdb andrescanavesi

List available databases


Use a specific database

c andrescanavesi 

List tables


See your version

SELECT version();


About the author

Andrés Canavesi
Andrés Canavesi

Software Engineer with 15+ experience in software development, specialized in Salesforce, Java and Node.js.

Related posts

Leave a Reply

%d bloggers like this: