Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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/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.)

share|improve this question
up vote 2 down vote accepted

According to the currently broken blog here (Googlecache). There is a repository of postgres9/postgis1.5.2/etc binaries for 64-bit architectures at

deb squeeze main contrib non-free

Otherwise, you'll probably need to compile and install postgis from source against 9.0 yourself, which will need the headers from the postgresql-server-dev-9.0 package.

share|improve this answer
Since I don’t want to use unofficial repositories, I’ve installed PostGIS from source. Seems to work. Thank you very much. – scy Aug 31 '11 at 10:03

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.