| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com> |
| Cc: | Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, Fabrice Chapuis <fabrice636861(at)gmail(dot)com>, Ashutosh Sharma <ashu(dot)coek88(at)gmail(dot)com>, Rahila Syed <rahilasyed90(at)gmail(dot)com>, Alexander Kukushkin <cyberdemn(at)gmail(dot)com>, "Zhijie Hou (Fujitsu)" <houzj(dot)fnst(at)fujitsu(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: issue with synchronized_standby_slots |
| Date: | 2025-10-24 09:38:19 |
| Message-ID: | CAA4eK1J7f+gidApbOXzwVpibudp=9xiJoxmypA58-bKg=8Lxbg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Oct 24, 2025 at 1:24 PM Hayato Kuroda (Fujitsu)
<kuroda(dot)hayato(at)fujitsu(dot)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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2025-10-24 09:39:15 | Re: Question for coverage report |
| Previous Message | shveta malik | 2025-10-24 09:29:37 | Re: Improve pg_sync_replication_slots() to wait for primary to advance |