[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