From: | Ron Peterson <ron(dot)peterson(at)yellowbank(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | create user, user exists |
Date: | 2001-03-16 17:50:57 |
Message-ID: | Pine.LNX.4.30.0103161221270.27683-100000@h00a024ee7419.ne.mediaone.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm having a bit of authentication trouble. I'm trying to use 'crypt'
authentication. PostgreSQL 7.1beta5. My pg_hba.conf is as follows:
#local all trust
local all crypt passtest
When I do 'local all trust', everything works fine. When I invert the
comment, it doesn't.
I created file passtest using pg_passwd, with the following
ownerships/permissions. I've recreated it several times, to make sure
I didn't make a typo when I entered the password.
-rw-rw-r-- 1 postgres postgres 43 Mar 16 12:38 passtest
1006$ psql -d rpeterso -U rpeterso -W
Password:
Welcome to psql, the PostgreSQL interactive terminal.
...
(switch to 'local all crypt passtest')
rpeterso(at)pagoda ~
1007$ psql -d rpeterso -U rpeterso -W
Password:
psql: Password authentication failed for user 'rpeterso'
Am I missing something?
-Ron-
GPG and other info at: http://www.yellowbank.com/
From | Date | Subject | |
---|---|---|---|
Next Message | Christian Marschalek | 2001-03-16 17:54:45 | RE: ssl connections with psql |
Previous Message | newsreader | 2001-03-16 17:45:24 | Re: ssl connections with psql |