Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 783FE9FB3A8 for ; Mon, 2 Oct 2006 13:13:12 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 21404-06 for ; Mon, 2 Oct 2006 13:13:07 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 8B6779FB2CC for ; Mon, 2 Oct 2006 13:13:05 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1GUQhU-0008FY-1R for pgsql-admin@postgresql.org; Mon, 02 Oct 2006 12:31:28 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id B07613FAF; Mon, 2 Oct 2006 12:12:55 -0400 (EDT) Date: Mon, 2 Oct 2006 12:12:55 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: Postgres Logging doesnt work Message-ID: <20061002161255.GC32410@phlogiston.dyndns.org> References: <45212A6B.2060503@livedatagroup.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <45212A6B.2060503@livedatagroup.com> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.2 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200610/4 X-Sequence-Number: 23307 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@crankycanuck.ca "The year's penultimate month" is not in truth a good way of saying November. --H.W. Fowler