Package: postgresql-common Version: 23 Hi Matt,
I had postgis installed under postgresql 7.4 Then I upgraded this postgres 7.4 to ppostgres 7.5 Upgrading was straightforward, except the files from postgis were not upgraded to the new directory structure. This includes: /usr/lib/postgresql/bin/ pgsql2shp shp2pgsql /usr/lib/postgresql/lib/ libpostgis.so libpostgis.so.0 libpostgis.so.0.9 Now as a default, I suggest a warning that the directories contained other files. (BTW postgis is a library/language that spatially enables postgresql) It is impossible to connect to the (spatial)database cluster afterwards, since postgres7.4 cannot find the library anymore... It will fail with pretty cryptic error messages as: "could not open 1262" etc. Moving the files to the new directory structure repaired the whole scheme. I understand that these files are not part of a standard debian package (in the stable distribution, they are in unstable), however I suspect that many people will have extensions set up in the same way, and it would be a simple test and a simple warning to detect this. Regards. Floris Sluiter
