Naomi,
We're using Red Hat Linux logrotate to do this
A file we called pgsql is put in the /etc/logrotate.d directory, it's
contents are as follows
/var/log/pgsql {
rotate 5
copytruncate
daily
size=1k
}
This rotates the log files each morning when the daily cron jobs are
run. We
Naomi Walker <[EMAIL PROTECTED]> writes:
> Do I have to bounce the cluster to roll the log? How should I be
> performing this task?
There's some discussion of this point in the 7.2 docs:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/logfile-maintenance.html
