> # start
>
> /var/log/postgresql.log {
> compress
> rotate 10
> create 0664 postgres postgres
> size=10000k
> weekly
> sharedscripts
> postrotate
> /etc/rc.d/init.d/postgresql restart
> endscript
> }
Alternatively, instead of restarting postgres, the "copytruncate" option can
be used to truncate the log file in place, allowing postgres to continue
writting to the file without needing to restart.
Sincerely, Warren
