pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Thomas Munro <thomas.munro@enterprisedb.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Evan Rempel <erempel@uvic.ca>
Cc: pgsql-admin@postgresql.org, Pg Hackers <pgsql-hackers@postgresql.org>
Subject: Re: [ADMIN] 9.5 new setting "cluster name" and logging
Date: Mon, 17 Oct 2016 18:24:05 -0400
Message-ID: <20161017222405.GA13284@tamriel.snowman.net> (raw)
In-Reply-To: <CAEepm=3qzm=iROikNJFdjyZD3AJPEr3m_RFcmazBjZrzAVNoHw@mail.gmail.com>
References: <1377186808.57546.YahooMailNeo@web193505.mail.sg3.yahoo.com>
	<A737B7A37273E048B164557ADEF4A58B17C08086@ntex2010a.host.magwien.gv.at>
	<1377494614.9111.YahooMailNeo@web193506.mail.sg3.yahoo.com>
	<A737B7A37273E048B164557ADEF4A58B17C0876C@ntex2010a.host.magwien.gv.at>
	<56AC5601.5040208@uvic.ca>
	<20160208142429.5by57csmc75gorg7@alap3.anarazel.de>
	<CAEepm=3qzm=iROikNJFdjyZD3AJPEr3m_RFcmazBjZrzAVNoHw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

* Thomas Munro (thomas.munro@enterprisedb.com) wrote:
> On Tue, Feb 9, 2016 at 3:24 AM, Andres Freund <andres@anarazel.de> wrote:
> > (x-posting to -hackers, more relevant audience)
> >
> > On 2016-01-29 22:19:45 -0800, Evan Rempel wrote:
> >> Now that there is a setting to give a cluster a "name", it would be nice to
> >> have an escape sequence in the log_line_prefix setting that could reference
> >> the cluster_name.
> >
> > I've argued[1][2] for this when cluster_name was introduced, but back
> > then I seemed to have been the only one arguing for it. Josh later
> > jumped that train.
> >
> > Given that we now had a number of people wishing for this, can we maybe
> > reconsider?
> 
> +1
> 
> I missed the part of this conversation that took place on -admin.  I
> agree with Evan Rempel's post over there[1] that it's useful for
> syslog users, and that it's not ideal to have to hijack syslog_ident
> or explicitly copy the name into log_line_prefix.
> 
> [1] https://www.postgresql.org/message-id/56C64017.7050303%40uvic.ca

I'm with Thomas on this and I disagree that the "csvlog bloat" argument
has merit.  If we're worried about bloat in csv then we should provide a
way for users to control what goes into the csvlog, not argue that
something which is clearly useful be excluded.

There's already a patch out there for adding a way to control what goes
into csvlog and it probably wouldn't be too hard to update it.  I know,
because I wrote it.  I continue to feel that it would be useful to add
and that tools which need to deal with csvlogs should be updated to
handle being told what's in it, just like pgBadger does for our much
more complicated and painful regular log files.  That would remove these
bars to moving forward with more flexibility in log_line_prefix and
csvlog output.

Thanks!

Stephen

Attachments:

  signature.asc (application/pgp-signature, 818B) download

view thread (20+ messages)  latest in thread

Message-ID: <20161017222405.GA13284@tamriel.snowman.net>
Permalink:  ../20161017222405.GA13284@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20161017222405.GA13284@tamriel.snowman.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sfrost@snowman.net, thomas.munro@enterprisedb.com, andres@anarazel.de, erempel@uvic.ca, pgsql-hackers@postgresql.org
  Subject: Re: [ADMIN] 9.5 new setting "cluster name" and logging
  In-Reply-To: <20161017222405.GA13284@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox