V Rahul
By V Rahul

How to Install Postgres on Mac

How to Install Postgres on Mac

How to Install Postgres on Mac


 

For Mac, what would change is the method of installing postgres

If you already have Homebrew installed, you can install postgress with the command below, if you don’t have Homebrew installed click here to install it.

 

1
2
3
4
5
$ brew update

$ brew install postgresql

 

Step 1: Create postgres user:

1
2
3
$ sudo -u postgres createuser --interactive

You should see prompts as shown below:

1
2
3
4
5
Enter name of role to add: test

Shall the new role be a superuser? (y/n) y

 

Step 2: Create database

1
2
3
$ sudo -u postgres createdb test

1
2
3
4
5
$ sudo -u test psql



 

Step 3: Assign password to the postgres user

1
2
3
4
5
6
7
8
9
$ sudo -u postgres psql





postgres=# ALTER USER test with PASSWORD 'your-new-password';

Note: Creating a new postgres user is optional, you can make do with the default postgres user if you are want.

 

1
2
3
4
5
6
7
8
9
10
11
12
13
$ sudo -u postgres createdb test // or  $ createdb test



$ sudo -u postgres psql



postgres=# ALTER USER postgres with PASSWORD 'your-new-password';



Then, your connection string would be postgres://postgres:your-new-password@localhost:5432/test

 

Thanks for reading!