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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
