[pgpool-general: 6532] Re: pgpool log and process info
Tatsuo Ishii
ishii at sraoss.co.jp
Wed May 1 20:37:02 JST 2019
Probably you want to turn on debugging log:
log_min_messages = debug5
Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp
> I have problem with getting information from pgpool log about connections from user or apps. From journalctl i get information like that:
>
> Apr 18 07:16:12 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG: child process with pid: 12218 exits with status 256
> Apr 18 07:16:12 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG: fork a new child process with pid: 13207
> Apr 18 07:16:15 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG: new connection received
> Apr 18 07:16:15 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: DETAIL: connecting host=host1 port=62674
> Apr 18 07:16:15 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG: md5 authentication successful with frontend
> Apr 18 07:16:31 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG: child process with pid: 12003 exits with status 256
> Apr 18 07:16:31 http://dbsrv04.imgw.ad">srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG: fork a new child process with pid: 13223
>
>
> my log conf in http://pgpool.conf">pgpool.conf:
>
> log_line_prefix = '%a %d %u: '
> log_connections = on
> log_hostname = on
>
> Like You see the logs are less of information (no connection etc.). Is there is possible in pgpool to get more information about clients? When something is wrong i dont know which client do problem and I cant trace who it what is making problem.
> Execute command pcp_proc_info dont show interesting informations like client ip.
>
> Regards
> Radoslaw Szczygiel
>
More information about the pgpool-general
mailing list