Re: Cluster name in ps output - Mailing list pgsql-hackers

From Thomas Munro
Subject Re: Cluster name in ps output
Date
Msg-id CADLWmXVsQs0RyD_Q_XTF8O9NBVWQW0exuB1jpyF7r=mEjQ7Z9g@mail.gmail.com
Whole thread Raw
In response to Re: Cluster name in ps output  (Thomas Munro <munro@ip9.org>)
List pgsql-hackers
On 5 May 2014 10:49, Thomas Munro <munro@ip9.org> wrote:
On 5 May 2014 10:10, Andres Freund <andres@2ndquadrant.com> wrote:
I guess the question is where this should be available as well. At the
very least I'd want to reference it in log_line_prefix as well?

Good idea, I will look into that.

See v2 patch attached which lets you use %C for cluster name in the log prefix.

Maybe it would be overkill, but seeing the various responses about which information belongs in the ps string, I guess we could also use a format string with %blah fields for that.  Then the Debian/Ubuntu package users who tend to think of the major version + name as the complete cluster identifier could use "[%V/%C] ..." to get "postgres: [9.3/main] ...", and others could throw in a "%P" to see a port number.
Attachment

pgsql-hackers by date:

Previous
From: Stephen Frost
Date:
Subject: Re: Cluster name in ps output
Next
From: Heikki Linnakangas
Date:
Subject: Re: Fix initdb for path with whitespace and at char