repmgr auto-failover not happening.

Поиск
Список
Период
Сортировка
От jacob ndinkwa
Тема repmgr auto-failover not happening.
Дата
Msg-id CAKFm-3BmtDikdsyN0Zt+pw22eGZJVvuF7QbVuPHUj8kY51pe-w@mail.gmail.com
обсуждение исходный текст
Ответы Re: repmgr auto-failover not happening.
Список pgsql-admin
Hello gurus,

I'm running Postgres 15 with repmgr 5. 
I set up repmgr, tested switchover and manual failover successfully but automatic failover is not working. I wish to know if I'm missing out something. See the repmgr.conf file below and advise please.

priority=100
node_name=LP1

conninfo='host=group.com user=repmgr dbname=repmgr connect_timeout=10'

data_directory='/pgdata/'

pg_bindir='/usr/pgsql-15/bin/'

repmgr_bindir='/usr/pgsql-15/bin/'

repmgrd_pid_file='/run/repmgr/repmgrd-15.pid'

monitor_interval_secs=2
reconnect_attempts=6
reconnect_interval=10
connection_check_type=connection

failover=automatic

promote_command='/usr/pgsql-15/bin/repmgr standby promote -f /etc/repmgr/15/repmgr.conf --siblings-follow --log-to-file'

follow_command='/usr/pgsql-15/bin/repmgr standby follow -f /etc/repmgr/15/repmgr.conf --log-to-file --upstream-node-id=%n'


primary_visibility_consensus=true
standby_disconnect_on_failover=true
repmgrd_service_start_command='sudo /usr/bin/systemctl start repmgr-15.service'
repmgrd_service_stop_command='sudo /usr/bin/systemctl stop repmgr-15.service'
service_start_command='sudo /usr/bin/systemctl start postgresql-15.service'
service_stop_command='sudo /usr/bin/systemctl stop postgresql-15.service'
service_restart_command='sudo /usr/bin/systemctl restart postgresql-15.service'
service_reload_command='sudo /usr/bin/systemctl reload postgresql-15.service'
monitoring_history=yes
log_level='INFO'
log_facility='STDERR'
log_file='/var/log/repmgr/repmgr.log'
log_status_interval=60

Thank you,
Jake

В списке pgsql-admin по дате отправления:

Предыдущее
От: Samed YILDIRIM
Дата:
Сообщение: Re: Pam NIS authentication
Следующее
От: Nikhil Shetty
Дата:
Сообщение: Re: repmgr auto-failover not happening.