[postgis-users] Help with PostGIS Installation

[nom]

Hi everyone!
   
  I am currently working on a project for school that requires the use of PostGIS and
  so I quickly went to the various websites to find out the requirements.  I am currently
  stuck in installation of PostGIS.  So far, this is my progress:
   
  Installed Cygwin and development tools like gcc, readline etc.
  Installed Proj4.4.6
  Installed Geos-2.2.3
  Installed Postgresql-8.2.0 using the source tree (./configure, make, make check, make install, although there was a problem with make check)
   
  After setting these up I followed the instructions on PostGIS.pdf.
   
  I placed the unzipped folder of PostGIS-1.1.6 (Also tried 1.2.0 but same problem)
  under :
   
  C:\cygwin\home\Mon\postgresql-8.2.0\contrib
   
  I also changed the Makefile.config to for Proj4 and GEOS:
   
  USE_PROJ=1
  PROJ_DIR=/usr/local
  PROJ_LIBDIR=@PROJ_LIBDIR@
   
  USE_GEOS=1
  GEOS_DIR=/usr/local
  GEOS_LDFLAGS=@GEOS_LDFLAGS@
  # EXPERIMENTAL! use geos C-API (only available with GEOS-2.2.x and up)
  USE_GEOS_CAPI=@USE_GEOS_CAPI@
   
  Im not sure if the directory paths are correct.....
   
  Anyway I go to postgresql-8.2.0/contrib/postgis-1.1.6 in CYGWIN and type:
   
  ./configure --with-pgsql=/usr/local/pgsql/bin/pg_config
   
  The build seems fine at first but eventually I encounter an error:
   
  ed reference to `__imp__SPI_processed'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:138: undefin
ed reference to `_SPI_exec'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:140: undefin
ed reference to `_elog_start'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:140: undefin
ed reference to `_elog_finish'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:142: undefin
ed reference to `__imp__SPI_processed'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:158: undefin
ed reference to `_elog_start'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:158: undefin
ed reference to `_elog_finish'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:163: undefin
ed reference to `_SPI_finish'
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:147: undefin
ed reference to `_SPI_finish'
long_xact.o: In function `getTransactionID':
/home/Mon/postgresql-8.2.0/contrib/postgis-1.1.6/lwgeom/long_xact.c:172: undefin
ed reference to `_GetCurrentTransactionId'
collect2: ld returned 1 exit status
/usr/bin/dllwrap: /usr/bin/gcc exited with status 1
make[1]: *** [lwgeom.so] Error 1
make[1]: Leaving directory `/home/Mon/postgis-1.1.6/lwgeom'
make: *** [liblwgeom] Error 2
   
  I encounter this with PostGIS versions 1.2.0 and 1.1.6. 
   
  Would anyone know why this problem is occuring?  I am currently stuck here and
  I don't know how to proceed.  I would really appreciate help with this problem if
  anyone has encountered it and has solved it.  I would also appreciate the validation of the paths I used for GEOS and PROJ4.  Thank you for your cooperation and
  time in reading this :D
   
  Mon
   

 		
---------------------------------
Be smarter than spam. See how smart SpamGuard is at giving junk email the boot with the All-new Yahoo! Mail  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061211/0ef7b11c/attachment.html>