PostgreSQL高可用集群安装指南

ken

2779

15页

17次

2019-08-26

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 
 

一、主机拓扑结构信息

1. 版本信息

OS：CentOS Linux release 7.4.1708 X64

PostgreSQL: postgresql10-server-10.3-1PGDG.rhel7.x86_64

2. 主机信息

cluster01_node01 192.168.0.108

cluster01_node02 192.168.0.109

cluster02_node03 192.168.0.110

3. 拓扑结构

初始状态：

sync async

primary(cls01_node01)--->standby01(cls01_node02) --->standby02(cls01_node03)

二、安装配置集群

1. 安装初始化 PG

三个节点 cls01_node01，cls01_node02，cls01_node03。

1) 安装步骤

--- install pg packages

yum install https://download.postgresql.org/pub/repos/yum/10/redhat/rhel-7-

x86_64/pgdg-centos10-10-2.noarch.rpm

yum install postgresql10-server

yum install -y postgresql10-contrib

--- init and auto boot

primary

async standby

sync standby

async

sync

of 15

5墨值下载

文档被以下合辑收录

墨天轮最受欢迎的技术文档-高可用架构篇（共121篇）

数据库高可用如何实现？这份合辑你或许可以用到！本文为大家整理了墨天轮社区上一些受欢迎的数据库高可用架构实践主题相关文档，包含Oracle、PostgreSQL、MySQL三类数据库，欢迎大家下载查看🌹

文档被以下合辑收录

相关文档

评论