[pgpool-general: 6530] pgpool log and process info

Radosław Szczygieł radoslaw.szczygiel at interia.pl
Wed May 1 18:36:48 JST 2019


Hi,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 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG:  child process with pid: 12218 exits with status 256Apr 18 07:16:12 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG:  fork a new child process with pid: 13207Apr 18 07:16:15 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG:  new connection receivedApr 18 07:16:15 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: DETAIL:  connecting host=host1 port=62674Apr 18 07:16:15 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG:  md5 authentication successful with frontendApr 18 07:16:31 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG:  child process with pid: 12003 exits with status 256Apr 18 07:16:31 srv1 pgpool[1933]: [No Connection] [No Connection] [No Connection]: LOG:  fork a new child process with pid: 13223my log conf in pgpool.conf:log_line_prefix = '%a %d %u: ' log_connections = onlog_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.RegardsRadoslaw Szczygiel--Pozdrawiam
Radosław Szczygieł
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20190501/f02b1e56/attachment.html>


More information about the pgpool-general mailing list