pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Pallav Kalva <pkalva@deg.cc>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Postgres Log rotation not working in 8.0.2
Date: Tue, 19 Apr 2005 09:42:28 -0400
Message-ID: <42650AC4.3010902@deg.cc> (raw)
In-Reply-To: <26045.1113859817@sss.pgh.pa.us>
References: <4264097D.7090808@deg.cc>
	<25685.1113857543@sss.pgh.pa.us>
	<42642131.60603@deg.cc>
	<26045.1113859817@sss.pgh.pa.us>

Tom Lane wrote:

>Pallav Kalva <pkalva@deg.cc> 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.






view thread (10+ messages)  latest in thread

Message-ID: <42650AC4.3010902@deg.cc>
Permalink:  ../42650AC4.3010902@deg.cc/
Also on:    postgresql.org/message-id/42650AC4.3010902@deg.cc

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: pkalva@deg.cc, tgl@sss.pgh.pa.us
  Subject: Re: Postgres Log rotation not working in 8.0.2
  In-Reply-To: <42650AC4.3010902@deg.cc>
  References: <4264097D.7090808@deg.cc> <25685.1113857543@sss.pgh.pa.us> <42642131.60603@deg.cc> <26045.1113859817@sss.pgh.pa.us> <42650AC4.3010902@deg.cc>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox