Re: [PATCH] Add session_preload_libraries configuration parameter - Mailing list pgsql-hackers

From Dimitri Fontaine
Subject Re: [PATCH] Add session_preload_libraries configuration parameter
Date
Msg-id m2r4fap01d.fsf@2ndQuadrant.fr
Whole thread Raw
In response to [PATCH] Add session_preload_libraries configuration parameter  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: [PATCH] Add session_preload_libraries configuration parameter
List pgsql-hackers
Peter Eisentraut <peter_e@gmx.net> writes:
> This is like shared_preload_libraries except that it takes effect at
> backend start and can be changed without a full postmaster restart.  It
> is like local_preload_libraries except that it is still only settable by
> a superuser.  This can be a better way to load modules such as
> auto_explain.

I finally took enough time to actually understand (I think) your
proposal. The key point seems to be around ALTER ROLE SET and such like
dynamic setting of a local_preload_libraries.

Would it make sense to review the local_preload_libraries semantics
instead? It looks like session_preload_libraries only adds flexibility,
and that current usages of local_preload_libraries would be served as
well by the new setting.

Did you figure out a case where a local_preload_libraries setting would
stop working if made into a session_preload_libraries setting?

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support



pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: changeset generation v5-01 - Patches & git tree
Next
From: Markus Wanner
Date:
Subject: Re: Review: extension template