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 J. Paiz <rpaiz@xxxxxxxxxxxxxx>
