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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Sean Anderson | 2010-08-18 15:15:27 | Re: List of User Defined Types? |
Previous Message | Amit Soni | 2010-08-18 10:56:50 | Re: Limiting the size of log files |