官方文档:
https://www.postgresql.org/download/macosx/

可以看到,官方推荐的是【EDB,EnterpriseDB】:

Download the installer certified by EDB for all supported PostgreSQL versions.

EnterpriseDB的PostgreSQL页面:
https://www.enterprisedb.com/products/postgresql-databases

进入下载页面:
https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

下载你需要的版本:

下载完成后,在本地执行安装:

装好了以后:

然后,在命令行中查看:

adamhuan:shell/ $ ps -ef | grep postgre                                                                                                                                 [17:42:19]
  502 38224 38001   0  5:21PM ??         0:00.00 postgres: logger   
  502 38227 38001   0  5:21PM ??         0:00.01 postgres: checkpointer   
  502 38228 38001   0  5:21PM ??         0:00.03 postgres: background writer   
  502 38229 38001   0  5:21PM ??         0:00.01 postgres: walwriter   
  502 38230 38001   0  5:21PM ??         0:00.04 postgres: autovacuum launcher   
  502 38231 38001   0  5:21PM ??         0:00.20 postgres: stats collector   
  502 38232 38001   0  5:21PM ??         0:00.00 postgres: logical replication launcher   
  501 52925 21340   0  5:42PM ttys005    0:00.00 grep --color=auto --exclude-dir=.bzr --exclude-dir=CVS --exclude-dir=.git --exclude-dir=.hg --exclude-dir=.svn --exclude-dir=.idea --exclude-dir=.tox postgre
adamhuan:shell/ $ 
adamhuan:shell/ $ netstat -an | grep 5432                                                                                                                               [17:42:48]
tcp4       0      0  *.5432                 *.*                    LISTEN     
tcp6       0      0  *.5432                 *.*                    LISTEN     
tcp4       0      0  127.0.0.1.62258        127.0.0.1.5432         TIME_WAIT  
8082c9a9cef34101 stream      0      0 8082c9a03229fbb1                0                0                0 /tmp/.s.PGSQL.5432
adamhuan:shell/ $ 

登录PostgreSQL:

在Apple MacOS上面安装完成EnterpriseDB,也就是PostgreSQL之后,默认的BASE目录是:/Library/PostgreSQL/14
具体如下:
adamhuan:14/ $ pwd                                                                                                                                                      [18:07:07]
/Library/PostgreSQL/14
adamhuan:14/ $                                                                                                                                                          [18:07:09]
adamhuan:14/ $ ls -ltr                                                                                                                                                  [18:07:09]
total 400
-rw-r--r--   1 root      daemon  61721 Nov  9 13:43 commandlinetools_3rd_party_licenses.txt
-rw-r--r--   1 root      daemon  70256 Nov  9 13:43 pgAdmin_3rd_party_licenses.txt
-rw-r--r--   1 root      daemon  47762 Nov  9 13:43 StackBuilder_3rd_party_licenses.txt
-rw-r--r--   1 root      daemon   1388 Nov  9 13:44 server_license.txt
-rw-r--r--   1 root      daemon   1026 Nov  9 13:44 pgAdmin_license.txt
drwxr-xr-x   4 root      daemon    128 Nov 23 19:50 share
drwxr-xr-x   3 root      daemon     96 Nov 23 19:50 pgAdmin 4.app
drwxr-xr-x   3 root      daemon     96 Nov 23 19:50 stackbuilder.app
drwxr-xr-x   6 root      daemon    192 Nov 23 19:50 debug_symbols
drwxr-xr-x   3 root      daemon     96 Nov 23 19:51 uninstall-postgresql.app
drwx------  11 postgres  daemon    352 Nov 24 19:47 Library
drwxr-xr-x   6 root      daemon    192 Dec 29 17:20 doc
drwxr-xr-x  37 root      daemon   1184 Dec 29 17:20 include
drwxr-xr-x   4 root      daemon    128 Dec 29 17:20 installer
drwxr-xr-x  37 root      daemon   1184 Dec 29 17:21 bin
drwxr-xr-x  55 root      daemon   1760 Dec 29 17:21 lib
-rwxr-xr-x   1 root      daemon    371 Dec 29 17:21 pg_env.sh
drwxr-xr-x  12 root      daemon    384 Dec 29 17:21 scripts
-rw-r--r--   1 root      daemon   1160 Dec 29 17:21 installation_summary.log
drwx------  28 postgres  daemon    896 Dec 29 17:21 data
adamhuan:14/ $     

要访问,要登录PostgreSQL:
adamhuan:14/ $ ./scripts/runpsql.sh                                                                                                                                     [18:09:14]
Server [localhost]: 
Database [postgres]: 
Port [5432]: 
Username [postgres]: 
Password for user postgres: 
psql (14.1)
Type "help" for help.

postgres=# \l
                                  List of databases
   Name    |  Owner   | Encoding |   Collate   |    Ctype    |   Access privileges   
-----------+----------+----------+-------------+-------------+-----------------------
 adamhuan  | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | 
 postgres  | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | 
 template0 | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 template1 | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/postgres          +
           |          |          |             |             | postgres=CTc/postgres
 test      | postgres | UTF8     | zh_CN.UTF-8 | zh_CN.UTF-8 | 
(5 rows)

postgres=# \q
adamhuan:14/ $ 

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

隐藏
变装