On Tue, Oct 21, 2014 at 3:16 PM, Kyotaro HORIGUCHI <horiguchi.kyot...@lab.ntt.co.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
