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 33158D1D2E2 for ; Thu, 11 Mar 2004 02:01:14 +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 57309-08 for ; Wed, 10 Mar 2004 22:01:16 -0400 (AST) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id AE6FED1D263 for ; Wed, 10 Mar 2004 22:01:11 -0400 (AST) Received: (qmail 13421 invoked by uid 500); 11 Mar 2004 02:03:46 -0000 Date: Wed, 10 Mar 2004 20:03:46 -0600 From: Bruno Wolff III To: Christopher Kings-Lynne Cc: Tom Lane , Greg Spiegelberg , PgSQL Performance ML , Postgres Admin List Subject: Re: [PERFORM] syslog slowing the database? Message-ID: <20040311020346.GA13391@wolff.to> Mail-Followup-To: Christopher Kings-Lynne , Tom Lane , Greg Spiegelberg , PgSQL Performance ML , Postgres Admin List References: <404E2937.4060604@cranel.com> <370.1078877805@sss.pgh.pa.us> <404F3996.2070105@cranel.com> <7688.1078937631@sss.pgh.pa.us> <404FC23E.9000207@familyhealth.com.au> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <404FC23E.9000207@familyhealth.com.au> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/194 X-Sequence-Number: 12763 On Thu, Mar 11, 2004 at 09:34:54 +0800, Christopher Kings-Lynne wrote: > >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... I use multilog to log postgres' output and it works fine.