<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" "http://www.w3.org/TR/REC-html40/loose.dtd">
<html><body><p>Hi PGPOOL TEAM,<br>I have questions about logs:<br><br>1. In log_min_messages the LOG type is higher than ERROR type. Is it possible to do not log client authentication like in my logs but have ERRORs and WARNINGs?<br><br>2. Why in most of logs PGPOOL dont save to log user, database, hostname (or ip) but only "[No Connection] [No Connection] [No Connection]"?? These logs dont tell me from what machine is connection...<br><br>3. I have many connecions to my PGPOOL so I need sensible logs to catch warnings, errors and other problems... What I need to change?? <br><br><br><br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 15800 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 19388 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 20727 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 20606 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 24219 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 17362 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 9834 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 19406 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 24595 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:45 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 23726 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br>kwi 22 06:33:46 <a href="http://dbsrv04.imgw.ad" target="_blank">dbp1.img.ad</a> pgpool[31419]: 13996 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend<br><br><br># - What to log -<br><br>log_line_prefix = '%p %P - %u %d %a : ' # printf-style string to output at beginning of each log line.<br><br>log_connections = off<br> # Log connections<br>log_hostname = on<br> # Hostname will be shown in ps status<br> # and in logs if connections are logged<br>log_statement = off<br> # Log all statements<br>log_per_node_statement = off<br> # Log all statements<br> # with node and backend informations<br>log_client_messages = off<br> # Log any client messages<br>log_standby_delay = 'if_over_threshold'<br><br>#log_error_verbosity = default # terse, default, or verbose messages<br><br>#client_min_messages = notice # values in order of decreasing detail:<br> # debug5<br> # debug4<br> # debug3<br> # debug2<br> # debug1<br> # log<br> # notice<br> # warning<br> # error<br><br>log_min_messages = info # values in order of decreasing detail:<br> # debug5<br> # debug4<br> # debug3<br> # debug2<br> # debug1<br> # info<br> # notice<br> # warning<br> # error<br> # log<br> # fatal<br> # panic<br><br>Regards<br>Radoslaw Szczygiel<br data-mce-bogus="1"><style type="text/css">#icselection13 {width: 100% !important; height: 100% !important; padding-top: 0px !important; overflow: visible !important;}</style></p></body></html>