no connection to postgres

[Roger Grosswiler]

Rodolfo J. Paiz schrieb:
> On Thu, 2005-02-10 at 16:03 +0100, Roger Grosswiler wrote:
> 
>>tried to connect to a postgres-database, and got the following:
>>
>>[roger at 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