Re: Password authentication failing

Change the 2 md5 to trust and all will work

From: Bill Appelbe <bappelbe@gmail.com>
To: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgadmin-support@postgresql.org
Sent: Thursday, December 29, 2011 2:23 PM
Subject: Re: [pgadmin-support] Password authentication failing

On Thu, Dec 29, 2011 at 5:04 PM, Guillaume Lelarge <guillaume@lelarge.info> wrote:

On Thu, 2011-12-29 at 17:00 +0000, Bill Appelbe wrote:
>
>
> On Thu, Dec 29, 2011 at 4:47 PM, Guillaume Lelarge
> <guillaume@lelarge.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.

 

 I open pgAdmin and go to File - Add Server
I fill in the window that appears Name =test, Host =127.0.0.1 the next few are default
(port 5432, Maintaince DB and username both 'postgres') and enter password, click 'ok'
a window comes up warning me of storing password on the disk click 'ok'
Then I get the error above (it was copy and pasted)

my pg_hba.conf:
# Database administrative login by Unix domain socket
local   all             postgres                                ident
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               ident
# IPv4 local connections:
host    all         all         127.0.0.1/32          md5
# IPv6 local connections:
host    all         all         ::1/128               md5

thanks for your help

  Altering user postgres with password 'NNNNNNN';
  made no difference

Bill