pgadmin3 - now it’s getting personal

I really don’t mind if Debian lags behind with package versions. And I’ve gotten used to running an ancient version of “pgadmin3″ (the GUI client for PostgreSQL). But now that I upgraded a few pgsql servers from 8.2 to 8.3 and started pgadmin3 I was surprised - in a not at all fun way. Several warnings were displayed. Googling a little I found the cause:

“pgAdmin 1.6.x doesn’t support PostgreSQL 8.3.x. Upgrade to 1.8″

How funny. pgadmin3 in Debian depends on wxwidgets and apparently the current version of wxwidgets didn’t make it into Sid for stability reasons or whatever. So now I’m running into trouble with PostgreSQL 8.3. Somehow I can’t laugh about that. Alright… downgrading to 8.2 again. Is that even possible? Okay, pg_dropcluster and get my backup tapes out.

5 Responses to “pgadmin3 - now it’s getting personal”

  1. michael schurter Says:

    Don’t tell anyone this, but I’ve found running pgAdmin 1.8 for Windows under Wine works great in Debian. ;)

    Easier than trying to get wxwidgets maintainer to upgrade…

  2. Albin Blaschka Says:

    Maybe the .deb file from ubuntu hardy heron (it is 1.8) is working? I don’t know…but maybe another possibility…

  3. emiliano Says:

    i had the same problem… I solved it using hardy heron versione of pgadmin3 with wxwidgets from the repository
    deb http://www.vollstreckernet.de/debian/ testing wx

    regards
    emiliano

  4. Chris Says:

    I now use the wx 2.8 packages from vollstrecker’s repository together with the Ubuntu packages pgadmin3 and pgadmin3-data. That works perfectly. But it’s sick. And yet another time that Ubuntu packages stuff where Debian developers hesitate. It’s often justified to be careful but Debian can hardly stay on wx 2.6 forever. :(

  5. Peter Says:

    I got the latest wxwidgets release from their official apt repository; more info here http://wiki.wxpython.org/InstallingOnUbuntuOrDebian

    Everything was straightforward once I’d upgraded from there

Leave a Reply