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.
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