Re: [PATCH] Add session_preload_libraries configuration parameter

On 7/8/13 4:37 AM, Dimitri Fontaine wrote:
>> I don't know of any actual legitimate uses of local_preload_libraries.
>> I recall that the plpgsql debugger was meant to use it, but doesn't
>> anymore.  So it's hard to judge what to do about this, without any
>> actual use cases.
> 
> Well there's my preprepare thing at 
> 
>   https://github.com/dimitri/preprepare

preprepare has an SQL function as entry point, so you don't need to
preload it.

> I don't think that the whitelisting is actually used in a way to allow
> for non superusers to load modules in the field, because the only way to
> do that with local_preload_libraries that I know of is to edit the
> postgresql.conf file and reload.
> 
>   alter role dim set local_preload_libraries = 'auto_explain';
>   ERROR:  55P02: parameter "local_preload_libraries" cannot be set after connection start

I think the idea was to use PGOPTIONS to load it, controlled by the
client side.