[pgpool-hackers: 4556] Re: Feature Request: jsonlog & csvlog options on log_destination configuration

[Tatsuo Ishii]

> On current version (v4.5.5), Pgpool only supports syslog & stderr for
> log_destination while PostgreSQL supports csvlog since v8.3 & jsonlog since
> v15. On the source code, I see trace of csvlog being implemented, but it is
> not supported when I try it myself.
> https://github.com/pgpool/pgpool2/blob/5752de9913d91788f6efe8338aca82dca0c694d5/src/include/utils/elog.h#L505

Yeah, pgpool does not support jsonlog.

> It'd be great addition especially on jsonlog because it is very convenient
> for logging. If implemented just like on PostgreSQL, it will print the log
> on a single-line rather than multiple-line when we increase the log level
> such as displaying SQL Statement.

I personally have never used jsonlog on PostgreSQL. So I am not sure
how it would be useful for some use cases. If you have an experience
with jsonlog, can you elaborate?

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp