[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