1.
环境信息
.
....................................................................................................................................
2
2. postgresql
.
................................................................................................................................
2
1.
依赖包
.
................................................................................................................................
2
2.
调整内核
.
............................................................................................................................
2
3.
服务配置
.
............................................................................................................................
3
4.
创建用户
.
............................................................................................................................
3
5.
创建目录
.
............................................................................................................................
3
6.
建立
ssh
信任
.
....................................................................................................................
3
7.
环境变量
.
............................................................................................................................
4
8.
编译安装
.
............................................................................................................................
4
9.
初始化实例
.
........................................................................................................................
5
10.
运行参数
.
..........................................................................................................................
5
11.
启动实例
.
..........................................................................................................................
7
12.
复制备机
.
..........................................................................................................................
7
13.
注册服务
.
..........................................................................................................................
8
3. pgpool
.........................................................................................................................................
8
1.
创建用户
.
............................................................................................................................
8
2.
开放权限
.
............................................................................................................................
8
3.
环境变量
.
............................................................................................................................
8
4.
建立
ssh
信任
.
....................................................................................................................
9
5.
编译安装
.
............................................................................................................................
9
6.
加载
extension
.
.................................................................................................................
9
7.
配置
pgpool.conf
.
.............................................................................................................
9
8.
配置
pool_hba.conf
.
.......................................................................................................
1
1
9.
配置
pcp.conf
.
.................................................................................................................
1
1
10.
启动
pgpool
.
...................................................................................................................
1
1
11.
状态检查
.
........................................................................................................................
1
1