5.4. Install PostgreSQL on Mac OS

发布时间 :2025-10-25 12:30:48 UTC      

Using EnterpriseDB to download and install, EnterpriseDB is the only vendor in the world that offers PostgreSQL-based enterprise-class products and services.

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

Image0

download postgresql-****-osx.dmg File, double-click the installation file:

Image1

At this point, you will be asked to enter the administrator password, enter it, and then pop up the installation wizard:

Image2

Next, there are some basic configurations, such as installation directory, extension installation, database directory, user password, port settings, etc. Generally, just use the default, directly point Next:

Image3

Finally, click Finish:

Image4

Execute the following script to start PostgreSQL.

You can enter the following options yourself, or use the default, enter by default, and the password is the password you just 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=#

Image5

5.4.1. PgAdmin 4

打开 pgAdmin 4:

Image6

Or click the icon of the elephant avatar at the top right of the screen:

Image7

The pgAdmin home page is as follows

Image8

点击左侧的 Servers > Postgre SQL 10

Image9

输入密码,点击 OK 即可

Image10

The control panel is as follows

Image11

Principles, Technologies, and Methods of Geographic Information Systems  102

In recent years, Geographic Information Systems (GIS) have undergone rapid development in both theoretical and practical dimensions. GIS has been widely applied for modeling and decision-making support across various fields such as urban management, regional planning, and environmental remediation, establishing geographic information as a vital component of the information era. The introduction of the “Digital Earth” concept has further accelerated the advancement of GIS, which serves as its technical foundation. Concurrently, scholars have been dedicated to theoretical research in areas like spatial cognition, spatial data uncertainty, and the formalization of spatial relationships. This reflects the dual nature of GIS as both an applied technology and an academic discipline, with the two aspects forming a mutually reinforcing cycle of progress.