Re: Postgres Logging doesnt work

From: Pallav Kalva <pkalva(at)livedatagroup(dot)com>
To: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres Logging doesnt work
Date: 2006-10-02 16:23:12
Message-ID: 45213CF0.90009@livedatagroup.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Andrew,

Thanks! for the reply, it is a small file. the file size on it is
735K that's pretty small. Not sure why it stopped writing to the log
file, is there any way to start logging without starting postgres ?

Pallav.

Andrew Sullivan wrote:
> On Mon, Oct 02, 2006 at 11:04:11AM -0400, Pallav Kalva wrote:
>
>> Hi ,
>>
>> My production database stopped writting to the postgres log files
>> all of a sudden, does anybody know why ?
>>
>
> How big is the file?
>
>
>> log_rotation_age | 10080
>> log_rotation_size | 0
>>
>
> You've set this up to rotate once every 10,080 minutes, no matter
> what. If you've run into a file size limit, then you'll be out of
> luck until the next file is opened, which should be on the same day
> of the week the postmaster was last started. Just a guess.
>
> A
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shoaib Mir 2006-10-02 16:35:34 Re: Postgres Logging doesnt work
Previous Message Andrew Sullivan 2006-10-02 16:12:55 Re: Postgres Logging doesnt work