Coordinator host setting

[wenq1]

Coordinator host can be set using SELECT citus_set_coordinator_host ('192.168.5.1', 5434)

Two questions:

• Can this setting be found out later on via e.g. SELECT citus_get_coordinator_host ()?
• If for example 192.168.5.1 failed and a hot standby at 192.168.5.2 kicks in, now will all the workers (for example a worker can live on 192.168.5.100) continue to function now that the coordinator host has changed?

[archongum]

+1 https://stackoverflow.com/q/73315208/9756912

[onderkalaci]

You can use SELECT citus_is_coordinator()

Or, more generically get the host that you are connected to: https://github.com/citusdata/citus/pull/5888#discussion_r853132226

https://stackoverflow.com/q/73315208/9756912

We'll look into that soon