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(at)deg(dot)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
>
>
>