On Sat, 2006-07-15 at 19:37 +1200, adey wrote:
> Please advise if there is a way to start a fresh Postgresql error /
> output log at regular intervals?
PostgreSQL 8.0.0 and above has a built-in log rotation mechanism. Check
postgresql.conf for this. See the section "Error reporting and logging".
log_rotation_age will help you to determine daily rotation. Also set
log_filename to point only to %Y-%m-%d .
The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2006-07-16 05:13:01|
|Subject: Re: Broken pg_class table |
|Previous:||From: adey||Date: 2006-07-15 07:37:27|
|Subject: Recycle error logs|