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 image) 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 How reproducible: pgadmin was working a month ago (with postgresql 8.1.9) Steps to Reproduce: 1. see above 2. 3. Actual results: pgadmin disappears Expected results: pgadmin should connect to my database Additional info: 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: http://ftp7.us.postgresql.org/pub/postgresql//pgadmin3/release/v1.8.0/fedora-7/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 are huge.
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 old version.
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.