From: | jacob ndinkwa <jndinkwa(at)gmail(dot)com> |
---|---|
To: | pgsql-admin(at)lists(dot)postgresql(dot)org, pgsql-generallists(at)postgresql(dot)org |
Subject: | repmgr auto-failover not happening. |
Date: | 2024-02-04 11:41:55 |
Message-ID: | CAKFm-3BmtDikdsyN0Zt+pw22eGZJVvuF7QbVuPHUj8kY51pe-w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Nikhil Shetty | 2024-02-04 13:11:28 | Re: repmgr auto-failover not happening. |
Previous Message | Samed YILDIRIM | 2024-02-03 20:38:11 | Re: Pam NIS authentication |