Jaime Casanova <jcasa...@systemguards.com.ec> wrote: > Kevin Grittner<kevin.gritt...@wicourts.gov> wrote: >> On the admin list there was a request for an application name >> column in pg_stat_activity. > ah? how do you implement that? and what's the use case for? It would be passed as a connection property. (If that's not feasible, perhaps a session GUC, which could map to a client-side connection property is JDBC, etc.) For many environments, it is at least as important as an IP address or PID to help someone managing a database with a lot of connections. It would not do anything on the server except show up in pg_stat_activity as another piece of information about each connection. We would probably want to modify psql, pg_dump, etc. to put the application name into this connection property, at least by default. We may want to add a command-line switch to allow user override -- to provide something more detailed. For example, --application-name='Weekly Purge' could by specified on the psql command line. Yes, this is only as useful as the compliance of the client applications make it. -Kevin
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
