I have installed PostgreSQL 9.0 (
postgresql) and PostGIS 1.5 (
postgis) from Debian Backports on my freshly installed Squeeze (stable).
However, when trying to create a PostGIS-enabled database, I noticed that I’m missing the “enabler script”
postgis.sql. According to the manual, it should be in
/usr/share/postgresql/9.0/contribdoesn’t exist until I install
postgresql-contrib-9.0 as well, but the file isn’t included there as well.
Now apparently the file might come with the
postgresql-x.x-postgis packages, however, there’s no such package for 9.0 yet (or I’m too stupid to find it).
So, Debian and PostGIS gods, what shall I do? Just get the .sql file from the PostGIS source? Install the
postgresql-8.4-postgis package (which pulls PostgreSQL 8.4)? Something completely different?
(I need 8.3 or 9.0 because the OpenStreetMap installation guide I’m using says that 8.4 performs poorly with OSM, and I figured that instead of using 8.3 I might as well use the newer version. So, “you absolutely want to use 8.3 instead of 9.0” is a valid suggestion as well.)