Re: pgadmin, debian stable & postgresql 9.0

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,...
" ^

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.

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? Maybe I could try to add a "datconfig" field to... some
table, but which one?
Or I could also add another repositery to my /etc/apt/sources.list ? I
tried to find one, unsuccessfully, so far.

Thanks in advance!

Regards,
Pierre

PS: in the meantime, I only work with psql, which is very efficient.
But sometimes, I miss the neat features of pgadmin, like browsing
through dozens of views, reviewing table structures in a glance, etc.

--
Pierre Chevalier Mesté Duran 32100 Condom
Tél : 09 75 27 45 62 - 06 37 80 33 64
http://pierremariechevalier.free.fr/
Logiciels Libres dans le Gers: http://gnusquetaires.org/

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

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!

À+
Pierre
--
Pierre Chevalier Mesté Duran 32100 Condom
Tél : 09 75 27 45 62 - 06 37 80 33 64
http://pierremariechevalier.free.fr/
Logiciels Libres dans le Gers: http://gnusquetaires.org/

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

Le 16/05/2012 19:22, Pierre Chevalier claviota:
>...
>> 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.

Youpi!
It worked! I just had to be more convincing when I spoke to my synaptic.

Actually, I had first to force pgadmin3-data to version 1.14.0-1~bpo60+1
from the backport, and AFTER I forced also pgadmin3 to version
1.14.0-1~bpo60+1.

What I was doing (wrong) was to force pgadmin3 to backport version: for
some reason, it was solving dependencies by taking version 1.10.5-1 of
pgadmin3-data from stable, and then pgadmin3 was also set to version
1.10.5-1...

Now, back to work, and I'll leave my psql console (just a little bit,
though) for pgadmin!

Thanks - merci!

À+
Pierre
--
Pierre Chevalier Mesté Duran 32100 Condom
Tél : 09 75 27 45 62 - 06 37 80 33 64
http://pierremariechevalier.free.fr/
Logiciels Libres dans le Gers: http://gnusquetaires.org/