TRY alter user postgres with password “NNNNNNNN “;
Julio Elizondo
De: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] En nombre de Bill Appelbe Enviado el: jueves, 29 de diciembre de 2011 02:01 p.m. Para: Guillaume Lelarge CC: pgadmin-support@postgresql.org Asunto: Re: [pgadmin-support] Password authentication failing
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.
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.