[postgis-users] Installation problem

[Gino Lucrezi]

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