Postgres Pro
Downloads
Home   >   mailing lists

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

From Andres Freund
Subject Re: proposal: hide application_name from other users
Date
Msg-id 20140128155240.GA18333@awork2.anarazel.de
Whole thread Raw
In response to Re: proposal: hide application_name from other users  (Greg Stark <stark@mit.edu>)
List pgsql-hackers
Tree view 
On 2014-01-28 07:27:52 -0800, Greg Stark wrote:
> > And all of that without removing a valuable debugging/tracing tool from
> > other users.
> 
> Why is application_name useful for users who aren't the DBA and aren't
> the user in question. The sql_query would probably be more useful than
> application_name but we hide that...

It is useful to find out what the backend blocking you by taking out
locks or using all CPU is doing. And a sql query obviously can contain
actually sensitive data that you can't really hide.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: jsonb and nested hstore
Next
From: Christian Kruse
Date:
Subject: Re: Suspicion of a compiler bug in clang: using ternary operator in ereport()