From: | Bill Appelbe <bappelbe(at)gmail(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Password authentication failing |
Date: | 2011-12-29 17:23:09 |
Message-ID: | CAGyw+pbLhyM1q8_EntheSx4Nxap3vH+3Tf0TZT2EEiMJ0zG50w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
On Thu, Dec 29, 2011 at 5:04 PM, Guillaume Lelarge
<guillaume(at)lelarge(dot)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(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.
>
>
>
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Appelbe | 2011-12-29 17:47:54 | Re: Password authentication failing |
Previous Message | Elizondo Julio César | 2011-12-29 17:16:28 | Re: Password authentication failing |