pg_hba.conf and crypt/password - Mailing list pgsql-general

From Jim Mercer
Subject pg_hba.conf and crypt/password
Date
Msg-id 20010330175032.L29550@reptiles.org
Whole thread Raw
Responses Re: pg_hba.conf and crypt/password  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: pg_hba.conf and crypt/password  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
i seem to recall setting this up before, but now i can't seem to
get passwords working the way i want.

i'm running 7.0.3 on FreeBSD 4.3-RC.

i've set the entry in pg_hba.conf to both "crypt" and "password".

i've used "ALTER USER pgsql WITH PASSWORD 'test';

regardless of "crypt" or "password", psql allows entry using "test".

what i want is for the pg_shadow file to contain encrypted passwords like
/etc/passwd, and for the server to encrypt the plain text password handed
to it and compare with the crypto-gunge in pg_shadow.

is this not what "crypt" is supposed to do?

--
[ Jim Mercer          jim@pneumonoultramicroscopicsilicovolcanoconiosis.ca ]
[          Reptilian Research -- Longer Life through Colder Blood          ]
[ aka                        jim@reptiles.org              +1 416 410-5633 ]

pgsql-general by date:

Previous
From: Ed Loehr
Date:
Subject: PL/pgSQL parameter passing bug?
Next
From: Doug McNaught
Date:
Subject: Re: PL/pgSQL parameter passing bug?