[pgpool-general: 7006] Pgpool logs question

[Radosław Szczygieł]

Hi PGPOOL TEAM,
I have questions about logs:

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?

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... 

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?? 


kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 15800 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 19388 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 20727 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 20606 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 24219 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 17362 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 9834 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 19406 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 24595 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:45 dbp1.img.ad pgpool[31419]: 23726 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

kwi 22 06:33:46 dbp1.img.ad pgpool[31419]: 13996 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

# - What to log -

log_line_prefix = '%p %P - %u %d %a : '   # printf-style string to output at beginning of each log line.

log_connections = off
# Log connections

log_hostname = on
 # Hostname will be shown in ps status
# and in logs if connections are logged

log_statement = off
 # Log all statements

log_per_node_statement = off
# Log all statements
 # with node and backend informations

log_client_messages = off
 # Log any client messages

log_standby_delay = 'if_over_threshold'

#log_error_verbosity = default    # terse, default, or verbose messages

#client_min_messages = notice
 # values in order of decreasing detail:
# debug5
#debug4
#debug3
#debug2
#debug1
#log
#notice
#warning
#error

log_min_messages = info   # values in order of decreasing detail:
#debug5
#debug4
#debug3
# debug2
#debug1
#info
# notice
# warning
#error
#log
# fatal
# panic


Regards
Radoslaw Szczygiel

--
Pozdrawiam
Radosław Szczygieł