On Wed, 2012-05-16 at 19:22 +0200, Pierre Chevalier wrote: > Le 16/05/2012 15:29, Guillaume Lelarge claviota: > >> And then, a second message comes: > >> "Une erreur s'est produite : > >> " > >> "ERREUR: la colonne « datconfig » n'existe pas > >> "LIGNE 1 : ...b.dattablespace AS spcoid, spcname, datallowconn, > >> "datconfig,... > >> " ^ > > > > datconfig is a column of a system catalog called pg_database. It > > disappears in 9.0. Actually, it's replaced by another catalog called > > pg_db_role_setting. Anyway, it means you can't use pgAdmin 1.10 with > > PostgreSQL 9.0, and more recent releases of PostgreSQL. > > > > You need a least pgAdmin 1.12 to connect to PostgreSQL 9.0. > > All right. > > > >> I thought that a more up-to-date version would come in the debian > >> sources, so I waited for a while, doing a few apt-get updates. But > >> apparently, nothing is changing. > > > > If you use debian stable, it won't ever happen. You can try backports. > > It should work with your Debian stable. > > Yes, I have backports repositories enabled. But for some reason, there > is no way to get the most recent version of pgadmin3. > I will try to force things a bit harder in my apt-get. > > > >> I know that I could get sources and compile pgadmin myself, but this is > >> for my working machine, which is quite crucial, and I try to avoid, as > >> much as possible, any weird installations, and I keep it as > >> debian-stable as possible. > >> > >> Any idea? > > > > If you cannot get it through backports, you have to compile it. If you > > want to keep things nice, the best way would be to create your own .deb > > files. > > > >> Maybe I could try to add a "datconfig" field to... some > >> table, but which one? > > > > You cannot add columns to system tables. > > Yes, this makes sense! Pretty bad idea I had... :s > > > >> Or I could also add another repositery to my /etc/apt/sources.list ? I > >> tried to find one, unsuccessfully, so far. > > > > See > > http://packages.debian.org/squeeze-backports/pgadmin3 > > Ok, I'll check the repositories from there. > > > > You have the latest stable release of pgAdmin (but you miss three minor > > releases, which kinda sucks but you'll be able to connect to your 9.0 > > cluster). > > I'm so far behind at the moment, that it will be a pleasure to get a > newer pgadmin, anyways! > > Thanks / Merci! >
You're welcome / De rien :) -- Guillaume http://blog.guillaume.lelarge.info http://www.dalibo.com -- Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgadmin-support
