G
G
gremlintv22017-08-08 16:29:28
PostgreSQL
gremlintv2, 2017-08-08 16:29:28

Maybe someone will tell you how to specify the parameters in repmgr.conf?

Initial data: there is a physical server1 with vps vps1 on it, on vps1 there is a postgres1 base, to which port 55432-> 5432 is forwarded, external ip server1 is 123.123.123.123, vps1 - 192.168.1.100
there is a physical server2 with vps vps2 on it , on vps2 there is a postgres2 base, to which port 55432-> 5432 is forwarded, the external ip server1 is 124.124.124.124, vps1 is
192.168.2.100
On vps1 repmgr.conf:

failover=automatic
#promote_command=/var/lib/pgsql/repmgr/promote.sh
follow_command='repmgr standby follow -f /etc/repmgr.conf --log-to-file'
cluster=cluster1
node=1
node_name=node100
conninfo='host=192.168.1.100 port=5432 user=repmgr dbname=repmgr'
master_response_timeout=30
pg_bindir=/usr/local/bin/
service_start_command = systemctl start postgresql-9.6
service_stop_command = systemctl stop postgresql-9.6
service_restart_command = systemctl restart postgresql-9.6

On vps2 repmgr.conf:
failover=automatic
#promote_command=/var/lib/pgsql/repmgr/promote.sh
follow_command='repmgr standby follow -f /etc/repmgr.conf --log-to-file'
cluster=cluster1
node=1
node_name=node200
conninfo='host=192.168.2.100 port=5432 user=repmgr dbname=repmgr'
master_response_timeout=30
pg_bindir=/usr/local/bin/
service_start_command = systemctl start postgresql-9.6
service_stop_command = systemctl stop postgresql-9.6
service_restart_command = systemctl restart postgresql-9.6

If I try to register an external ip 123.123.123.123 in repmgr.conf and register the master, then vps1 swears: could not connect to
server
123.123.123.123 can find a host with ip 192.168.1.100
How to be?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question