X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id D8B0B9FB22F for ; Sat, 15 Jul 2006 05:46:03 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 28191-04 for ; Sat, 15 Jul 2006 08:45:55 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from projects.commandprompt.com (host-130.commandprompt.net [207.173.203.130]) by postgresql.org (Postfix) with ESMTP id 786559FB227 for ; Sat, 15 Jul 2006 05:45:55 -0300 (ADT) Received: from [192.168.2.3] (dsl.static8121412977.ttnet.net.tr [81.214.129.77] (may be forged)) (authenticated bits=0) by projects.commandprompt.com (8.13.6/8.13.6) with ESMTP id k6F8joeq027853; Sat, 15 Jul 2006 01:45:51 -0700 Subject: Re: Recycle error logs From: Devrim GUNDUZ To: adey Cc: "pgsql-admin@postgresql.org" In-Reply-To: <1c66bda80607150037j3c127a32tcdade264bc3f583e@mail.gmail.com> References: <1c66bda80607150037j3c127a32tcdade264bc3f583e@mail.gmail.com> Content-Type: text/plain Organization: Command Prompt, Inc. Date: Sat, 15 Jul 2006 11:45:56 +0300 Message-Id: <1152953156.2387.8.camel@laptop.gunduz.org> Mime-Version: 1.0 X-Mailer: Evolution 2.6.2 (2.6.2-1.fc5.5.sam.2) Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV version 0.88.2, clamav-milter version 0.88.2 on projects.commandprompt.com X-Virus-Status: Clean X-Greylist: Sender succeded SMTP AUTH authentication, not delayed by milter-greylist-1.6 (projects.commandprompt.com [192.168.2.159]); Sat, 15 Jul 2006 01:45:53 -0700 (PDT) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/125 X-Sequence-Number: 22371 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/