Re: repmgr auto-failover not happening.

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
>