X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 76FC5D1B80B; Thu, 11 Mar 2004 01:28:18 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56023-02; Wed, 10 Mar 2004 21:28:18 -0400 (AST) Received: from houston.familyhealth.com.au (fhnet.arach.net.au [203.22.197.21]) by svr1.postgresql.org (Postfix) with ESMTP id 9A200D1B4F4; Wed, 10 Mar 2004 21:28:14 -0400 (AST) Received: from familyhealth.com.au (work-40.internal [192.168.0.40]) by houston.familyhealth.com.au (8.12.9p1/8.12.9) with ESMTP id i2B1SBWL069890; Thu, 11 Mar 2004 09:28:11 +0800 (WST) (envelope-from chriskl@familyhealth.com.au) Message-ID: <404FC23E.9000207@familyhealth.com.au> Date: Thu, 11 Mar 2004 09:34:54 +0800 From: Christopher Kings-Lynne User-Agent: Mozilla Thunderbird 0.5 (Windows/20040207) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Greg Spiegelberg , PgSQL Performance ML , Postgres Admin List Subject: Re: [PERFORM] syslog slowing the database? References: <404E2937.4060604@cranel.com> <370.1078877805@sss.pgh.pa.us> <404F3996.2070105@cranel.com> <7688.1078937631@sss.pgh.pa.us> In-Reply-To: <7688.1078937631@sss.pgh.pa.us> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/207 X-Sequence-Number: 12776 > You could also consider not using syslog at all: let the postmaster > output to its stderr, and pipe that into a log-rotation program. > I believe some people use Apache's log rotator for this with good > results. Not an option I'm afraid. PostgreSQL just jams and stops logging after the first rotation... I've read in the docs that syslog logging is the only "production" solution... Chris