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