[pgpool-general: 4127] Re: pgpool log file
Pablo Sanchez
pablo at blueoakdb.com
Wed Oct 21 00:11:17 JST 2015
[ 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
More information about the pgpool-general
mailing list