PostGIS on Debian Squeeze

Why?

Because it wasn't just a matter of "aptitude install..."

What?

aptitude install postgis postgresql-8.4-postgis

createlang plpgsql {yourdb}
psql -f /usr/share/postgresql/8.4/contrib/postgis-1.5/postgis.sql {yourdb}
psql -f /usr/share/postgresql/8.4/contrib/postgis-1.5/spatial_ref_sys.sql {yourdb}

Caveats?

If you are accessing the DB, you'd better have enough rights to do this. However, if your app user has different rights, you probably need to change ownership of the two new tables:

ALTER TABLE spatial_ref_sys OWNER TO "{dbuser}";
ALTER TABLE geometry_columns OWNER TO "{dbuser}";
comments powered by Disqus