Re: Postgres Log rotation not working in 8.0.2

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