Install PostgreSQL on Mac OS

Install PostgreSQL on Mac OS

Use EnterpriseDB to download and install, EnterpriseDB is the only company in the world that provides enterprise-level products and services based on PostgreSQL.

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

Download postgresql-****-Double-click the installation file after downloading the osx.dmg file:

At this time, you will be prompted to enter the administrator password, just enter it, and then the installation wizard will pop up:

Next is some basic configuration, such as: installation directory, extension installation, database directory, user password, port settings, etc. It is generally recommended to use the default settings and click Next directly:

Finally, click Finish:

Execute the following script to start PostgreSQL.

The following options can be entered manually or use the default settings, just press Enter by default, and the password is 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 icon of the elephant avatar at the upper right corner of the screen:

The pgAdmin homepage is as follows

Click Servers > Postgre SQL on the left side 10

Enter the password and click OK

The control panel is as follows