Re: Postgres Log rotation not working in 8.0.2 - Mailing list pgsql-admin

From Pallav Kalva
Subject Re: Postgres Log rotation not working in 8.0.2
Date
Msg-id 42642131.60603@deg.cc
Whole thread Raw
In response to Re: Postgres Log rotation not working in 8.0.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres Log rotation not working in 8.0.2
Re: Postgres Log rotation not working in 8.0.2
List pgsql-admin
Hi Tom,

     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.

Pallav.

Tom Lane wrote:

>Pallav Kalva <pkalva@deg.cc> writes:
>
>
>>       Postgres log rotation doesnt seem to behave properly, below are
>>the settings which I used for log rotation. I want the postgres log to
>>be rotated every week , its past over a week now and it still writing to
>>the old log.
>>
>>
>
>Well, that rotation setting should rotate every 7 days all right.  Are
>you sure the postmaster is really using these settings?  (Check with SHOW.)
>In particular, I wonder whether you remembered that changing
>redirect_stderr requires an actual postmaster restart, not just SIGHUP.
>
>            regards, tom lane
>
>
>



pgsql-admin by date:

Previous
From: Dawid Kuroczko
Date:
Subject: Re: brute force attacking the password
Next
From: "C. Bensend"
Date:
Subject: Re: brute force attacking the password