Thread: pg_hba.conf and password/crypt authorization

pg_hba.conf and password/crypt authorization

From
Dana Eckart
Date:
Things work fine with the authorization type in pg_hba.conf set to "trust".
However, when I try to use either "crypt" or "password" psql fails to
authenticate either the postgresql super-user (mylocal in my case) or any
other non-privelegded user.  I am using  version 7.0 under RedHat Linux 6.1
and have read and tried to apply the techniques described in the 6 May 1999
issue (Vol 1, Number 308) of the pgsql-general-digest.  Any helpful hints
would be greatly appreciated.

Thanks.

--dana (jde@acm.org)

Re: pg_hba.conf and password/crypt authorization

From
Peter Eisentraut
Date:
On Tue, 30 May 2000, Dana Eckart wrote:

> Things work fine with the authorization type in pg_hba.conf set to "trust".
> However, when I try to use either "crypt" or "password" psql fails to
> authenticate either the postgresql super-user (mylocal in my case) or any
> other non-privelegded user.

In a fresh installation the database users don't have passwords yet, so
you must give them some first. (ALTER USER xxx WITH PASSWORD 'yyy').


--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden