Re: [postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"
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
Re: [postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"
On Tue, Aug 09, 2011 at 10:04:41AM +0200, ml ml wrote: > I am using postgres 8.2.20, postgis 1.4.2 and geos.3.3.0 from source. ... > 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" Did you run "make install" ? Check ctime on /usr/local/postgresql-8.2.20/lib/postgis-1.4.so Or run: nm /usr/local/postgresql-8.2.20/lib/postgis-1.4.so | grep -i validreason --strk; () Free GIS & Flash consultant/developer /\ http://strk.keybit.net/services.html ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
[postgis-users] ERROR: could not find function "isvalidreason" in file "/usr/local/postgresql-8.2.20/lib/postgis-1.4.so"
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 ___ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
