Hi, 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 . Regards, -- 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/
