Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aWnfn-00073c-Gj for pgsql-admin@arkaria.postgresql.org; Fri, 19 Feb 2016 16:12:51 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aWnfn-0001EJ-3X for pgsql-admin@arkaria.postgresql.org; Fri, 19 Feb 2016 16:12:51 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aWnfm-0001C9-8T for pgsql-admin@postgresql.org; Fri, 19 Feb 2016 16:12:50 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aWnfj-0005oh-PK for pgsql-admin@postgresql.org; Fri, 19 Feb 2016 16:12:49 +0000 Received: from bruce by momjian.us with local (Exim 4.72) (envelope-from ) id 1aWnfh-0008Ry-0z; Fri, 19 Feb 2016 11:12:45 -0500 Date: Fri, 19 Feb 2016 11:12:45 -0500 From: Bruce Momjian To: Evan Rempel Cc: Fujii Masao , "pgsql-admin@postgresql.org" Subject: Re: 9.5 new setting "cluster name" and logging Message-ID: <20160219161245.GE30326@momjian.us> References: <1377186808.57546.YahooMailNeo@web193505.mail.sg3.yahoo.com> <1377494614.9111.YahooMailNeo@web193506.mail.sg3.yahoo.com> <56AC5601.5040208@uvic.ca> <20160218214202.GA30326@momjian.us> <27145.1455832381@sss.pgh.pa.us> <56C64017.7050303@uvic.ca> <56C73A39.7010609@uvic.ca> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <56C73A39.7010609@uvic.ca> User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org On Fri, Feb 19, 2016 at 07:52:25AM -0800, Evan Rempel wrote: > >>Allowing for the cluster_name to be referenced by an escape sequence > >>would make manual and automated configuration management easier. > >What if log_destination is set to csvlog? The same cluster_name is > >output in every lines, and there is no way to disable it because > >something like csv_line_prefix has not been supported yet? > > > >Regards, > > > > I would think that in the case of using a csvlog that you would > configure the log_line_prefix to not include the escape sequence of > the cluster_name. The administrator would tune all of the logging > components to work together, or am I missing something here? csvlog isn't affected by log_line_prefix --- it outputs all fields every time: http://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-CSVLOG -- Bruce Momjian http://momjian.us EnterpriseDB http://enterprisedb.com + As you are, so once was I. As I am, so you will be. + + Roman grave inscription + -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin