Re: PG and login - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: PG and login
Date
Msg-id Pine.LNX.4.21.0011052318440.780-100000@peter.localdomain
Whole thread Raw
In response to PG and login  ("Jarmo Paavilainen" <netletter@comder.com>)
Responses SV: PG and login
List pgsql-general
Jarmo Paavilainen writes:

> 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?).

Of interest would be

src/backend/libpq/auth.c: checkPassword()
                  password.c
                  crypt.c

The compare always happens against pg_pwd, which gets created everytime
you create or alter a user with password.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: "Jarmo Paavilainen"
Date:
Subject: PG and login
Next
From: "Michael Miyabara-McCaskey"
Date:
Subject: Expectations of MEM requirements for a DB with large tables.