PG and login

From: "Jarmo Paavilainen" <netletter(at)comder(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PG and login
Date: 2000-11-05 21:29:22
Message-ID: 001901c0476f$76cc0d00$1501a8c0@theboss.comder.private
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

Where does the backend do its user validation?

If I login with "psql -u" how does the backend take care of the username and
password?

Ive tried to find where it happens without success (using a lot of
elog(DEBUG,...)). (we are talking "password" identification, not "ident",
kerberos or "crypt").

Ive located where the pg_shadow compare happens, but If I give a wrong
username it will not even get that far. "pg_pwd" is never created so I
assume its not used. So how in h*** does pg do it? And where? (which
function?, file? mechanism?).

Im trying to make usernames caseless (yes I enforce that people use
ASCII-only (32-127) in usernames, and yes this is not SQL92).
pgsql-general(at)postgresql(dot)org

// Jarmo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2000-11-05 22:22:30 Re: PG and login
Previous Message John McKown 2000-11-05 19:42:27 Re: where to find postgresql jobs in the Washington, DC area??