create user, user exists
От | Ron Peterson |
---|---|
Тема | create user, user exists |
Дата | |
Msg-id | Pine.LNX.4.30.0103161221270.27683-100000@h00a024ee7419.ne.mediaone.net обсуждение исходный текст |
Ответы |
Re: create user, user exists
Re: create user, user exists |
Список | 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@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/
В списке pgsql-general по дате отправления: