Re: Postgres Logging doesnt work

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postgres Logging doesnt work
Date: 2006-10-02 16:12:55
Message-ID: 20061002161255.GC32410@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
"The year's penultimate month" is not in truth a good way of saying
November.
--H.W. Fowler

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Pallav Kalva 2006-10-02 16:23:12 Re: Postgres Logging doesnt work
Previous Message tatyana.krasnokutsky 2006-10-02 16:06:51 Please. Do cancel my subscription!!