Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id C47F19FB335 for ; Mon, 2 Oct 2006 14:39:34 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 32414-09 for ; Mon, 2 Oct 2006 17:39:30 +0000 (UTC) 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 E4B439FB220 for ; Mon, 2 Oct 2006 14:39:29 -0300 (ADT) Received: by mail.livedatagroup.com (Postfix, from userid 10003) id 2869E291BAE; Mon, 2 Oct 2006 13:39:29 -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 DD2FD2913F5; Mon, 2 Oct 2006 13:39:26 -0400 (EDT) Message-ID: <45214ECE.5030303@livedatagroup.com> Date: Mon, 02 Oct 2006 13:39:26 -0400 From: Pallav Kalva User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: Shoaib Mir CC: Andrew Sullivan , pgsql-admin@postgresql.org Subject: Re: Postgres Logging doesnt work References: <45212A6B.2060503@livedatagroup.com> <20061002161255.GC32410@phlogiston.dyndns.org> <45213CF0.90009@livedatagroup.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/10 X-Sequence-Number: 23313 Thanks! Shoaib, that worked real good. Not sure why it stopped in the first place. Shoaib Mir wrote: > I guess that might work: > > 1. Set the following in postgresql.conf file --> log_rotation_age = 1 > 2. rename the already present log file from dbserver logs folder > 3. Now do --> pg_ctl reload (so that log_rotation_age change you did > comes in affect) > 4. Check the log folder after a while (after 1 minutes) and it will be > having a new log file and doing all the logging there > 5. After it starts the logging you can revert the change done to > rotation_age and do a reload again. > > Thanks, > --- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com ) > > > > On 10/2/06, *Pallav Kalva * > wrote: > > 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 > > > > > > > ---------------------------(end of > broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match > >