Re: pgadmin, debian stable & postgresql 9.0

On Wed, 2012-05-16 at 14:30 +0200, Pierre Chevalier wrote:
> Hello/bonjour,
>
> I have a little problem: in my company, my main work machine runs on
> GNU/Linux debian stable.  I used to work a lot with pgadmin, while my
> postgresql was a 8.3 and 8.4.
> I upgraded my cluster to 9.0, and since, pgadmin does not work any more.
> My postgresql database is hosted on the same machine.  Pgadmin version
> is 1.10.5.
>
> Pgadmin launches normally; but when I try to connect to my postgresql
> database connexion, it complains (in French):
>
> "Warning :
> "Cette version de pgAdmin a seulement été testée avec la version 8.4 de
> "PostgreSQL ainsi qu'avec les versions antérieures. Elle pourrait ne
> "pas fonctionner avec ce serveur. Merci de mettre à jour pgAdmin.
> "
>
> 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.

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

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

> 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

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


--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com