Ian Barwick

We've looked into this and determined that `repmgr standby promote` by itself can't be sure which primary it's replacing. What's the precise context where you need this? If it's when...

Hi, If `connection_check_type` is set to `query`, repmgr uses `SELECT 1` as a simple throw-away query to elicit a response from the server. I see that's not really clear from...

> @ibarwick Can you please help us with below questions? (Consolidating all the previous questions too) > > 1. From which version of repmgr, this new parameter `connection_check_query` is available?...

> Thanks @ibarwick for all the answers. Few follow up questions: > > > If it uses existing connection, is there a way to force a new connection for every...

> Am I asking for the wrong thing, and is there a better way to do this other than with RepMgr? AFAICS the closest PostgreSQL itself has to any of...

Can you provide the `repmgr.conf` and `repmgrd` log files from the standby?

> Worked the first time, so I tried it a second and it failed the test procedure was, > node001 standby > node006 master > node003 witnsss > > 1....

This is correct behaviour -`sslmode` is a [libpq connection parameter](https://www.postgresql.org/docs/current/libpq-connect.html#LIBPQ-PARAMKEYWORDS), not a repmgr configuration item, so you should put it in the `conninfo` string, e.g: ``` conninfo = 'host=node01 user=repmgr...

> Further observations: > > 1. stopped all the repmgrd daemons on the witness server and started only one repmgrd. > Then for all the databases in witness, get_upstream_node_id() returns...

Can you provide a) `repmgr.conf` and b) the repmgrd log file (or relevant-looking excerpts from it)?