Hello Team,
We are facing issue with Postgresql HA 3 node cluster in Debian12 - 1. Primary, 2. Standby,3. Witness Node.
Issue is with failover_validation_command execution inside repmgr on standby node. Eventhough we have passed argument in /etc/repmgr.conf for this command , it is statically executed as per below log from repmgr binary/code - "repmgr node check --role=primary".
[2025-07-14 08:00:24] [NOTICE] promotion candidate is "pgsql02" (ID: 2)
[2025-07-14 08:00:24] [NOTICE] executing "failover_validation_command"
[2025-07-14 08:00:24] [DETAIL] repmgr node check --role=primary
[2025-07-14 08:00:24] [INFO] output returned by failover validation command:
Try "repmgr --help" or "repmgr node --help" for more information.
/usr/lib/postgresql/15/bin/repmgr: option '--role' doesn't allow an argument
[2025-07-14 08:00:24] [NOTICE] failover validation command returned a non-zero value: 1
As this command is deprecated, it is failed in this version.
To troubleshoot more - I tried with strace command as below which indicates issue with binary it self.
postgres@pgsql02:~$ strace -f -e execve -p $(pgrep repmgrd)
strace: Process 2093 attached
strace: Process 15077 attached
[pid 15077] execve("/bin/sh", ["sh", "-c", "repmgr node check --role=primary"...], 0x7ffc201379f8 /* 11 vars /) = 0
strace: Process 15078 attached
[pid 15078] execve("/usr/bin/repmgr", ["repmgr", "node", "check", "--role=primary"], 0x55d69128d608 / 11 vars /) = 0
[pid 15078] execve("/usr/lib/postgresql/15/bin/repmgr", ["/usr/lib/postgresql/15/bin/repmg"..., "node", "check", "--role=primary"], 0x55b1691efc30 / 11 vars /) = 0
[pid 15078] +++ exited with 1 +++
[pid 15077] --- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=15078, si_uid=104, si_status=1, si_utime=3 / 0.03 s */, si_stime=0} ---
[pid 15077] +++ exited with 1 +++
--- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=15077, si_uid=104, si_status=1, si_utime=0, si_stime=0} ---
Can you please help to resolve this issue?
Hello Team,
We are facing issue with Postgresql HA 3 node cluster in Debian12 - 1. Primary, 2. Standby,3. Witness Node.
Issue is with failover_validation_command execution inside repmgr on standby node. Eventhough we have passed argument in /etc/repmgr.conf for this command , it is statically executed as per below log from repmgr binary/code - "repmgr node check --role=primary".
[2025-07-14 08:00:24] [NOTICE] promotion candidate is "pgsql02" (ID: 2)
[2025-07-14 08:00:24] [NOTICE] executing "failover_validation_command"
[2025-07-14 08:00:24] [DETAIL] repmgr node check --role=primary
[2025-07-14 08:00:24] [INFO] output returned by failover validation command:
Try "repmgr --help" or "repmgr node --help" for more information.
/usr/lib/postgresql/15/bin/repmgr: option '--role' doesn't allow an argument
[2025-07-14 08:00:24] [NOTICE] failover validation command returned a non-zero value: 1
As this command is deprecated, it is failed in this version.
To troubleshoot more - I tried with strace command as below which indicates issue with binary it self.
postgres@pgsql02:~$ strace -f -e execve -p $(pgrep repmgrd)
strace: Process 2093 attached
strace: Process 15077 attached
[pid 15077] execve("/bin/sh", ["sh", "-c", "repmgr node check --role=primary"...], 0x7ffc201379f8 /* 11 vars /) = 0
strace: Process 15078 attached
[pid 15078] execve("/usr/bin/repmgr", ["repmgr", "node", "check", "--role=primary"], 0x55d69128d608 / 11 vars /) = 0
[pid 15078] execve("/usr/lib/postgresql/15/bin/repmgr", ["/usr/lib/postgresql/15/bin/repmg"..., "node", "check", "--role=primary"], 0x55b1691efc30 / 11 vars /) = 0
[pid 15078] +++ exited with 1 +++
[pid 15077] --- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=15078, si_uid=104, si_status=1, si_utime=3 / 0.03 s */, si_stime=0} ---
[pid 15077] +++ exited with 1 +++
--- SIGCHLD {si_signo=SIGCHLD, si_code=CLD_EXITED, si_pid=15077, si_uid=104, si_status=1, si_utime=0, si_stime=0} ---
Can you please help to resolve this issue?