[postgis-users] Probelm with postgis-pg81-setup-1.1.6-1 in XP

Tomas Lanczos lanczos at t-zones.sk
Mon Nov 13 10:12:41 PST 2006


I am using Postgtresql 8.1.1 installed under WinXP. When I installed it, I
installed also the Postgis (I don't know which version) from the
installation package, just for sure, never really used :-).
 Later I decided to upgrade it to version 1.1.6, using the
"postgis-pg81-setup-1.1.6-1" installation package downloaded from
http://postgis.refractions.net/download/windows/ , as I am planning to use
it with grass 6.3 and qgis (compiled from source under Ubuntu 6.0.6 in
VMWare, approaching Postgresql/postgis as on remote machine - however,
planning to switch to Linux completely as I need and use more OSS and Linux
stuff as Win stuff ad the moment :-)). 

So, I recognized the following strange behaviour of the installer during the
installation procedure:
- arrived to the "Loading of Postgis functions ..." then stopped and an
errormessage appeared that the template_postgis database creation did not
succeed. The create_tempaltepostgis_sql_error.txt error log was clear that
the problem was in running the lwpostgis.sql and the spatial_ref_sys.sql

- I tried to run the lwpostgis.sql  manually, I succeed after manual removal
of all the tables and types as well as the cast from type bool to type text.

- the spatial_ref_sys.sql ran without problems now.

It appears to me that it looks like as the template_postgis database was
created twice during the installation procedure and it was no need to run
those queries manually, am I right? My next question is that whether is the
installation finished now and will the stuff work fine?

Best regards


More information about the postgis-users mailing list