[postgis-users] installing postgis on debian testing (sarge)

[alexbodn at 012.net.il]

hi kevin,

/usr/local/lib is not in the library search path for sarge. this might be some 
policy, so i decided not to change it.

what i did, is:
1. in geos, ./configure --prefix=/usr, and
2. in postgis makefile, set GEOS_DIR=/usr

the debian packages by fred macdavid are very important, and i am eager to 
inquire them.

the cach is, that postgis depends on the source of postgresql, so it should 
conflict with any other postgresql version.

also, i am happy to have found that use of geos does not require the 
LDFLAGS+=libstdc++ in postgresql on sarge, so that the official postgresql 
package may be used.

the building process for postgis should apt-get source postgresql, make it's 
binaries, remove postgresql binaries, build postgis binary.

this is interesting work for one that never packaged a deb like me. but i am 
willing to help, in my love for debian and geography.

postgis upgrading might be problematic, since the spatial columns might change. 
as each database is made with the current version of postgis.sql, which 
explicitly refers to the libpostgis.so.ver.subver, postgis upgrade should 
overwrite postgis.sql, and libpostgis.so link, but not the actual libpostgis.so.
ver.subver.

my sugestion to libpostgis authors is to have postgis.sql point to libpostgis.
so.ver link, and increase ver whenever backward support is broken. this way, 
databases should remain compatible with postgis new subversions, and old 
subversions of the current version might be
physically removed.

what about the following pervert idea: creating a database should create and 
install a debian package, with dependancy on postgresql and postgis versions, 
as set by their respective developers. postgresql upgrade might recommend or 
even depend on certain database version satisfaction.

best regards,

alex

-------------- next part --------------
An embedded message was scrubbed...
From: alex bodnaru <alexbodn at 012.net.il>
Subject: [postgis-users] installing postgis on debian testing (sarge)
Date: Mon, 01 Nov 2004 02:29:26 +0200
Size: 2845
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20041101/d0ff7604/attachment.mht>