[postgis-users] Installation problem

[strk]

Unfortunately replacing libpostgis is not enough to make an upgrade.
You need to source postgis.sql again (dropping the old one).
Again, postgis_undef.sql won't work ( I hate this ), so you'll
quicker create a new database ...

Buona fortuna !
--strk;

On Thu, May 13, 2004 at 03:17:25PM +0200, Gino Lucrezi wrote:
> I have a working installation of PostGIS 0.8.1 over PostgreSQL 7.3.2, on a RedHat 8.0 box.
> 
> I didn't install Proj4 support initially.
> A few days ago I installed the latest version of those libraries, and I know they work because MapServer uses them correctly.
> 
> I tried recompiling PostGIS, but it doesn't see them.
> 
> I changed USE_PROJ to 1 in the Makefile.
> I didn't change the value of PROJ_DIR because the default of /usr/local is OK for me.
> 
> I did these commands:
> make clean     (just to be sure)
> make
> make install
> 
> I then dropped all the databases, and re-imported them.
> 
> However, when I try to use any PostGis function depending on Proj4 I get an error similar to this:
> 
> geodb=# select transform( PointFromText( 'POINT (2456623.30386548 4700781.4188125 721.11)', 26592 ), 23033 );
> WARNING:  Error occurred while executing PL/pgSQL function transform
> WARNING:  line 2 at return
> ERROR:  PostGIS transform() called, but support not compiled in.  Modify your 
> makefile to add proj support, remake and re-install
> 
> This is the same error I had before recompiling proj4 support in!
> Obviously, at that time it was correct, but after recompiling it shouldn't appear.
> 
> The Proj4 header file is in /usr/local/include/projects.h
> Under /usr/local/lib I have these files:
> -rw-r--r-- 1 root 2588684 11 mag 12:22 libproj.a
> -rwxr-xr-x 1 root     709 11 mag 12:22 libproj.la
> lrwxrwxrwx 1 root      16 11 mag 12:22 libproj.so -> libproj.so.0.4.2
> lrwxrwxrwx 1 root      16 11 mag 12:22 libproj.so.0 -> libproj.so.0.4.2
> -rwxr-xr-x 1 root 1394310 11 mag 12:22 libproj.so.0.4.2
> 
> I got no errors in making.
> I just had 4 warnings, which I have even if I compile *without* Proj4 support.
> Anyway here they are:
> 
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions -I. -DFRONTEND -DSYSCONFDIR='"/usr/local/pgsql/etc"'  -DUSE_VERSION=73 -
> I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -DUSE_PROJ  -
> DUSE_STATS -fpic -I../../src/include   -c -o postgis_debug.o
> postgis_debug.c
> 
> postgis_debug.c: In function `lockcheck':
> postgis_debug.c:310: warning: control reaches end of non-void function
> 
> 
> gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations -g -fexceptions -I. -DFRONTEND -DSYSCONFDIR='"/usr/local/pgsql/etc"'  -DUSE_VERSION=73 -
> I/usr/local/include/geos -DUSE_GEOS -I/usr/local/include -DUSE_PROJ  -DUSE_STATS -fpic -I../../src/include   -c -o postgis_geos.o postgis_geos.c
> 
> postgis_geos.c:268: warning: `resize_ptrArrayType' defined but not used
> 
> 
> gcc -g -I.. -I. -I../../../src/interfaces/libpq -O2 -Wall
> -Wmissing-prototypes -Wmissing-declarations -DFRONTEND -DSYSCONFDIR='"/usr/local/pgsql/etc"' -DUSE_VERSION=73 -I../../../src/include   -c -o shpopen.o shpopen.c
> 
> shpopen.c:176: warning: `rcsid' defined but not used
> 
> 
> gcc -g -I.. -I. -I../../../src/interfaces/libpq -O2 -Wall
> -Wmissing-prototypes -Wmissing-declarations -DFRONTEND -DSYSCONFDIR='"/usr/local/pgsql/etc"' -DUSE_VERSION=73 -I../../../src/include   -c -o dbfopen.o dbfopen.c
> 
> dbfopen.c:200: warning: `rcsid' defined but not used
> 
> 
> What am I doing wrong?
> 
> Gino Lucrezi
> Penta Consulting Services Srl
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users