William L James writes:
> script - su -l postgresql -c "/usr/bin/pg_ctl -D $PGDATA -p
> /usr/bin/postmaster start >>/var/log/postgresql 2>&1"), but
> when the weekly logrotate.d function kicks in, Postgres logging
> stops.
The logging probably continues to go to the rotated-away file. The
typical log rotation cron job presumes that the daemons close the log
files periodically. This is not the case with PostgreSQL. A good
solution is to pipe your log output to a small program that does the log
rotating (or simply closes the log file once in a while), like rotatelogs
from Apache.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/