Re: [PATCH] Add session_preload_libraries configuration parameter

Peter Eisentraut <peter_e(at)gmx(dot)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