| From: | SATYANARAYANA NARLAPURAM <satyanarlapuram(at)gmail(dot)com> |
|---|---|
| To: | Alexander Kukushkin <cyberdemn(at)gmail(dot)com> |
| Cc: | shveta malik <shveta(dot)malik(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
| Date: | 2026-02-26 10:38:44 |
| Message-ID: | CAHg+QDeH0_qPFoPX=ybGJxG9mGcEodz+fsWg7EnRUi=SOCGGHg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hi Alexnader,
On Thu, Feb 26, 2026 at 1:29 AM Alexander Kukushkin <cyberdemn(at)gmail(dot)com>
wrote:
> Hi,
>
> On Thu, 26 Feb 2026 at 09:45, shveta malik <shveta(dot)malik(at)gmail(dot)com> wrote:
>
>>
>> As suggested in [1], IMO, it is a reasonably good idea for
>> 'synchronized_standby_slots' to DEFAULT to the value of
>> 'synchronous_standby_names'. That way, even if the user missed to
>> configure 'synchronized_standby_slots' explicitly, we would still have
>> reasonable protection in place.
>
>
> Hmm.
> synchronous_standby_names contains application_names,
> while synchronized_standby_slots contains names of physical replication
> slots.
> These are two different things, and in fact sync replication doesn't even
> require to use replication slots.
> What is worse, even when all standbys use physical replication slots there
> is no guarantee that values in synchronous_standby_names will match
> physical slot names
>
That's right, thanks for reminding me. I am convinced that we can't use the
defaults of synchronous_standby_names for synchronized_standby_slots. What
do you think about the rest of the proposal?
Thanks,
Satya
| From | Date | Subject | |
|---|---|---|---|
| Next Message | SATYANARAYANA NARLAPURAM | 2026-02-26 10:46:08 | Re: synchronized_standby_slots behavior inconsistent with quorum-based synchronous replication |
| Previous Message | Amit Kapila | 2026-02-26 10:37:10 | Re: Skipping schema changes in publication |