From: | Elizondo Julio César <jelizondo(at)ecogas(dot)com(dot)ar> |
---|---|
To: | 'Bill Appelbe' <bappelbe(at)gmail(dot)com>, Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | "pgadmin-support(at)postgresql(dot)org" <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Password authentication failing |
Date: | 2011-12-29 17:16:28 |
Message-ID: | 116E9EAFE8CBF44DB588591DAE28CB4C9D82E6516E@AMGS-MAILBOX.cuyo.ecogas.com.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
TRY alter user postgres with password "NNNNNNNN ";
Julio Elizondo
De: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] En nombre de Bill Appelbe
Enviado el: jueves, 29 de diciembre de 2011 02:01 p.m.
Para: Guillaume Lelarge
CC: pgadmin-support(at)postgresql(dot)org
Asunto: Re: [pgadmin-support] Password authentication failing
On Thu, Dec 29, 2011 at 4:47 PM, Guillaume Lelarge <guillaume(at)lelarge(dot)info<mailto: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
Bill
________________________________
Este correo electrónico puede contener información confidencial y protegida legalmente bajo secreto profesional y/o financiero. La información esta dirigida solamente a la persona o entidad indicada como destinatario y su acceso por cualquier otra persona no esta autorizado.
Si ud. ha recibido este mensaje electrónico por error, por favor infórmeselo al remitente y bórrelo. Los conceptos y opiniones contenidos en este mail corresponden al autor del mensaje y no necesariamente coinciden con las de Distribuidora de Gas Cuyana S.A.
Muchas Gracias.
Distribuidora de Gas Cuyana S.A.
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Appelbe | 2011-12-29 17:23:09 | Re: Password authentication failing |
Previous Message | Guillaume Lelarge | 2011-12-29 17:04:14 | Re: Password authentication failing |