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 />
