Can we change the SYNC_PRIORITY value for a particular Synchronous standby in Stolon Keeper nodes ? This is to choose 1 or 2 specific standbys as Failover targets, and keeping the remaining as less priority standbys.
“show synchronous_Standby_names”
" select application_name, client_addr, client_hostname, state, sync_state, sync_priority from
pg_stat_replication"
synchronous_standby_names
2 (stolon_b7c46a93,stolon_ff7d06b7)
(1 row)
application_name | client_addr | client_hostname | state | sync_state | sync_priority
------------------±--------------±----------------±----------±-----------±--------------
stolon_ff7d06b7 | 10.xx.xx.1 | | streaming | sync | 2
stolon_b7c46a93 | 10.xxx.x.2 | | streaming | sync | 1
stolon_14cf1afd | 10.xxx.x.3 | | streaming | async | 0
(3 rows)