Skip to content

Commit 5f7743f

Browse files
author
zhang
committed
2019-06-12
1 parent 5cb4b2a commit 5f7743f

File tree

4 files changed

+35
-0
lines changed

4 files changed

+35
-0
lines changed

‎README.md

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -63,6 +63,7 @@
6363
- [Jenkins 安装和配置](markdown-file/Jenkins-Install-And-Settings.md)
6464
- [Maven 安装和配置](markdown-file/Maven-Install-And-Settings.md)
6565
- [Nexus 安装和配置](markdown-file/Nexus-Install-And-Settings.md)
66+
- [PostgreSQL 安装和配置](markdown-file/PostgreSQL-Install-And-Settings.md)
6667
- [MySQL 安装和配置](markdown-file/Mysql-Install-And-Settings.md)
6768
- [MySQL 优化](markdown-file/Mysql-Optimize.md)
6869
- [MySQL 测试](markdown-file/Mysql-Test.md)

‎SUMMARY.md

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -42,6 +42,7 @@
4242
* [Jenkins 安装和配置](markdown-file/Jenkins-Install-And-Settings.md)
4343
* [Maven 安装和配置](markdown-file/Maven-Install-And-Settings.md)
4444
* [Nexus 安装和配置](markdown-file/Nexus-Install-And-Settings.md)
45+
* [PostgreSQL 安装和配置](markdown-file/PostgreSQL-Install-And-Settings.md)
4546
* [MySQL 安装和配置](markdown-file/Mysql-Install-And-Settings.md)
4647
* [MySQL 优化](markdown-file/Mysql-Optimize.md)
4748
* [MySQL 测试](markdown-file/Mysql-Test.md)

‎TOC.md

Lines changed: 1 addition & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -40,6 +40,7 @@
4040
- [Jenkins 安装和配置](markdown-file/Jenkins-Install-And-Settings.md)
4141
- [Maven 安装和配置](markdown-file/Maven-Install-And-Settings.md)
4242
- [Nexus 安装和配置](markdown-file/Nexus-Install-And-Settings.md)
43+
- [PostgreSQL 安装和配置](markdown-file/PostgreSQL-Install-And-Settings.md)
4344
- [MySQL 安装和配置](markdown-file/Mysql-Install-And-Settings.md)
4445
- [MySQL 优化](markdown-file/Mysql-Optimize.md)
4546
- [MySQL 测试](markdown-file/Mysql-Test.md)

‎markdown-file/PostgreSQL-Install-And-Settings.md

Lines changed: 32 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,32 @@
1+
# PostgreSQL 安装和配置
2+
3+
4+
## 官网
5+
6+
- 官网：<https://www.postgresql.org/>
7+
- 201906 最新版本
8+
- 12 beat
9+
- 11 release
10+
- 官网 Docker hub：<https://hub.docker.com/_/postgres>
11+
12+
13+
## Docker 安装 PostgreSQL（带挂载）
14+
15+
```
16+
docker run \
17+
-d \
18+
--name pgsql \
19+
-p 5432:5432 \
20+
-e POSTGRES_USER=adg_user \
21+
-e POSTGRES_PASSWORD=adg123456 \
22+
-v ~/docker_data/pgsql/data:/var/lib/postgresql/data \
23+
postgres:11
24+
```
25+
26+
- 连上容器：`docker exec -it pgsql /bin/bash`
27+
- 连上 PostgreSQL：`psql -h 127.0.0.1 -p 5432 -U adg_user`
28+
29+
30+
## 资料
31+
32+
- <https://codeday.me/bug/20180726/203876.html>

0 commit comments

Comments
 (0)