Re: create user, user exists

If I do

alter user rpeterso with password 'thepassword';

Things start working.  So it's as if the [AUTH_ARGUMENT] is being ignored.
Has this been depricated?

-Ron-

On Fri, 16 Mar 2001, Ron Peterson wrote:

>
> 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@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/