[pgpool-hackers: 4610] Re: life check log is not nice
Tatsuo Ishii
ishii at postgresql.org
Sat Jun 14 20:59:15 JST 2025
> When wd_lifecheck_method = 'query', life checking prints SQL log
> something like this if log_line_prefix uses "%a" (application name):
> 2025-06-02 15:28:28.501: [unknown] pid 2436126: LOG: DB node id: 1 backend pid: 2436264 statement: SELECT 1
>
> This is not nice. Attached is a patch to teach application name (in
> the patch fixed "lifecheck_ping"). After the patch, pgpool log will
> look like this:
>
> 2025-06-02 15:21:39.558: lifecheck_ping pid 2424822: LOG: DB node id: 1 backend pid: 2424828 statement: SELECT 1
>
> Any idea? Especially better application name.
Patch pushed to master branch as it is.
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
More information about the pgpool-hackers
mailing list