Postgres Pro
Downloads
Home   >   mailing lists

Re: Limiting the size of log files - Mailing list pgsql-novice

From Amit Soni
Subject Re: Limiting the size of log files
Date
Msg-id AANLkTimzGPOXt3EYby+YPSbOWMY5prfSCCsh7LSrkFqA@mail.gmail.com
Whole thread Raw
In response to Re: Limiting the size of log files  (Thom Brown <thom@linux.com>)
Responses Re: Limiting the size of log files  (Thom Brown <thom@linux.com>)
List pgsql-novice
Tree view
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@linux.com> wrote:
On 18 August 2010 10:32, Amit Soni <get.amitsoni@gmail.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.amitsoni@gmail.com, get.amitsoni@hotmail.com

pgsql-novice by date:

Previous
From: Thom Brown
Date:
Subject: Re: Limiting the size of log files
Next
From: Thom Brown
Date:
Subject: Re: Limiting the size of log files