On Thu, 2005-02-10 at 16:03 +0100, Roger Grosswiler wrote:
tried to connect to a postgres-database, and got the following:
[roger@frodo]$ psql -U roger -h localhost Passwort: psql: FATAL: ÂPasswordÂ-authentication for user roger not successful.
Try commenting out all the user restrictions in pg_hba.conf temporarily and replace them all with just:
local all all trust sameuser
Then restart the database service, log in as that user (who will not be asked for a password), and use ALTER USER within psql to set a new password. Then change your pg_hba.conf back, restart the service again, and IN THEORY you should be OK.
I just started with PostgreSQL last week, but I already broke my password once and this is how I fixed it. So it WORKEDFORME, but YMMV. :-)
Cheers,
Rodolfo,
:-) Helpful as usual, this did the trick also for me. I find it a little bit uncomprehensive, as if you have a proper install on postgres, i logged in as postgres and did createuser -W and created a user. Seems, that this password isn't written in template1 or whatever, because baseconfig in pg_hba.conf is 'local/all/all/ident/sameuser' which does not request a password.
So, this means, also if you create a new user with this config, the password is for nuts?
In this case, best would be, doing the above mentionned process right after the installation...
Thanks a lot Rodolfo Roger
