On Thu, 2011-12-29 at 17:00 +0000, Bill Appelbe wrote: > > > On Thu, Dec 29, 2011 at 4:47 PM, Guillaume Lelarge > <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 >
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. -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com PostgreSQL Sessions #3: http://www.postgresql-sessions.org -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
