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