Posts

Showing posts from April, 2021

Pgpool-II Logging and Debugging

Image
Logging and debugging help to monitor and  identify issues or problems occurring in your program. Sometimes we need to log debug information to figure out the problems during software development and testing. However, i f debug is enabled,  a large number of debug messages are generated and it is hard to read. Proper logging and debugging configurations are important. There are a number of ways to retrieve debug information from Pgpool-II. In this post, I will describe the various ways for logging and debugging Pgpool-II.  Logging Before Pgpool-II 4.1, some log processing tools (e.g. rsyslog) are required to store Pgpool-II logs and rotate them.   For example, b elow are the relevant configuration parameters for logging to syslog. log_destination = 'syslog' syslog_facility = 'LOCAL1' syslog_ident = 'pgpool'  Since Pgpool-II 4.2, logging collector process has been implemented. The logging collector process collects log messages sent to stderr and redirects t