Re: Possible to exclude a database from loading a shared_preload_libraries module? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Possible to exclude a database from loading a shared_preload_libraries module?
Date
Msg-id 2136292.1713535821@sss.pgh.pa.us
Whole thread Raw
In response to Possible to exclude a database from loading a shared_preload_libraries module?  (Rajan Pandey <rajanpandey2508@gmail.com>)
List pgsql-hackers
Rajan Pandey <rajanpandey2508@gmail.com> writes:
> Hi, I have a use case where I want a particular database to not load a few
> modules in shared_preload_libraries.
> I was wondering if there's any way to tweak the codebase to achieve this.

No.  It's not even theoretically possible, because the whole point of
shared_preload_libraries is that the module gets loaded at postmaster
start.

Depending on what the module does, it might work to load it
per-session with session_preload_libraries, which you could attach
to the specific database(s) where you want it to be effective.

> Otherwise, can I block the modules' hooks/bgw from performing actions on my
> particular database?

That would be a feature for the individual module to implement.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: Direct SSL connection with ALPN and HBA rules
Next
From: "Euler Taveira"
Date:
Subject: Re: Idea Feedback: psql \h misses -> Offers Links?