Unable to connect existing PGAdmin to existing PostgreSQL Db

From: "Craig Golby" <craig(dot)golby(at)dignitas(dot)ltd(dot)uk>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Unable to connect existing PGAdmin to existing PostgreSQL Db
Date: 2009-05-19 22:45:10
Message-ID: 000801c9d8d3$7806a410$d945b605@GOLBYDEV001.golby.me.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

I am a firm believer that for something to have broken that has been
consistently working for 18 months, something must have changed, but in this
instance I am at a loss !!!!

PG Admin Version 1.6.0 (Nov 15 2006, rev 5641) Running on Windows 2000
PostgreSQL 8.2.6, running remotely on Linux

pg_hba.conf contains the record ...
host all all 12.345.678.90 255.255.255.255 trust
where 12.345.678.90 is the IP address that I am trying to connect from

Database started with
/usr/local/pgsql/bin/pg_ctl -D /usr/local/pgsql/data -o -i start

None of these settings have changed.


Work undertaken in last 24 hours to create a cron job on the linux machine
that completes a pg_dump backup of PostgreSQL and zips it up. A Windows
scheduled job then hooks into the Linux machine and performs a get on that
file. This seems to be working OK and is as far as I can tell the only
thing that has changed. This process did involve a hardware reboot.

Tomcat 5.5 also running on same box, also connecting to database. This
connection is still working OK.
Same instance of PGAdmin connects to two other Db instances, one local and
one remote on a different server. Both work fine, but PGAdmin can no longer
connect to the main remote database.

Message appears in lower left corner "Connecting to database... Failed"
I have turned logging onto Debug and get the following records in the log
file for each connection attempt ...

2009-05-19 23:29:22 INFO : Attempting to create a connection object...
2009-05-19 23:29:23 INFO : Creating a connect dialogue
2009-05-19 23:29:24 INFO : Destroying a connect dialogue
2009-05-19 23:29:24 STATUS : Connecting to database...
2009-05-19 23:29:24 INFO : Creating pgConnBase object
2009-05-19 23:29:24 INFO : Server name: 10.987.654.32 (resolved to:
10.987.654.32)
2009-05-19 23:29:24 INFO : Opening connection with connection string:
host='10.987.654.32' hostaddr=10.987.654.32 dbname='postgres'
user='postgres' port=1234
2009-05-19 23:29:45 STATUS : Connecting to database... (21.03 secs)
2009-05-19 23:29:45 INFO : Destroying pgConnBase object

I can still connect to the Linux Box, I can logon to psql and have attempted
to change the password for my postgres user in case that was my problem. It
made no difference.


I do appreciate that the symptoms that I am describing suggests that PGAdmin
is fine and it is likely to be the Server and or the PostgreSQL instance
that is at fault. I am not new to either PostgreSQL or PGAdmin having been
a frequent user of both for 3-4 years, however I am at a loss as to what is
causing this so any clues would be much appreciated.

If I have missed something off that might help you diagnose, please let me
know.

In anticipation, many thanks !!!

Regards

Craig Golby


Browse pgadmin-support by date

  From Date Subject
Next Message ricardo mendez 2009-05-20 14:30:02 conexion..
Previous Message Eric 2009-05-19 08:13:39 Re: pgAdminIII 1.10.0 Beta 3 Copy/Paste Issue