| From: | Peter Eisentraut <e99re41(at)DoCS(dot)UU(dot)SE> |
|---|---|
| To: | Dana Eckart <dana(at)runet(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_hba.conf and password/crypt authorization |
| Date: | 2000-05-31 11:11:17 |
| Message-ID: | Pine.GSO.4.02A.10005311309250.698-100000@Gepard.DoCS.UU.SE |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Louis-David Mitterrand | 2000-05-31 12:37:49 | pg_dump -c doesn't order DROP TABLE correctly w.r.t inheritance |
| Previous Message | Howard | 2000-05-31 09:35:04 | Any limit on data type,...? |