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

From Peter Eisentraut
Subject Re: pg_hba.conf and password/crypt authorization
Date
Msg-id Pine.GSO.4.02A.10005311309250.698-100000@Gepard.DoCS.UU.SE
Whole thread Raw
In response to pg_hba.conf and password/crypt authorization  (Dana Eckart <dana@runet.edu>)
List pgsql-general
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


pgsql-general by date:

Previous
From: Radu Coroi
Date:
Subject: ...
Next
From: Alex Pilosov
Date:
Subject: Re: PostgreSQL capabilities