0
PostgreSQL高可用集群安装指南
455
15页
9次
墨值5
PostgreSQL 高可用集群
安装指南
2018.5
I
一、 主机拓扑结构信 ............................................................................................................................1
1. 版本信息 ..........................................................................................................................................1
2. 主机信息 ..........................................................................................................................................1
3. 拓扑结构 ..........................................................................................................................................1
二、 安装配置集群 .....................................................................................................................................1
1. 安装初始化 PG ...............................................................................................................................1
1) 安装步骤 ..........................................................................................................................................1
2) 建立归档目录 ................................................................................................................................2
2. 数据库配置 .....................................................................................................................................2
1) 创建复制用户 ................................................................................................................................2
2) 修改数据库配置 ............................................................................................................................3
a. postgresql.conf .........................................................................................................................3
b. pg_hba.conf ...................................................................................................................................5
3) restart database .......................................................................................................................5
3. sync slave 配置 ...........................................................................................................................5
1) 停止数据库 .....................................................................................................................................5
2) 清空 pgdata 目录 .........................................................................................................................5
3) 配置 sync standby .....................................................................................................................5
4) 配置恢复同步与切换...................................................................................................................6
5) 启动 sync slave ...........................................................................................................................6
4. async slave 配置 .......................................................................................................................7
1) 停止数据库 .....................................................................................................................................7
2) 清空 pgdata 目录 .........................................................................................................................7
3) 配置 async slave ........................................................................................................................7
4) 配置 wal 时间线切 .................................................................................................................8
5) 启动 async standby...................................................................................................................8
5. 检查 replication 状态 ..............................................................................................................8
1) primary ............................................................................................................................................8
2) sync standby ............................................................................................................................. 10
3) async standby ........................................................................................................................... 12
of 15
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文档的来源(墨天轮),文档链接,文档作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论

关注
最新上传
暂无内容,敬请期待...
下载排行榜
Top250 周榜 月榜
近期活动
全部
暂无活动,敬请期待...
相关课程
全部