Bug 242826

Summary: pgadmin3 1.6.3 does not connect to postgres 8.2.4 database
Product: [Fedora] Fedora Reporter: Bob Gustafson <bobgus>
Component: pgadmin3Assignee: Gavin Henry <ghenry>
Status: CLOSED CURRENTRELEASE QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: low Docs Contact:
Priority: low    
Version: 7CC: devrim, tgl
Target Milestone: ---   
Target Release: ---   
Hardware: All   
OS: Linux   
Whiteboard:
Fixed In Version: 1.8.0 Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2008-01-20 01:49:47 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
GUI of pgadmin - see not connected none

Description Bob Gustafson 2007-06-06 00:21:05 UTC
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.

Comment 1 Bob Gustafson 2007-06-06 00:21:06 UTC
Created attachment 156295 [details]
GUI of pgadmin - see not connected

Comment 2 Joshua Daniel Franklin 2007-11-14 18:09:10 UTC
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. 

Comment 3 Devrim GUNDUZ 2007-11-14 18:50:36 UTC
Agreed, and this bug is invalid -- at least it is not a bug.

Comment 4 Tom Lane 2007-11-14 18:51:35 UTC
That makes it probably a pgadmin issue not a postgres server issue.  Reassigning ...

Comment 5 Devrim GUNDUZ 2007-11-15 03:55:45 UTC
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?



Comment 6 Bob Gustafson 2007-11-15 06:29:36 UTC
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.


Comment 7 Fedora Update System 2007-11-16 00:40:15 UTC
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.