Docker安装PostgreSQL数据库和管理工具PgAdmin4

1. 拉取postgres镜像

$ docker pull postgres
Using default tag: latest
latest: Pulling from library/postgres
8559a31e96f4: Already exists
04866763fec8: Pull complete
1705d51f48e5: Pull complete
e59f13162b50: Pull complete
f34bb6f66594: Pull complete
cbfb60b6801a: Pull complete
e8207269011b: Pull complete
89bccd0fcae0: Pull complete
d3be4c4d3a6e: Pull complete
6593b341f133: Pull complete
b63c7214eb05: Pull complete
a4594bc5ebc6: Pull complete
462172dd94a5: Pull complete
abac28c8c3a0: Pull complete
Digest: sha256:9ba6355d27ba9cd0acda1e28afaae4a5b7b2301bbbdc91794dcfca95ab08d2ef
Status: Downloaded newer image for postgres:latest
docker.io/library/postgres:latest

2. 运行镜像

# 容器名为postgresql，镜像名为postgres
# 这里设置服务器密码为123321
$ docker run -d -p 5432:5432 --name postgresql -v pgdata:/var/lib/postgresql/data -e  POSTGRES_PASSWORD=123321 postgres

3. 拉取管理工具pgadmin4镜像

$ docker pull dpage/pgadmin4
Using default tag: latest
latest: Pulling from dpage/pgadmin4
cbdbe7a5bc2a: Already exists
26ebcd19a4e3: Already exists
a29d43ca1bb4: Pull complete
979dbbcf63e0: Pull complete
30beed04940c: Pull complete
0c7c2eba55ac: Pull complete
67af176baacb: Pull complete
85ccbf9e1012: Pull complete
5462ca5deb10: Pull complete
3219db5f7c57: Pull complete
a6a4206b7d8b: Pull complete
405796b5c31b: Pull complete
f23d12396540: Pull complete
4518c6b2e553: Pull complete
de136ea9fe52: Pull complete
018ace2369af: Pull complete
ebc726df28b6: Pull complete
Digest: sha256:e653453cbeeba098bae4de9c7c3388278d4b695814f2f6d25ceed2a02ce7887c
Status: Downloaded newer image for dpage/pgadmin4:latest
docker.io/dpage/pgadmin4:latest

4. 运行pgadmin4

# 这里设置pgadmin4 登录邮箱和密码
$ docker run -d -p 5433:80 --name pgadmin4 -e PGADMIN_DEFAULT_EMAIL=123@123.com -e PGADMIN_DEFAULT_PASSWORD=123321 dpage/pgadmin4

在浏览器中打开http://localhost:5433运行pgadmin4管理界面

使用上面设置的邮箱：123@123.com和密码123321登录

配置数据库

• Host name: host.docker.internal 或 host ip
• Username：postgres 默认的
• Password：运行容器配置的密码