我正在尝试使用两台服务器创建postgres复制配置。步骤类似于PostgreSQL 9.4 Replication with RepMgr and PgBouncer on Ubuntu 14.04
. 我正在使用repmgr+pgbouncer作为复制配置。假设我有两个主机dhost1和dhost2。Repmgr元数据数据库是Repmgr db，用户是Repmgr_用户。
dhost1具有pgbouncer和Repmgr的配置，它是主控。dbhost1中的Repmgr配置如下所示：
cluster = test
node = 1
node_name = dhost1
use_replication_slots = 1
conninfo='host=dhost1 user=repmgr_user dbname=repmgrdb'
pg_bindir=/usr/lib/postgresql/9.5/bin
## repmgr.conf at master ##
dhost2也有Repmgr的配置，它处于从属模式。配置如下
cluster = test
node = 2
node_name = dhost2
use_replication_slots = 1
conninfo='host=dhost2 user=repmgr_user dbname=repmgrdb'
pg_bindir=/usr/lib/postgresql/9.5/bin
## repmgr.conf at slave ##
我能成功注册到主机，并能在集群显示命令中看到主机。
在从机端，我使用
pg_basebackup方法用命令克隆主机repmgr -f /etc/repmgr/repmgr.conf --force -h dhost1_ip_address_goes_here> -U repmgr_user -d repmgrdb -v standby clone
对于上面的命令，我得到以下错误：
[2016-08-08 10:05:26] [NOTICE] using configuration file "/etc/repmgr/repmgr.conf"
[2016-08-08 10:05:26] [NOTICE] setting data directory to: /var/lib/postgresql/9.5/main
[2016-08-08 10:05:26] [HINT] use -D/--data-dir to explicitly specify a data directory
[2016-08-08 10:05:26] [NOTICE] starting backup (using pg_basebackup)...
[2016-08-08 10:05:26] [HINT] this may take some time; consider using the -c/--fast-checkpoint option
[2016-08-08 10:05:31] [NOTICE] copying configuration files from master
[2016-08-08 10:05:31] [ERROR] aborting, remote host <dhost1_ip_address_goes_here> is not reachable.
[2016-08-08 10:05:31] [ERROR] unable to take a base backup of the master server>
[2016-08-08 10:05:31] [WARNING] destination directory (/var/lib/postgresql/9.5/main) may need to be cleaned up manually
我还为
postgres和dhost1之间的dhost2用户设置了无密码ssh。我还可以从命令中获取
pg_basebackuppg_basebackup -h <dhost1_ip_address_goes_here> -P -v -U repmgr_user -X stream -D 9.5/main -R
我是postgresql复制的初学者，请给我建议答案。
最佳答案
我正在调查。你可能想用
--日志级调试--详细
这应该能提供更多关于那里发生了什么的信息。。。