Re: proposal: hide application_name from other users - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: proposal: hide application_name from other users
Date
Msg-id 20140122003836.GR31026@tamriel.snowman.net
Whole thread Raw
In response to Re: proposal: hide application_name from other users  (Harold Giménez <harold@heroku.com>)
Responses Re: proposal: hide application_name from other users  (Harold Giménez <harold@heroku.com>)
Re: proposal: hide application_name from other users  (Kevin Grittner <kgrittn@ymail.com>)
Re: proposal: hide application_name from other users  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
* Harold Giménez (harold@heroku.com) wrote:
> Definitely agree with you. This is just an example of how running
> monitoring as superuser is not necessarily the worst thing, and there
> are other reasons to do it already.

It's a horrible thing and that isn't a good reason- if my database isn't
accepting connections, I probably don't care one bit how bloated a table
is.  Indeed, I care *more* that I'm out of connections and would want to
know that ASAP.

That said, I'm not against the general idea that the 'reserved'
connections be opened up to roles beyond superuser (or have some kind of
priority system, etc), but that's an independent concern and should not
be a justification for making monitoring require superuser privs.
Thanks,
    Stephen

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Hard limit on WAL space used (because PANIC sucks)
Next
From: Harold Giménez
Date:
Subject: Re: proposal: hide application_name from other users