Re: Re: create user, user exists
От | Peter Eisentraut |
---|---|
Тема | Re: Re: create user, user exists |
Дата | |
Msg-id | Pine.LNX.4.30.0103162058500.1293-100000@peter.localdomain обсуждение исходный текст |
Ответ на | Re: create user, user exists (Ron Peterson <ron.peterson@yellowbank.com>) |
Список | pgsql-general |
Ron Peterson writes: > > 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? http://www.postgresql.org/devel-corner/docs/postgres/auth-methods.html#AEN13196 > > -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/ > > -- Peter Eisentraut peter_e@gmx.net http://yi.org/peter-e/
В списке pgsql-general по дате отправления: