[pgpool-general: 4127] Re: pgpool log file

[Pablo Sanchez]

[ Comments below, in-line ]


On 10/20/15 11:07, Wolf Schwurack wrote:
> I have pgpool.conf parameter ‘log_statement = on’ Which we want to log
> all statement. I rotate the log every day with logrotate. But pgpool.log
> keeps growing, it show 46G. When I check the file it show it as a Data
> file.
>
> How can I rotate the log file without restarting pgpool?
>

Hi Wolf,

Pipe the output of PGPool to rotatelogs and use rotatelogs.
rotatelogs has many options.  One of which is to rotate a log after it
has grown to X size.

Cheers,
--
Pablo Sanchez - Blueoak Database Engineering, Inc
Ph:    819.459.1926         Blog:  http://pablo-blog.blueoakdb.com
iNum:  883.5100.0990.1054