| From: | Devrim GUNDUZ <devrim(at)commandprompt(dot)com> |
|---|---|
| To: | adey <adey11(at)gmail(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Recycle error logs |
| Date: | 2006-07-15 08:45:56 |
| Message-ID: | 1152953156.2387.8.camel@laptop.gunduz.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-07-16 05:13:01 | Re: Broken pg_class table |
| Previous Message | adey | 2006-07-15 07:37:27 | Recycle error logs |