Re: issue with synchronized_standby_slots - Mailing list pgsql-hackers

From Amit Kapila
Subject Re: issue with synchronized_standby_slots
Date
Msg-id CAA4eK1J7f+gidApbOXzwVpibudp=9xiJoxmypA58-bKg=8Lxbg@mail.gmail.com
Whole thread Raw
In response to RE: issue with synchronized_standby_slots  ("Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>)
Responses Re: issue with synchronized_standby_slots
List pgsql-hackers
On Fri, Oct 24, 2025 at 1:24 PM Hayato Kuroda (Fujitsu)
<kuroda.hayato@fujitsu.com> wrote:
>
> Dear Shlok,
>
> ```
> -- Can set synchronized_standby_slots to a non-existent slot name.
> ALTER SYSTEM SET synchronized_standby_slots='missing';
> SELECT pg_reload_conf();
>
> -- Reset the GUC.
> ALTER SYSTEM RESET synchronized_standby_slots;
> SELECT pg_reload_conf();
> ```
>
> pg_reload_conf() is called twice here but I'm not sure it is really needed.
> ALTER SYSTEM itself can validate parameters via parse_and_validate_value(elevel=ERROR),
> and pg_reload_conf() won't affect synchronously.

I also think pg_reload_conf() won't be required here.

--
With Regards,
Amit Kapila.



pgsql-hackers by date:

Previous
From: shveta malik
Date:
Subject: Re: Improve pg_sync_replication_slots() to wait for primary to advance
Next
From: Álvaro Herrera
Date:
Subject: Re: Question for coverage report