[pgpool-general: 4128] Re: pgpool log file
Wolf Schwurack
wolf at uen.org
Wed Oct 21 00:24:56 JST 2015
Not sure what you mean by pipe the output of PGPool to rotatelogs
Here's what I have set in /etc/logrotate.d/pgpool. Then I just let logrotate run
/p04/pgpool/pgpool.log {
daily
copytruncate
create 0664 postgres postgres
dateext
rotate 7
compress
su root root
}
Thanks
Wolf
-----Original Message-----
From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Pablo Sanchez
Sent: Tuesday, October 20, 2015 9:11 AM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 4127] Re: pgpool log file
Importance: High
[ 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
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list