Skip site navigation (1) Skip section navigation (2)

Re: Postgres Log rotation not working in 8.0.2

From: Pallav Kalva <pkalva(at)deg(dot)cc>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgres Log rotation not working in 8.0.2
Date: 2005-04-19 13:42:28
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
Tom Lane wrote:

>Pallav Kalva <pkalva(at)deg(dot)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.

In response to


pgsql-admin by date

Next:From: John DeSoiDate: 2005-04-19 13:50:33
Subject: Re: Missing commands
Previous:From: Dextra - Gustavo Bartz GuedesDate: 2005-04-19 13:40:45
Subject: PAM authentication

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group