Re: PG and login

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Jarmo Paavilainen <netletter(at)comder(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PG and login
Date: 2000-11-05 22:22:30
Message-ID: Pine.LNX.4.21.0011052318440.780-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)gmx(dot)net http://yi.org/peter-e/

In response to

  • PG and login at 2000-11-05 21:29:22 from Jarmo Paavilainen

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2000-11-06 05:17:52 Expectations of MEM requirements for a DB with large tables.
Previous Message Jarmo Paavilainen 2000-11-05 21:29:22 PG and login