...
| 代码块 |
|---|
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 dwf 0.0.0.0/0 md5 |
45.重启pg-master
| 代码块 |
|---|
docker restart pg-master |
...