Hi, On Fri, Sep 20, 2024 at 2:44 AM shveta malik <shveta.ma...@gmail.com> wrote: > > > > > > > The difference is that the purpose of 'synchronized_standby_slots' is > > to mention slot names for which the user expects logical walsenders to > > wait before sending the logical changes to subscribers. OTOH, > > 'synchronous_standby_names' has a different purpose as well. It is not > > clear to me if the users would be interested in syncing failover slots > > to all the standbys mentioned in 'synchronous_standby_names'. > > > > Okay, I see your point. But not sure what could be the solution here > except documenting. But let me think more. >
That's a great find. I didn't consider mixed physical and logical replicas in synchronous_standby_names. I wonder if there are users running synchronous_standby_names with a mix of logical and physical replicas and what the use case would be. Not sure if there's anything straight forward we could do in general for slot syncing if synchronous_standby_names refers to application_names of logical replicas, the feature can't be supported. -- John Hsu - Amazon Web Services
