Re: alter user set local_preload_libraries.

On Tue, Oct 21, 2014 at 3:16 PM, Kyotaro HORIGUCHI
<horiguchi(dot)kyotaro(at)lab(dot)ntt(dot)co(dot)jp> wrote:
> Wow.
>
>> > By the way, I became unable to login at all after wrongly setting
>> > *_preload_libraries for all available users. Is there any releaf
>> > measures for the situation? I think it's okay even if there's no
>> > way to login again but want to know if any.
>>
>> Yep, that's a problem. You can login to the server even in that case
>> by, for example, executing the following commands, though.
>>
>> $ export PGOPTIONS="-c *_preload_libraries="
>> $ psql
>
> Thank you. I see. It seems enough for me. The section 18.1.3 of
> 9.4 document describes about it,
>
> http://www.postgresql.org/docs/9.4/static/config-setting.html
>
>> 18.1.4. Parameter Interaction via Shell
> ..
>> On the libpq-client, command-line options can be specified
>> using the PGOPTIONS environment variable. When connecting to
>> the server, the contents of this variable are sent to the
>> server as if they were being executed via SQL SET at the
>> beginning of the session.
>
> This implicitly denies PGC_BACKEND variables to be set by this
> method but it also seems not proper to describe precisely...

Sorry, probably I failed to understand your point. Could you tell me
what you're suggesting? You're thinking that the description needs to
be updated? How?

Regards,

--
Fujii Masao