主库下:
创建流复制用户
create user repl superuser password '12345678';
cd /etc/postgresql/9.5/main/ vi postgresql.conf |
listen_address = ‘*’(默认localhost)
wal_level = hot_standby(默认是minimal)
max_wal_senders=2(默认是0)
wal_keep_segments=64(默认是0)
vi pg_hba.conf |
增加
host replication repl 192.168.239.181/32 md5
从库下:
rm -rf /var/lib/postgresql/9.5/main/* cd /usr/lib/postgresql/9.5/bin ./pg_basebackup -h 192.168.239.180 -U repl -F p -x -P -R -D /var/lib/postgresql/9.5/main/ -l replbackup20180107 |
vi postgresql.conf |
将hot_standby改为启用状态,即hot_standby=on
切换到root用户重启数据库,
systemctl restart postgresql
(或者使用命令目录/app/bin/pg_ctl start -D /app/pgsql/data)
主库中查看
ps -ef|grep postgres |
从库中查看
ps -ef|grep postgres |
在主库上创建表
create table t_user(id int primary key,name varchar(30)); insert into t_user values(1,'xxx'); |