[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