On Mon, May 09, 2022 at 09:29:32PM -0400, Tom Lane wrote: > Brute force way: s/reload/restart/
That was my first thought, as it can be tricky to make sure that all the processes got the update because we don't publish such a state. One thing I was also thinking about would be to update pg_stat_activity.state_change when a reload is processed on top of its current updates, then wait for it to be effective in all the processes reported. The field remains NULL for most non-backend processes, which would be a compatibility change. > Less brute force: wait for "SHOW variable-you-changed" to report the > value you expect. This method may still be unreliable in some processes like a logirep launcher/receiver or just autovacuum, no? -- Michael
signature.asc
Description: PGP signature