[postgis-users] Help with PostGIS Installation

[nom]

Thanx guys for your replies!  ill be trying to use the windows pre-compiled version in
  a while.  Well the main reason I tried the CYGWIN path with compiling is I thought
  that it would offer more customization just in case I needed to change something or
  look at the code made.  Another is I am not sure if the windows precompiled version
  comes with GEOS and PROJ4.  Would you guys know?  Although now I do think ill go for the pre-compiled version just to get POSTGIS to work :D.  Thanks for everything.  ill just post again if I run into any problems with the pre-compiled 
  version. 

Craig Miller <craig.miller at spatialminds.com> wrote:
      Why don't you use the native Windows pre-compiled version instead?  There are valid reasons to use cygwin (instructor says you need to, similar linux/windows dev environments for class, gcc compiler, etc), I just want to make sure you aren't making it more difficult than you need to.
   
  --Craig
   

      
---------------------------------
  From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of nom
Sent: Monday, December 11, 2006 2:05 AM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Help with PostGIS Installation


  
  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 _______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


 		
---------------------------------
 All new Yahoo! Mail - 
---------------------------------
Get a sneak peak at messages with a handy reading pane.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061211/8c268ba8/attachment.html>