Password authentication failing
От | Bill Appelbe |
---|---|
Тема | Password authentication failing |
Дата | |
Msg-id | CAGyw+pbgrKHF_8jEk_=ejW13pX-msbfoK0uBkvNFBjAoPZV9TQ@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Password authentication failing
|
Список | 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 по дате отправления: