View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000489 | Pgpool-II | Bug | public | 2019-04-02 16:47 | 2019-04-04 08:58 |
| Reporter | siva | Assigned To | pengbo | ||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.7.8 | ||||
| Summary | 0000489: Not able generate log for syslog destinatio | ||||
| Description | Hi Team, We have configured log_destination to 'syslog,syserr' , all log message are going to syserr but we are not able generate log in pool specific log file(/var/log/pgpool.log). We have problem with common log that is /var/log/messages which has rotation policy in place so every 2 days log has been rotating not able to maintain the log for long time . Could you please help us to configure the log to syslog destination. Below is our configuration: # - Where to log - log_destination = 'stderr,syslog' # - What to log - log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line. log_connections = on log_hostname = on log_statement = on log_per_node_statement = on log_standby_delay = 'always' # - Syslog specific - syslog_facility = 'LOCAL0' syslog_ident = 'pgpool' # - Debug - log_error_verbosity = default # terse, default, or verbose messages client_min_messages = notice # values in order of decreasing detail: Below is syslogd configuration file addition as per the documentation to enable syslog facility(http://www.pgpool.net/docs/latest/en/html/runtime-config-logging.html#GUC-SYSLOG-FACILITY) [root@INHUSZ1-V1625126 log]# cat /etc/syslog.conf local0.* /var/log/pgpool.log [root@INHUSZ1-V1625126 log]# Please help us to do above configuration | ||||
| Steps To Reproduce | Below are the steps to reproduce: Below is our configuration: # - Where to log - log_destination = 'stderr,syslog' # - What to log - log_line_prefix = '%t: pid %p: ' # printf-style string to output at beginning of each log line. log_connections = on log_hostname = on log_statement = on log_per_node_statement = on log_standby_delay = 'always' # - Syslog specific - syslog_facility = 'LOCAL0' syslog_ident = 'pgpool' # - Debug - log_error_verbosity = default # terse, default, or verbose messages client_min_messages = notice # values in order of decreasing detail: | ||||
| Tags | No tags attached. | ||||
|
|
You need to create log file "/var/log/pgpool.log" first and change the owner of "/var/log/pgpool.log" to pgpool startup user. |
|
|
Below is an example: http://www.pgpool.net/docs/latest/en/html/example-cluster.html#EXAMPLE-CLUSTER-PGPOOL-CONFIG-LOG |
|
|
Thanks a lot pengbo... Now i can able to configure logging for pgpool. Please close the request :) |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2019-04-02 16:47 | siva | New Issue | |
| 2019-04-03 13:41 | pengbo | Assigned To | => pengbo |
| 2019-04-03 13:41 | pengbo | Status | new => assigned |
| 2019-04-03 13:42 | pengbo | Note Added: 0002503 | |
| 2019-04-03 13:44 | pengbo | Note Added: 0002504 | |
| 2019-04-03 19:23 | siva | Note Added: 0002512 | |
| 2019-04-04 08:58 | pengbo | Status | assigned => closed |
