[postgis-users] postgis on Debian 4.0

[Mark Cave-Ayland]

Adrian wrote:
> I'm trying to create a postgis database on a brand new install of Debian 
> 4.0r2 (which I understand is the stable, rock solid no problems 
> version), using the following steps:
> 
> aptitude install postgresql-8.1-postgis
> su - postgres
> createuser <username>
> createdb -E UTF8 -O <username> <dbname>
> createlang plpgsql <dbname>
> 
> Everything looks OK until I do
> 
> psql -d gis -f /usr/share/postgresql-8.1-postgis/lwpostgis.sql
> 
> and then I get lots of error messages that start with:
> 
> psql:/usr/share/postgresql-8.1-postgis/lwpostgis.sql:39: NOTICE:  type
> "histogram2d" is not yet defined
> DETAIL:  Creating a shell type definition.
> psql:/usr/share/postgresql-8.1-postgis/lwpostgis.sql:39: ERROR:  could
> not load library "/usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1":
> /usr/lib/postgresql/8.1/lib/liblwgeom.so.1.1: undefined symbol:
> vacuum_delay_point
> psql:/usr/share/postgresql-8.1-postgis/lwpostgis.sql:44: ERROR:  current
> transaction is aborted, commands ignored until end of transaction block
> 
> Any suggestions on how to fix it? I would have though many people have 
> been here before me, but I can't find them with Google. It looks to me 
> like the 8.1 version of the lwpostgis.sql script doesn't match the 
> shared library in the 8.1 release.

Eh? This looks like a broken package/installation - vacuum_delay_point 
was added in PostgreSQL 8.0 and so something else is wrong here. Are you 
sure you don't have multiple versions of PostGIS / lwpostgis.sql installed?

BTW PostgreSQL 8.1 and PostGIS 1.1 are both extremely old - you should 
really consider building the latest PostGIS 1.3.x release to avoid 
several nasty PostGIS bugs, and preferably a newer version of PostgreSQL 
at the same time.


ATB,

Mark.

-- 
Mark Cave-Ayland
Sirius Corporation - The Open Source Experts
http://www.siriusit.co.uk
T: +44 870 608 0063