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
Post a Comment