Re: Password authentication failing - Mailing list pgadmin-support

From Guillaume Lelarge
Subject Re: Password authentication failing
Date
Msg-id 1325177276.2320.7.camel@localhost.localdomain
Whole thread Raw
In response to Password authentication failing  (Bill Appelbe <bappelbe@gmail.com>)
Responses Re: Password authentication failing
List pgadmin-support
On Thu, 2011-12-29 at 16:31 +0000, Bill Appelbe wrote:
> 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
> 

The only reason I see is that you're not connecting to the same server.


-- 
Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3:
http://www.postgresql-sessions.org



pgadmin-support by date:

Previous
From: Bill Appelbe
Date:
Subject: Password authentication failing
Next
From: Bill Appelbe
Date:
Subject: Re: Password authentication failing