On 09/08/11 09:04, ml ml wrote:
Hello,
i am trying to restore a postgres dump on a freshly installed Debian
Squeeze Box.
I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source.
Postgresql 8.2.20: ./configure --prefix=/usr/local/postgresql-8.2.20
--with-perl --with-openssl --with-libxslt --with-libxml
Geos: ./configure --prefix=/usr/local/geos-3.3.0
Postgis: ./configure
--with-pgconfig=/usr/local/postgresql-8.2/bin/pg_config
--with-geosconfig=/usr/local/geos-3.3/bin/geos-config
Restore:
----------
/usr/local/postgresql-8.2/bin/pg_restore -U pgsql -d test
--exit-on-error --no-owner /root/test_dev-Sat-18.bin pg_restore:
[archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 43383; 1255 3510237
FUNCTION st_isvalidreason(geometry) pgsql
pg_restore: [archiver (db)] could not execute query: ERROR: could not
find function "isvalidreason" in file
"/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"
Command was: CREATE FUNCTION st_isvalidreason(geometry) RETURNS text
AS '$libdir/postgis-1.4', 'isvalidreason'
LANGUAGE c IMMUTAB...
I read that st_isvalidreason needs goes>= 3.1 which i actually use.
I used to use geos 3.0 from the debian squeeze repo, which i replaced
(see source config above)
Kind Regards,
Mario
Hi Mario,
That all looks as if it should work. What does the following command show?
ldd /usr/local/postgresql-8.2.20/lib/postgis-1.4.so
That will show you which version of GEOS your custom-built PostGIS is
built against.
HTH,
Mark.
--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
Sirius Labs: http://www.siriusit.co.uk/labs
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
