Skip site navigation (1) Skip section navigation (2)

Re: Limiting the size of log files

From: Amit Soni <get(dot)amitsoni(at)gmail(dot)com>
To: Thom Brown <thom(at)linux(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Limiting the size of log files
Date: 2010-08-18 14:58:28
Message-ID: AANLkTi=NJS=EOo_e9sV_TQi_njba=g_1UKLs2=VTcFrk@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Thanks for the logrotate. Will try the linux logrotate utiliy.

Regards,
Amit

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
> since
> > limiting the size of the file is only possible when we use some time
> related
> > pattern in the filename (which I should have deduced from
> > "log_truncate_on_rotation" not working on the size driven rotation), I
> see
> > 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
>



-- 
Amit Soni
Software Engineer
Avaya India Pvt. Ltd.
Phone: +91-9579615149
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 AndersonDate: 2010-08-18 15:15:27
Subject: Re: List of User Defined Types?
Previous:From: Amit SoniDate: 2010-08-18 10:56:50
Subject: Re: Limiting the size of log files

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group