On 11/2/21, 8:57 AM, "Robert Haas" <robertmh...@gmail.com> wrote: > On Tue, Nov 2, 2021 at 11:26 AM Bossart, Nathan <bossa...@amazon.com> wrote: >> Well, the current patch does require a reload since the modules are >> preloaded, but maybe there is some way to avoid that. > > I think we could set things up so that if the value changes, you call > a shutdown hook for the old library, load the new one, and call any > startup hook for that one.
Yes, that seems doable. My point is that I've intentionally chosen to preload the libraries at the moment so that it's possible to define PGC_POSTMASTER GUCs and to use RegisterBackgroundWorker(). If we think that switching archive modules without restarting is more important, I believe we will need to take on a few restrictions. Nathan