[pgpool-general: 7008] Re: Pgpool logs question

[Tatsuo Ishii]

> 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?
> kwi 22 06:33:46 dbp1.img.ad pgpool[31419]: 13996 CHILD - [No Connection] [No Connection] [No Connection] : LOG: md5 authentication successful with frontend

No. I personally think Pgpool-II is too verbose here and these logs
should be down graded to DEBUG1 or something like that.

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

As you can see they are mostly "authentication successful with
frontend" message and shoud be down graded to DEBUG1 I think. If it is
implemented, you don't need to worried about them anyway.

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

No, you don't need to change the current log settings. I am going to
discuss with Pgpool-II developers and change Pgpool-II as I said
above.

> 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ł
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general