create user, user exists

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/

Responses

Browse pgsql-general by date

  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