Re: repmgr auto-failover not happening.

What is the error in log file of repmgrd?

On Mon, 5 Feb 2024 at 03:36, jacob ndinkwa <jndinkwa(at)gmail(dot)com> wrote:

> Yes, repmgrd daemon is running on both nodes but still auto-failover is
> not happening.
>
> On Sun, Feb 4, 2024, 8:11 AM Nikhil Shetty <nikhil(dot)dba04(at)gmail(dot)com> wrote:
>
>> Hi,
>>
>> Check if repmgrd process is running on both primary and secondary
>>
>> You can set the log file parameter for repmgrd in repmgr.conf on both
>> primary and secondary
>> to check if it is running fine
>>
>> Thanks,
>> Nikhil
>>
>> On Sun, 4 Feb 2024 at 17:12, jacob ndinkwa <jndinkwa(at)gmail(dot)com> wrote:
>>
>>> 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
>>>
>>