报错截图:
pg_basebackup: could not get write-ahead log end position from server: ERROR: could not open file "./.postgresql.conf.swn": Permission denied
一、环境准备:【生产环境】
1、
Master PG host IP :172.17.16.16 host name:hkzbxdb1
Standby PG host IP:172.17.16.18 host name:hkzbxdb2
2、PG Cluster 理想环境是版本一致,所以主备库版本如下:
3、停止Firewalls防火墙【主备机】、初始化PG数据库【主备机】、iptables规则配置【假如你用到/主备】;
4、Master host 配置:pg_hba.conf 和postgresql.conf;创建replication role账户repl;