方案
目录
postgresql ha
方案
...........................................................................................1
1.
方案架构图
....................................................................................................3
2.
环境信息
........................................................................................................4
3.
资源调整
(master/standby).............................................................................5
3.1.
主备节点时钟同步
...............................................................................5
3.2.
配置
sysctl...........................................................................................5
3.3.limit
资源分配
......................................................................................5
3.4.
关闭
selinux........................................................................................5
3.5.
创建
postgres
用户并设置密码
.............................................................6
3.6.
配置
ssh
免登陆
.................................................................................6
4.postgresql
流复制环境安装配置
..................................................................6
4.1.
修改权限
.............................................................................................6
4.2.
安装依赖包
..........................................................................................6
4.3.
解压安装
.............................................................................................7
4.4.
设置环境变量
......................................................................................7
4.5.
初始化和启动服务
(master)..................................................................7
4.6.
配置流复制用户
???.............................................................................7
4.7.postgresql
主配置文件调整
(master)..................................................8
4.8.
监控
sql
功能
???...............................................................................8
4.9.
访问控制文件
pg_hba.conf
的配置
.......................................................8
4.10.
标志文件的配置
...............................................................................9
4.11.
生成备库实例
(standby)....................................................................9
4.12.
修改备库标识文件
............................................................................9
4.13.
修改备库主配置文件
........................................................................9
4.14.
启动备库
..........................................................................................9
4.15.
检查运行情况
.................................................................................10
4.16.
测试
...............................................................................................10
5.pgpool-ii
安装配置
.......................................................................................11
5.1.
安装
pgpool(master/standby).............................................................11
5.2.
安装
pgpool
相关函数
(master)...........................................................11
5.3.
配置环境变量
(master/standby)..........................................................12
5.4.
配置
pcp.conf(master/standby).........................................................12
5.5.
配置
ifconfig, arping
执行权限
(master/standby).................................12
5.6.
配置
pgpool.conf(master)..................................................................12
5.7.
配置
pgpool.conf(standby).................................................................16
5.8.failover_stream.sh
文件内容
(master/standby)...................................19
5.9.
创建运行时目录
(master/standby)......................................................19
5.10.
配置
pool_hba(master)...................................................................19
1
文档被以下合辑收录
评论