Authentication by password - Mailing list pgsql-admin

From Peter Schuller
Subject Authentication by password
Date
Msg-id 20010312180159.D6756@prometheus
Whole thread Raw
Responses Re: Authentication by password
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Strange behavior with timestamps
Next
From: Grant
Date:
Subject: Re: Authentication by password