How to setup Postgres Database in Mac

Install and Setup Postgres in Mac

Chirag S P

2022-07-21

In this article we are going to setup PosGresql in Mac.

Setting up PostGresql in Mac is very easy if we make use of Homebrew.

Open terminal and check if Homebrew is installed using below command
```
brew -v
```
If its already installed, Homebrew version should be displayed.
Next, update Homebrew to the latest version using below command
```
brew update
```
Now install PostGres SQL using homebrew command
```
brew install postgresql
```
This will fetch the latest postgres and install it in our system.

Installation will take some time, once completed, we can start the postgresql service.
Now lets start PostGresql

If postgresql is installed correctly, we can start service using below command,
```
brew services start postgresql
```
If service is successfully started we should get a message saying Successfully started postgresql.
Ways to Stop PostGresql

To use postgresql the service should be running. After we are done using postgresql, its good to stop postgresql service, as it consumes a lot of resources.

To stop postgresql use below command
```
brew services stop postgresql
```

Now that we have installed postgresql, we can start configuring the database. The steps to do the same are as shown below,

Start postgresql service using command,
```
brew services start postgresql
```
Next in terminal, type in below command,
```
psql postgres
```
This should log us into postgresql. Here we can input SQL commands
We need to create a new user and setup a role before moving ahead. Type in below command in postgresql terminal to create new user and provide role.
```
CREATE ROLE newUser WITH LOGIN PASSWORD ‘password’;
ALTER ROLE newUser CREATEDB;
```
The above commands will create a user called newUser with login password as password. Also we provided the newly created user with role CREATEDDB.
We can test this user by using below command
```
\q
psql postgres -U newuser
```
Here we first quit the SQL session using \q and login to new SQL session using the second command.

Instead of using the terminal to use postgresql we can use a rich GUI application like PgAdmin.

Go to https://www.pgadmin.org/ and download the PgAdmin installer and install in your system.
After Pgadmin is installed, open PgAdmin application , right click on Server option and create new server. Add below configuration to login to postgresql.
```
host – “localhost”
user – “newuser”
password – “password”
maintenance database – “postgres”
```
A SQL sheet should open. Here we can type in our SQL commands and start using Postgresql.

Some of the issues that we might face when setting up PostgreSQL are as mentioned below,

To resolve this we need delete node modules. Use below command to do the same

sudo chown -R ${LOGNAME}:staff /usr/local/lib/node_modules

then restart postgresql service using below command,

brew services restart postgres

This should fix the issue. Now we can log into postgresql using command


psql postgres -U newuser