PostgreSQL+PostGIS, installing on a Mac

Step 1. Download the Postgres.app from https://postgresapp.com/

Step 2. Follow the instruction on its website configure the port number(super easy, almost need to do nothing)

Step 3. Download DataGrip from https://www.jetbrains.com/datagrip/ (Nice database IDE and free for students email)

Step 4. Follow the notes on https://www.jetbrains.com/help/datagrip/connecting-to-a-database.html#connect-to-postgresql-database