Thread: 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/