Postgresql 异步流复制-蒲公英云

Postgresql 异步流复制

压力测试环境

version：Postgresql 9.5.2

OS: CentOS 6.5

Source Code： Postgresql9.5.2

172.31.107.30 primary

172.31.107.32 slave

172.31.107.31 slave

开启防火墙端口

iptables -I INPUT -p tcp —dport 5432 -j ACCEPT

Primary

添加环境变量

echo ‘PATH=$PATH:/usr/local/postgresql/bin’ >> /etc/profile

echo ‘PGDATA=/usr/local/postgresql/data’ >> /etc/profile

source /etc/profile#使其生效

编辑 pg_hba.conf

![Image 1][]

![Image 1][] Center

host all all 172.31.107.31/24 trust

host all all 172.31.107.32/24 trust

host all all 172.29.10.250/16 trust

host all all 172.28.10.250/16 trust

host replication postgres 172.31.107.31/24 trust

host replication replUser 172.31.107.31/24 trust

host replication postgres 172.31.107.32/24 trust

host replication replUser 172.31.107.32/24 trust

编辑 postgresql.conf 添加下列项

listen_addresses = ‘*‘

port = 5432

max_connections = 900

![Image 1][] Center 1

![Image 1][]

wal_level = hot_standby

fsync = on

synchronous_commit = on

wal_sync_method = fsync

![Image 1][] Center 2

![Image 1][]

checkpoint_segments = 3

checkpoint_timeout = 5min

![Image 1][] Center 3

![Image 1][]

max_wal_senders = 2

wal_keep_segments = 3

wal_sender_timeout = 60s

max_replication_slots =2

![Image 1][] Center 4

![Image 1][]

启动Postgresql 数据库服务

shell>su - postgres

pg_ctl -D $PGDATA start

![Image 1][] Center 5

![Image 1][]

修改postgres账号密码

![Image 1][]

增加一个同步复制数据专用账号（本案例使用的是postgres账号）

create user replUser REPLICATION LOGIN CONNECTION LIMIT 3 ENCRYPTED PASSWORD ‘replUserfxiaoke2016’;

![Image 1][] Center 6

Slave

添加环境变量

  echo 'PATH=$PATH:/usr/local/postgresql/bin' >> /etc/profile  
 echo 'PGDATA=/usr/local/postgresql/data' >> /etc/profile  
 source /etc/profile\#使其生效