From: | Bill Appelbe <bappelbe(at)gmail(dot)com> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Password authentication failing |
Date: | 2011-12-29 16:31:59 |
Message-ID: | CAGyw+pbgrKHF_8jEk_=ejW13pX-msbfoK0uBkvNFBjAoPZV9TQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Hi
I installed Pgadmin3 version 1.12.3 on Linux Mint 12 which also has
PostgreSQL 8.4 installed.
It all worked fine and I was able to look at the database.
Then I went away for a few days, came back and now have a problem
connecting to PostgreSQL
the error is:
Error connecting to the server: FATAL: password authentication failed for
user "postgres"
FATAL: password authentication failed for user "postgres"
Seems simple enough! but I retype the password and no joy.
I have another application that uses PostgreSQL (LedgerSMB) and it works
fine.
After some research I changed the password using :
ALTER USER postgres PASSWORD 'newPassword';
in psql
this also does not work
I also edited pg_hba.comf and replaced the word 'ident' with 'trust' in the
first line.
I restarted the postgres server and still no joy.
There has to be something simple that I am missing but I can't see it!
any help would be appreciated
thanks
Bill
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-12-29 16:47:56 | Re: Password authentication failing |
Previous Message | David E. Wheeler | 2011-12-28 22:08:04 | Re: pgAgent STDERR and Time Zone Questions |