[pgpool-hackers: 4603] life check log is not nice
Tatsuo Ishii
ishii at postgresql.org
Mon Jun 2 15:31:59 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.
Best regards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lifecheck.patch
Type: application/octet-stream
Size: 1176 bytes
Desc: not available
URL: <http://www.pgpool.net/pipermail/pgpool-hackers/attachments/20250602/aefe62f3/attachment.obj>
More information about the pgpool-hackers
mailing list