Re: Need linux uid in pg-psql - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Need linux uid in pg-psql
Date
Msg-id 201108190840.24931.ahodgson@simkin.ca
Whole thread Raw
In response to Need linux uid in pg-psql  ("Gauthier, Dave" <dave.gauthier@intel.com>)
Responses Re: Need linux uid in pg-psql
Re: Need linux uid in pg-psql
List pgsql-general
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 suggestions !

There's an identd protocol for this. It's not commonly used anymore, and when
present tends to deliberately obscure the results.

pgsql-general by date:

Previous
From: Vincent de Phily
Date:
Subject: Re: altering foreign key without a table scan
Next
From: dexdyne
Date:
Subject: date_trunc - not sure what is wrong, but it confuses me.