"Swathi S" <ss(dot)postgres(at)gmail(dot)com> writes:
> How do we find which user logged in from the OS level in postgres.
> For eg: If user "a" logged in from the OS level and logged into postgres
> psql as user "b" .........how do we find the login details?
You don't --- there's no way to find that out from the server side.
What you might consider doing is tying the OS and postgres user
identities together by using "ident" authorization --- but that's
not real secure unless all the connections are local.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Robert Treat||Date: 2008-11-20 19:37:06|
|Subject: Re: Is it safe to reset relfrozenxid without using vacuum?|
|Previous:||From: Swathi S||Date: 2008-11-20 12:12:53|
|Subject: User login|