Authentication by password

Поиск
Список
Период
Сортировка
От Peter Schuller
Тема Authentication by password
Дата
Msg-id 20010312180159.D6756@prometheus
обсуждение исходный текст
Ответы Re: Authentication by password  (Grant <grant@conprojan.com.au>)
Список pgsql-admin
Hello,

I'm sure this has been covered before, but the ML archive search engine is
down (?!).

After telling postgresql not to trust anyone, but always use password/crypt
as the authenticaton method (pg_hdb.conf), I can't seem to get the
postmaster to authenticate against the right password.

What I've done is:

1) Create user U with createuser
2) Log in as postgres to a database A
3) UPDATE pg_user SET passwd='mypassword' WHERE usename='U';

But after that 'mypassword' is not accepted when trying to log in as user U.

What am I doing wrong?

I was thinking the passwords might be encrypted in the db; but then the
"password" authentication mechanism would be impossible, so that can't be it.

Thank you,

--
/ Peter Schuller, InfiDyne Technologies HB

PGP userID: 0x5584BD98 or 'Peter Schuller <peter.schuller@infidyne.com>'
Key retrival: Send an E-Mail to getpgpkey@scode.infidyne.com
E-Mail: peter.schuller@infidyne.com Web: http://scode.infidyne.com


В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strange behavior with timestamps
Следующее
От: Grant
Дата:
Сообщение: Re: Authentication by password