[postgis-users] Problems with Debian and Postgis

[alex bodnaru]

hello nabil,

sorry for your language too. fortunately your english is good ;-) .

it seems you have messed your debian installation a little. current
debian testing and later do support concurrent postgresql 7.4 and 8.1,
but you should install both the debian way.

if you have installed postgresql 7.4.1 from it's sources and you regret
it, you should make uninstall it. then, your debian machine should be
clean, just missing a few files you have overwritten and now deleted.

you can also remove the postgresql*-dev packages through aptitude, since
 i'll point you to a source of binary postgis packages.

now, as root, add the following lines to your /etc/apt/sources.list:
deb http://pkg-grass.alioth.debian.org/debian-gis unstable main contrib
deb-src http://pkg-grass.alioth.debian.org/debian-gis unstable main contrib

then,
apt-get update
apt-get install --reinstall postgresql-7.4 postgresql-8.1.
apt-get install postgresql-7.4-postgis1 postgresql-8.1-postgis1.

one last flaw to manually fix: please edit /etc/defaults/postgis and
change #SONAME# to 1.

good luck,

alex

Nabil Servais wrote:
> Hello,
> First sorry for my language, I'm French user.
> I've installed postgresql 8.1.4 with Postgis on a Debian, there's no
> problem with the compilation.
> But I did an upgrade with apt-get and then, it installed the version
> 7.4.1 of postgre which makes a  conflict between the two versions. I can
> use the program of the version in the folder of install.
> It's also impossible to uninstall the version 7 with apt-get because he
> prevents me of he 's not considered postgresql 7 is installed.
> 
> Also I've got a little problem  with postgis, I can't use lwpostgis.sql
> and spatial_ref_sys.sql, it warm of error such as :
> 
> psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:3252: ERREUR:  La
> transaction courante est annulée, les commandes sont ignorées jusqu'à la
> fon du bloc de la transaction
> psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:3261: ERREUR:  La
> transaction courante est annulée, les commandes sont ignorées jusqu'à la
> fon du bloc de la transaction
> psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:3271: ERREUR:  La
> transaction courante est annulée, les commandes sont ignorées jusqu'à la
> fon du bloc de la transaction
> psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:3281: ERREUR:  La
> transaction courante est annulée, les commandes sont ignorées jusqu'à la
> fon du bloc de la transaction
> psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:3323: ERREUR:  La
> transaction courante est annulée, les commandes sont ignorées jusqu'à la
> fon du bloc de la transaction
> psql:/usr/local/pgsql/share/contrib/lwpostgis.sql:3358: ERREUR:  La
> transaction courante est annulée, les commandes sont ignorées jusqu'à la
> fon du bloc de la transaction
> 
> 
> Thanks
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>