PostgreSQL高可用集群安装指南
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
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论