Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9B5599FB22F for ; Mon, 2 Oct 2006 13:23:21 -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 24960-02 for ; Mon, 2 Oct 2006 13:23:16 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.livedatagroup.com (mail.livedatagroup.com [64.139.134.201]) by postgresql.org (Postfix) with ESMTP id 1A5E69F9BFA for ; Mon, 2 Oct 2006 13:23:15 -0300 (ADT) Received: by mail.livedatagroup.com (Postfix, from userid 10003) id 4A1652A5164; Mon, 2 Oct 2006 12:23:15 -0400 (EDT) Received: from [192.168.2.134] (adsl-074-228-048-194.sip.bct.bellsouth.net [74.228.48.194]) by mail.livedatagroup.com (Postfix) with ESMTP id 5DA132A5AEE; Mon, 2 Oct 2006 12:23:13 -0400 (EDT) Message-ID: <45213CF0.90009@livedatagroup.com> Date: Mon, 02 Oct 2006 12:23:12 -0400 From: Pallav Kalva User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: Andrew Sullivan CC: pgsql-admin@postgresql.org Subject: Re: Postgres Logging doesnt work References: <45212A6B.2060503@livedatagroup.com> <20061002161255.GC32410@phlogiston.dyndns.org> In-Reply-To: <20061002161255.GC32410@phlogiston.dyndns.org> Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/5 X-Sequence-Number: 23308 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 > >