PostgreSQl 12主从流复制及归档配置

复制# 用postgres用户登录到主pgsql服务器  ssh-keygen -t rsa  # 一路回车  scp /home/postgres/.ssh/id_rsa.pub postgres@10.10.22.152:/home/postgres/.ssh/authorized_keys  或者拷贝id_rsa.pub文件到从pgsql上，然后到从上执行以下命令  cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys   # 登录从pgsql服务器查看权限  chmod 700 /home/postgres/.ssh  chmod 600 /home/postgres/.ssh/authorized_keys  # 测试登录  ssh postgres@10.10.22.152  # 从pgsql库  ssh-keygen -t rsa  # 一路回车  scp /home/postgres/.ssh/id_rsa.pub postgres@10.10.22.151:/home/postgres/.ssh/authorized_keys  # 登录从pgsql服务器查看权限  chmod 700 /home/postgres/.ssh  chmod 600 /home/postgres/.ssh/authorized_keys  # 测试登录  ssh postgres@10.10.22.152  1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.