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

From Chris Travers
Subject Re: Need linux uid in pg-psql
Date
Msg-id CAKt_ZfuJZEbifyHfE_kVzg4YsxLcKcFwCBROaybNM6xx=gG0Dw@mail.gmail.com
Whole thread Raw
In response to Re: Need linux uid in pg-psql  (Alan Hodgson <ahodgson@simkin.ca>)
List pgsql-general
On Fri, Aug 19, 2011 at 8:40 AM, Alan Hodgson <ahodgson@simkin.ca> 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 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.
>
Couldn't you use client ssl certs for authentication and encode the
data there in the cert?

Best Wishes,
Chris Travers

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: altering foreign key without a table scan
Next
From: Tom Lane
Date:
Subject: Re: Need linux uid in pg-psql