[postgis-users] Cygwin / PostgreSQL / PostGIS installation

[christian.schuster at rsag.ch]

Hi list,

I have a working PostgreSQL with PostGIS (CVS) support on my local machine
(Win2000 Pro). Now I have a new installed Win 2000 Server SP3 on a IBM
Netfinity machine and I wanted to install there the latest releases of
Cygwin, PostgreSQL and PostGIS. Here is the problem. I cannot make
PostGIS-0.7.4. The error is:



What I did is the following:

1.    I downloaded the latest cygwin release with PostgreSQL including the
source:
2.    I added DLLIMPORT to /src/include/ptimizer/cost.h.
3.    I configured PostgreSQL LDFLAGS=-L/usr/local/lib ./configure
4.    I made PostgreSQL

      Here I have many messages like the following on:
         make -C tcop all
         make[3]: Entering directory
         `/usr/src/postgresql-7.3.2-1/src/backend/tcop'
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -I../../../src/include  -DBUILDING_DLL  -c -o dest.o dest.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -I../../../src/include  -DBUILDING_DLL  -c -o fastpath.o
         fastpath.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -I../../../src/include  -DBUILDING_DLL  -c -o postgres.o
         postgres.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -I../../../src/include  -DBUILDING_DLL  -c -o pquery.o pquery.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -I../../../src/include  -DBUILDING_DLL  -c -o utility.o utility.c
         /usr/i686-pc-cygwin/bin/ld.exe -r -o SUBSYS.o dest.o fastpath.o
         postgres.o pquery.o utility.o
         make[3]: Leaving directory
         `/usr/src/postgresql-7.3.2-1/src/backend/tcop'

      I just copied one out of them. But I guess something is not okay

      But  was suprised as at the end message came that PostgreSQL was
successfully made and is ready to install

         /usr/include/stdio.h: At top level:
         pl_scan.c:2384: warning: `yy_flex_realloc' defined but not used
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -Wno-error  -I. -I../../../../src/include   -c -o pl_handler.o
         pl_handler.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -Wno-error  -I. -I../../../../src/include   -c -o pl_comp.o
         pl_comp.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -Wno-error  -I. -I../../../../src/include   -c -o pl_exec.o
         pl_exec.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations
         -Wno-error  -I. -I../../../../src/include   -c -o pl_funcs.o
         pl_funcs.c
         dlltool --export-all --output-def plpgsql.def pl_gram.o
         pl_handler.o pl_comp.o pl_exec.o pl_funcs.o
         dllwrap -o plpgsql.dll --dllname plpgsql.dll --def plpgsql.def
         pl_gram.o pl_handler.o pl_comp.o pl_exec.o pl_funcs.o
         ../../../../src/utils/d
         llinit.o -L/usr/local/lib -L../../../../src/backend -lpostgres
         dlltool --dllname plpgsql.dll --def plpgsql.def --output-lib
         libplpgsql.a
         make[4]: Leaving directory
         `/usr/src/postgresql-7.3.2-1/src/pl/plpgsql/src'
         make[3]: Leaving directory
         `/usr/src/postgresql-7.3.2-1/src/pl/plpgsql'
         make[2]: Leaving directory `/usr/src/postgresql-7.3.2-1/src/pl'
         make[1]: Leaving directory `/usr/src/postgresql-7.3.2-1/src'
         All of PostgreSQL successfully made. Ready to install.

5.    I changed to the PostGIS directory and tried to make it with the
following error:

         $ make
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations  -g -I.
         -I../../src/include  -DFRONTEND
         -DSYSCONFDIR='"/usr/local/pgsql/etc"' -DUS
         E_VERSION=73  -c -o postgis_debug.o postgis_debug.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations  -g -I.
         -I../../src/include  -DFRONTEND
         -DSYSCONFDIR='"/usr/local/pgsql/etc"' -DUS
         E_VERSION=73  -c -o postgis_ops.o postgis_ops.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations  -g -I.
         -I../../src/include  -DFRONTEND
         -DSYSCONFDIR='"/usr/local/pgsql/etc"' -DUS
         E_VERSION=73  -c -o postgis_fn.o postgis_fn.c
         gcc -O2 -Wall -Wmissing-prototypes -Wmissing-declarations  -g -I.
         -I../../src/include  -DFRONTEND
         -DSYSCONFDIR='"/usr/local/pgsql/etc"' -DUS
         E_VERSION=73  -c -o postgis_inout.o postgis_inout.c

         .......

         postgis_estimate.o(.text+0x1380):/usr/src/postgresql-7.3.2-1/contrib/postgis-0.7.4
/postgis_estimate.c:743: undefined reference to `_nconc'
         postgis_estimate.o(.text+0x1388):/usr/src/postgresql-7.3.2-1/contrib/postgis-0.7.4
/postgis_estimate.c:743: undefined reference to `_make_and
         s_explicit'
         postgis_estimate.o(.text+0x1398):/usr/src/postgresql-7.3.2-1/contrib/postgis-0.7.4
/postgis_estimate.c:745: undefined reference to `_canonica
         lize_qual'
         collect2: ld returned 1 exit status
         dllwrap: gcc exited with status 1
         make: *** [libpostgis.a] Error 1


I looked in the archive of PostgreSQL and PostGIS and tried several things.
But I was not able to figure out what I am doing wrong now.

Does anyone knwo where I do the mistake or what I forgot?

Regards,


Christian Schuster

Rudolf Schuster AG
Postfach 277
CH - 3000 Bern 11

http://www.rsag.ch
++41 31 348 05 30