Answer the question
In order to leave comments, you need to log in
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
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
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question