[bitnami/postgresql-ha] How to perform manual switchover for postgresql-ha running in openshift
Name and Version
bitnami/postgresql-ha
What architecture are you using?
None
What steps will reproduce the bug?
when i run this command to perform manual switchover, below error prompts out, how can i fix this issue ? 'repmgr standby switchover'
1001090000@pgsql-dev-16-postgresql-ha-postgresql-1:/opt/bitnami/repmgr/conf$ repmgr standby switchover
NOTICE: executing switchover on node "pgsql-dev-16-postgresql-ha-postgresql-1" (ID: 1001)
WARNING: unable to connect to remote host "pgsql-dev-16-postgresql-ha-postgresql-0.pgsql-dev-16-postgresql-ha-postgresql-headless.postgres-dev.svc.cluster.local" via SSH
ERROR: unable to connect via SSH to host "pgsql-dev-16-postgresql-ha-postgresql-0.pgsql-dev-16-postgresql-ha-postgresql-headless.postgres-dev.svc.cluster.local", user "
Are you using any custom parameters or values?
No response
What is the expected behavior?
No response
What do you see instead?
nodes should be switchover successfully
Additional information
No response
Hi @jhsee11,
Thanks for using Bitnami. According to the official docs, passwordless SSH connectivity is required between nodes, and our images do not provide that configuration at this moment. I will open a question with the engineering team for them to further evaluate this.
repmgr standby switchover differs from other repmgr actions in that it also performs actions on another server (the demotion candidate), which means passwordless SSH access is required to that server from the one where repmgr standby switchover is executed.
I'm adding the on-hold tag to avoid the stale bot to close this ticket.