Easy Tutorial
❮ Postgresql Distinct Home ❯

Installing PostgreSQL on Mac OS

Use EnterpriseDB for the download and installation, as EnterpriseDB is the only provider globally offering enterprise-level products and services based on PostgreSQL.

Download link: https://www.enterprisedb.com/downloads/postgres-postgresql-downloads.

Download the postgresql-**-osx.dmg file and double-click the installation file:

You will be prompted to enter your administrator password, enter it, and then the installation wizard will appear:

Next, you will configure some basic settings such as installation directory, extension installation, database directory, user password, port settings, etc. It's generally fine to use the defaults and just click Next:

Finally, click Finish:

Execute the following script to start PostgreSQL.

You can enter the following options yourself, or use the defaults by pressing Enter. For the password, use the one you set during the installation process:

$ /Library/PostgreSQL/11/scripts/runpsql.sh ;exit
Server [localhost]: 
Database [postgres]: 
Port [5432]: 
Username [postgres]: 
Password for user postgres: 
psql (11.3)
Type "help" for help.

postgres=#

pgAdmin 4

Open pgAdmin 4:

Or click the elephant icon in the top right corner of the screen:

The pgAdmin homepage will appear.

Click on the left side Servers > PostgreSQL 10

Enter the password and click OK

The control panel will appear.

❮ Postgresql Distinct Home ❯