Re: [GENERAL] Need linux uid in pg-psql

2011-08-19 Thread Tom Lane
"Gauthier, Dave" writes: > Not too worried about nefarious id faking in this environment. > How does one use "identd" in an unobscured way? There's a command-line switch for the identd daemon, on most machines, that tells it whether to send hashed or plaintext responses.

Re: [GENERAL] Need linux uid in pg-psql

2011-08-19 Thread Gauthier, Dave
M To: Alan Hodgson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Need linux uid in pg-psql Alan Hodgson writes: > On August 19, 2011 07:01:33 AM Gauthier, Dave wrote: >> Is there a way to get the linux idsid of a user, even for a remote network >> connection? > There&#

Re: [GENERAL] Need linux uid in pg-psql

2011-08-19 Thread Tom Lane
Alan Hodgson writes: > On August 19, 2011 07:01:33 AM Gauthier, Dave wrote: >> Is there a way to get the linux idsid of a user, even for a remote network >> connection? > There's an identd protocol for this. It's not commonly used anymore, and when > present tends to deliberately obscure the resu

Re: [GENERAL] Need linux uid in pg-psql

2011-08-19 Thread Chris Travers
On Fri, Aug 19, 2011 at 8:40 AM, Alan Hodgson wrote: > On August 19, 2011 07:01:33 AM Gauthier, Dave wrote: >> Is there a way to get the linux idsid of a user, even for a remote network >> connection? >> >> I could write a pg-perlu to get this, but I suspect it won't give me the >> original user w

Re: [GENERAL] Need linux uid in pg-psql

2011-08-19 Thread Alan Hodgson
On August 19, 2011 07:01:33 AM Gauthier, Dave wrote: > Is there a way to get the linux idsid of a user, even for a remote network > connection? > > I could write a pg-perlu to get this, but I suspect it won't give me the > original user when there's a remote connect. > > Thanks for any suggestion

[GENERAL] Need linux uid in pg-psql

2011-08-19 Thread Gauthier, Dave
Is there a way to get the linux idsid of a user, even for a remote network connection? If not, is there a way to capture this somehow when the original connection is made and maybe stuff it in a temp table or something using whatever means (a trigger-like mechanism? ) ? Is there a script/func