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

[Mark Cave-Ayland]

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