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 09:54:29
Message-ID: AANLkTimzGPOXt3EYby+YPSbOWMY5prfSCCsh7LSrkFqA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I tried this and the limit on the log file size works.

The reason I didn't tried this before is that, I would probably have GB's of
logs and the space consumed on the disk would be same in this case also with
only difference in the number of file. Do we have some kind of pattern that
would repeat itself so that we can have let's say only five log files which
rotate themselves.

Regards,
Amit

On Wed, Aug 18, 2010 at 3:07 PM, Thom Brown <thom(at)linux(dot)com> wrote:

> On 18 August 2010 10:32, Amit Soni <get(dot)amitsoni(at)gmail(dot)com> wrote:
> > Sorry for not copying the group in my previous response. The name of the
> > largest and the only log file is "postgresql.log" and its size
> is 32900151B
> > (32M) with the current settings.
> >
>
> I believe it might be because you haven't set up a pattern for the
> filename, you've just specified a plain name.
>
> So change log_filename from "postgresql.log" to
> "postgresql-%Y-%m-%d_%H%M%S.log"
>
> --
> 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

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Thom Brown 2010-08-18 10:11:34 Re: Limiting the size of log files
Previous Message Thom Brown 2010-08-18 09:37:34 Re: Limiting the size of log files