| From: | Andrey Borodin <x4mmm(at)yandex-team(dot)ru> |
|---|---|
| To: | Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Alexander Lakhin <exclusion(at)gmail(dot)com>, Daniel Gustafsson <daniel(at)yesql(dot)se> |
| Subject: | Re: Do we want to solve reload/config races more generally? (was: Postmaster crashes on SIGHUP when oauth_validator_libraries holds only whitespace) |
| Date: | 2026-10-08 18:53:17 |
| Message-ID: | 31E8FD07-F7EF-414D-8C40-A3203BFF0777@yandex-team.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs pgsql-hackers |
> On 8 Oct 2026, at 23:28, Jacob Champion <jacob(dot)champion(at)enterprisedb(dot)com> wrote:
>
> The general issue, for anyone new to the problem, is that reloading
> doesn't wait for the effects of the SIGHUP to complete. (And the
> meaning of "complete" depends on the test case.) It feels like this
> would pop up in more situations, but the buildfarm doesn't always show
> it and it's an easy trap to fall into.
Few days ago maintainers of pgconsul (HA tool) asked me: how to wait until
synchronous_stanby_names takes effect? For some reason they need to commit one
transaction with full quorum. The best solution we found was to restart the node
and insert\commit afterwards.
So yeah, +1 for having synchronous reload.
Best regards, Andrey Borodin.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2026-10-08 19:31:48 | Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning |
| Previous Message | Jacob Champion | 2026-10-08 18:28:41 | Do we want to solve reload/config races more generally? (was: Postmaster crashes on SIGHUP when oauth_validator_libraries holds only whitespace) |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Lakhin | 2026-10-08 19:00:00 | Re: 041_checkpoint_at_promote.pl might fail due to race condition on child kill |
| Previous Message | Bharath Rupireddy | 2026-10-08 18:53:03 | Re: Fix a wal_debug crash with the new shmem allocation API |