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 [prefix]/share/contrib
, but /usr/share/postgresql/9.0/contrib
doesn’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.)