Red Hat Bugzilla – Bug 242826
pgadmin3 1.6.3 does not connect to postgres 8.2.4 database
Last modified: 2008-01-19 20:49:47 EST
Description of problem:
I start pgadmin and 'add server', put in the connection details and click on OK.
The dialog box immediately disappears.
When I start pgadmin again, it has the database icon with a big red X. The
properties indicate that pgadmin is not connected to the database. (see attached
When I look in the postgres log file, the newest line sa:d:
LOG: unexpected EOF on client connection
Version-Release number of selected component (if applicable):
pgadmin3 - 1.6.3-1.fc7.i386
postgresql - 8.2.4-1.fc7.i386
pgadmin was working a month ago (with postgresql 8.1.9)
Steps to Reproduce:
1. see above
pgadmin should connect to my database
There may be format changes in the 8.2.4 version of postgresql that pgadmin3
hasn't caught up with as yet.
There was a complaint when I tried to start postgresql when I finally was able
to boot into Fedora7. Something about a database format change between the
version of postgresql installed in Fedora6 and that loaded in Fedora7.
This is another bug as the Fedora7 upgrade process overwrites the old version of
postgresql and then issues an error message saying that it cannot open the old
format database - please pg_dumpall and reload with the new system.
Unfortunately, for pg_dumpall to work, postgresql must be running on the database.
I had to move the data, uninstall postgres 8.2.4, install postgresql 8.1.9,
pg_dumpall, uninstall 8.1.9, reinstall 8.2.4 and then import the dumpall file.
Created attachment 156295 [details]
GUI of pgadmin - see not connected
This works for me with pgadmin3-1.8.0 built from upstream SRPM:
I am connecting to postgresql-8.2.5-1.fc7 on another Fedora 7.
By the way, I'm not saying it's your fault, but it's not a bad
idea to pg_dumpall nightly with logrotate unless your databases
Agreed, and this bug is invalid -- at least it is not a bug.
That makes it probably a pgadmin issue not a postgres server issue. Reassigning ...
Submitted 1.8.0 to Fedora 7. It will appear in a few days.
Bob, could you please install it when it is available in the repos and test it?
pgadmin3 1.8.0 beta 5 works for me.
I need to run it from the command line. The Fedora menu pgadmin3 points to the
pgadmin3-1.8.0-1.fc7 has been pushed to the Fedora 7 stable repository. If problems still persist, please make note of it in this bug report.