Re: user connection properties - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: user connection properties
Date
Msg-id 4A5F32760200002500028842@gw.wicourts.gov
Whole thread Raw
In response to Re: user connection properties  (Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca>)
List pgsql-admin
Isabella Ghiurea <isabella.ghiurea@nrc-cnrc.gc.ca> wrote:

> I don't think optional is  the right word,.

The issue is that the server has no clue what the application is
beyond what the client sends over the wire, so the server must trust
the client to tell it something useful.  There is a lot of code out
there which doesn't set this (so far nonexistent) connection property,
and I'm sure that breaking all of that code is not an option.  Hence,
if we add it, it will be optional.

> This information should be collected  in one of the  internal table,
> next to  client's host ip and user  name .

This would probably show up in pg_stat_activity somewhere.

>  BTW: I don't know to much about PG 's " feature wish list " ,  if
> we get more feedback  from some of the  Gurus  we can  add this one
> to the list.

There is a TODO list.

http://wiki.postgresql.org/wiki/Todo

I'll suggest this be added.

-Kevin

pgsql-admin by date:

Previous
From: Carol Walter
Date:
Subject: Re: Old version?
Next
From: Scott Marlowe
Date:
Subject: Re: commit within function