X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9FD9F531C7 for ; Mon, 18 Apr 2005 18:30:30 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 95945-04 for ; Mon, 18 Apr 2005 21:30:20 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id F268153318 for ; Mon, 18 Apr 2005 18:30:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3ILUHJv026046; Mon, 18 Apr 2005 17:30:17 -0400 (EDT) To: Pallav Kalva Cc: pgsql-admin Subject: Re: Postgres Log rotation not working in 8.0.2 In-reply-to: <42642131.60603@deg.cc> References: <4264097D.7090808@deg.cc> <25685.1113857543@sss.pgh.pa.us> <42642131.60603@deg.cc> Comments: In-reply-to Pallav Kalva message dated "Mon, 18 Apr 2005 17:05:53 -0400" Date: Mon, 18 Apr 2005 17:30:17 -0400 Message-ID: <26045.1113859817@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/244 X-Sequence-Number: 17257 Pallav Kalva writes: > Postmaster is using these settings, SHOW tells me all the settings > are right as per the postgresql.conf settings. I am checking the log > rotation after restarting the postmaster, Postgres was restarted last > monday morning and it generated a new log file postgresql-15.log since > then and up until now it is still writing to the same file , its been > over a week and 6 hours now. "Week and 6 hours"? Try waiting a bit longer. The switchover points are not x-hours-since-postmaster-start, they are designed to be reasonable integer multiples. For instance, with rotation set for 24 hours, rotation occurs at local midnight, not whatever time of day the postmaster was last restarted as. With a 7-day setting it should occur at local midnight of days that are a multiple of 7 days since 1-1-1970 ... which is Thursdays I think. What I suspect happened is that it rotated last Thursday midnight, but since %U hadn't changed since Monday, it overwrote the same file it was using before. Check to see what the oldest entry in the file is ... regards, tom lane