Setting log_connection in connection string doesn't work

From: Kyotaro Horiguchi <horikyota(dot)ntt(at)gmail(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Setting log_connection in connection string doesn't work
Date: 2021-10-26 08:33:50
Message-ID: 20211026.173350.2163793213857103911.horikyota.ntt@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello.

I noticed that the following command doesn't leave connection log in
log file.

> psql "host=localhost options=-c\ log_connections=on"

The reason is we log connections before the options is processed. We
need to move the code from BackendInitialize to InitPostgres where
that options are processed if we want that option to work. However,
I'm not sure we can delay connection-log until that point, since that
movement changes the meaning of the log message.

Another option is to log connections in InitPostgres if not yet and
log_connections is turned on by connection options.

Futher another option is we don't make it work and write in the
document that it doesn't work. (I didn't find that, but...)

Opinions and suggestions are welcome.

regards.

--
Kyotaro Horiguchi
NTT Open Source Software Center

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Daniel Gustafsson 2021-10-26 08:49:49 Re: [PATCH] Fix memory corruption in pg_shdepend.c
Previous Message Bharath Rupireddy 2021-10-26 08:19:00 Re: when the startup process doesn't (logging startup delays)