no connection to postgres
Roger Grosswiler
roger at gwch.net
Fri Feb 11 07:45:57 UTC 2005
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
More information about the fedora-list
mailing list