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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
