TRY alter user postgres with password "NNNNNNNN "; Julio Elizondo
De: pgadmin-support-ow...@postgresql.org [mailto:pgadmin-support-ow...@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, Dec 29, 2011 at 4:47 PM, Guillaume Lelarge <guilla...@lelarge.info<mailto:guilla...@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 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.
