[postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"

[ml ml]

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