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 A6164D1B52D for ; Tue, 27 Apr 2004 16:22:05 -0300 (ADT) 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 80310-03 for ; Tue, 27 Apr 2004 16:22:05 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 52EB7D1B51A for ; Tue, 27 Apr 2004 16:22:03 -0300 (ADT) Received: (qmail 2793 invoked by uid 500); 27 Apr 2004 19:26:18 -0000 Date: Tue, 27 Apr 2004 14:26:18 -0500 From: Bruno Wolff III To: Chris Hoover Cc: pgsql-admin@postgresql.org Subject: Re: Breaking out log by database Message-ID: <20040427192618.GA2758@wolff.to> Mail-Followup-To: Chris Hoover , pgsql-admin@postgresql.org References: <200404271321.34783.revoohc@sermonaudio.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200404271321.34783.revoohc@sermonaudio.com> User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200404/324 X-Sequence-Number: 13297 On Tue, Apr 27, 2004 at 13:21:34 -0400, Chris Hoover wrote: > Question, > > I have several db servers that have postgresql clusters with many db's (5 upto > 170) in them. Is there a way to breakout the postgres logs by the database? I don't think it is possible to do that in the released versions, but I know there was some discussions about adding the database name to the log records not too long ago. (Within the last couple of months.) So it may not be too hard to do this in 7.5 when it is released.