Christoph’s Blog

Rants, discoveries and subtleties that my children should never learn about

pgadmin3 - now it’s getting personal

with 5 comments

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.

Written by Christoph Haas

February 18th, 2008 at 4:39 pm

Posted in Debian, Work

5 Responses to 'pgadmin3 - now it’s getting personal'

Subscribe to comments with RSS or TrackBack to 'pgadmin3 - now it’s getting personal'.

  1. 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…

    michael schurter

    18 Feb 08 at 5:20 pm

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

    Albin Blaschka

    18 Feb 08 at 5:28 pm

  3. 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

    emiliano

    18 Feb 08 at 5:39 pm

  4. 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. :(

    Chris

    18 Feb 08 at 8:36 pm

  5. 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

    Peter

    19 Feb 08 at 12:27 am

Leave a Reply