Re: alter user set local_preload_libraries.

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...

regards,

--
Kyotaro Horiguchi
NTT Open Source Software Center