Password authentication failing - Mailing list pgadmin-support

From Bill Appelbe
Subject Password authentication failing
Date
Msg-id CAGyw+pbgrKHF_8jEk_=ejW13pX-msbfoK0uBkvNFBjAoPZV9TQ@mail.gmail.com
Whole thread Raw
Responses Re: Password authentication failing
List pgadmin-support
Hi<br />I installed Pgadmin3 version 1.12.3 on Linux Mint 12 which also has PostgreSQL 8.4 installed.<br /><br />It all
workedfine and I was able to look at the database.<br />Then I went away for a few days, came back and now have a
problemconnecting to PostgreSQL<br /> the error is:<br />Error connecting to the server: FATAL:  password
authenticationfailed for user "postgres"<br />FATAL:  password authentication failed for user "postgres"<br /><br
/>Seemssimple enough! but I retype the password and no joy.<br /> I have another application that uses PostgreSQL
(LedgerSMB)and it works fine.<br /><br />After some research I changed the password using :<br />ALTER USER postgres
PASSWORD'newPassword';<br />in psql<br />this also does not work<br /><br />I also edited pg_hba.comf and replaced the
word'ident' with 'trust' in the first line.<br />I restarted the postgres server and still no joy.<br /><br />There has
tobe something simple that I am missing but I can't see it!<br /> any help would be appreciated<br /><br />thanks<br
/><br/>Bill<br /> 

pgadmin-support by date:

Previous
From: "David E. Wheeler"
Date:
Subject: Re: pgAgent STDERR and Time Zone Questions
Next
From: Guillaume Lelarge
Date:
Subject: Re: Password authentication failing