...
代码块 |
---|
CREATE ROLE dwfbak REPLICATION LOGIN ENCRYPTED PASSWORD 'Dwf2018!'; |
2.创建归档文件夹
代码块 |
---|
mkdir /data/master-data/pg_wal_bak |
3.修改配置文件postgresql.conf
,添加以下行:
...
代码块 |
---|
wal_level = replica max_wal_senders = 5 wal_keep_segments = 32 archive_mode = on archive_command = 'cp %p /var/lib/postgresql/data/pg_wal_bak/%f' |
mkdir /data/master-data/pg_wal_bak
34.修改pg_hba.conf,允许备份服务器连接
vim /data/masret/pg_hba.conf
代码块 |
---|
host replication dwfdwfbak 0.0.0.0/0 md5 |
45.重启pg-master
代码块 |
---|
docker restart pg-master |
...