postgresql - [Postgres Replication]Remote host is not reachable repmgr salve -


i trying create postgres replication configuration using 2 servers. steps similar postgresql 9.4 replication repmgr , pgbouncer on ubuntu 14.04 . using repmgr + pgbouncer replication configuration. have 2 host dhost1 , dhost2. repmgr meta data db repmgrdb , user repmgr_user.
dhost1 has pgbouncer , repmgr's configuration , master. repmgr's configuration in dbhost1 mentioned below:

>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 @ master ## 

dhost2 has repmgr's config , in slave mode. it's config mentioned below

>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 @ slave ## 

i able register master , can seen master in cluster show command.
on slave side using pg_basebackup method clone master command

repmgr -f /etc/repmgr/repmgr.conf --force -h -u repmgr_user -d repmgrdb -v standby clone

for above command below error:

>[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 explicitly specify data directory  >[2016-08-08 10:05:26] [notice] starting backup (using pg_basebackup)...  >[2016-08-08 10:05:26] [hint] may take time; consider using -c/--fast-checkpoint option  >[2016-08-08 10:05:31] [notice] copying configuration files master  >[2016-08-08 10:05:31] [error] aborting, remote host <dhost1_ip_address_goes_here> not reachable.  >[2016-08-08 10:05:31] [error] unable take base backup of master server>  >[2016-08-08 10:05:31] [warning] destination directory (/var/lib/postgresql/9.5/main) may need cleaned manually 

i have set password-less ssh postgres user between dhost1 , dhost2.

also have been able take pg_basebackup command

pg_basebackup -h -p -v -u repmgr_user -x stream -d 9.5/main -r

i beginner postgresql replication please suggest me answers.

i'm looking right now. might wanna run command again with
--log-level debug --verbose should give more info on going on there...


Comments