Re: Password authentication failing

On Thu, 2011-12-29 at 17:00 +0000, Bill Appelbe wrote:
>
>
> On Thu, Dec 29, 2011 at 4:47 PM, Guillaume Lelarge
> <guillaume(at)lelarge(dot)info> wrote:
> 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
>
>
> It is all to 127.0.0.1 there is no other PostgreSQL installation on
> the network
>

OK. Then, tell us exactly how you try to connect to your PostgreSQL
database, the exact error message you get, and give us the whole
pg_hba.conf file.

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