Thanks for the logrotate. Will try the linux logrotate utiliy.
On Wed, Aug 18, 2010 at 4:13 PM, Thom Brown <thom(at)linux(dot)com> wrote:
> On 18 August 2010 11:34, Amit Soni <get(dot)amitsoni(at)gmail(dot)com> wrote:
> > Sorry for not stating this earlier. It's possible for me to have ~20GB of
> > logs in one day. So, per day rotation is not the best option here. And
> > limiting the size of the file is only possible when we use some time
> > pattern in the filename (which I should have deduced from
> > "log_truncate_on_rotation" not working on the size driven rotation), I
> > the chances of getting what I need as very slim.
> > Any other suggestion would be greatly appreciated.
> > Thanks & Regards,
> > Amit
> Just change it so that it wraps after an hour then:
> log_filename to "postgresql-%M.log"
> log_rotation_age to 1
> log_rotation_size to 0
> log_truncate_on_rotation to on
> Or just go back to "postgresql.log" and use a separate log rotator to
> do the task for you, like logrotate.
> Thom Brown
> Registered Linux user: #516935
Avaya India Pvt. Ltd.
Email-id: get(dot)amitsoni(at)gmail(dot)com, get(dot)amitsoni(at)hotmail(dot)com
In response to
pgsql-novice by date
|Next:||From: Sean Anderson||Date: 2010-08-18 15:15:27|
|Subject: Re: List of User Defined Types?|
|Previous:||From: Amit Soni||Date: 2010-08-18 10:56:50|
|Subject: Re: Limiting the size of log files|