"Swathi S" <ss.postgres@xxxxxxxxx> 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 -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
