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 6FEF1533B6 for ; Tue, 19 Apr 2005 10:42:31 -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 81714-02 for ; Tue, 19 Apr 2005 13:42:26 +0000 (GMT) Received: from mail.deg.cc (mail.deg.cc [64.139.134.201]) by svr1.postgresql.org (Postfix) with ESMTP id 5D01353388 for ; Tue, 19 Apr 2005 10:42:25 -0300 (ADT) Received: from deg.cc (unknown [205.242.255.66]) by mail.deg.cc (Postfix) with ESMTP id 24D3A560AE; Tue, 19 Apr 2005 09:42:27 -0400 (EDT) Message-ID: <42650AC4.3010902@deg.cc> Date: Tue, 19 Apr 2005 09:42:28 -0400 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-admin Subject: Re: Postgres Log rotation not working in 8.0.2 References: <4264097D.7090808@deg.cc> <25685.1113857543@sss.pgh.pa.us> <42642131.60603@deg.cc> <26045.1113859817@sss.pgh.pa.us> In-Reply-To: <26045.1113859817@sss.pgh.pa.us> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200504/260 X-Sequence-Number: 17273 Tom Lane wrote: >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 ... > > > It didnt overwrite the file, the last log entry on the file is from 2005-04-11 which is last monday.