Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Can we change Sync_Priority value for a standby ? #895

Open
nijesh8 opened this issue Oct 13, 2022 · 1 comment
Open

Can we change Sync_Priority value for a standby ? #895

nijesh8 opened this issue Oct 13, 2022 · 1 comment

Comments

@nijesh8
Copy link

nijesh8 commented Oct 13, 2022

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.

  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.19 | | streaming | sync | 2
stolon_b7c46a93 | 10.xx.xx.8 | | streaming | sync | 1
stolon_14cf1afd | 10.xx.xx.39 | | streaming | async | 0
(3 rows)

@viggy28
Copy link

viggy28 commented Nov 18, 2022

Though we don't have a priority value, stolon-keeper command has a flag --can-be-synchronous-replica to convey whether a replica will be considered as synchronous replica or not (and there is also --can-be-master flag)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants