[postgis-users] FYI: Solution to PostGIS Installation Problems on Cygwin

[Will Shaw]

Those of you who have tried to compile postgis with no success have probably
ready many posts about what modifications you need to do.  I just wanted to
clarify I few things.  First of all you do need to modify the make file to
include:

#---------------------------------------------------------------
# Add libraries that libpq depends (or might depend) on into the
# shared library link.  (The order in which you list them here doesn't
# matter.)
SHLIB_LINK=$(filter -L%, $(LDFLAGS)) 
ifeq ($(USE_PROJ),1)
	SHLIB_LINK=$(filter -L%, $(LDFLAGS)) -L$(PROJ_DIR)/lib -lproj
else
	SHLIB_LINK=$(filter -L%, $(LDFLAGS)) ../../src/backend/libpostgres.a
endif

#---------------------------------------------------------------

And secondly, you do need to modify the file
/usr/src/postgresql-7.3.2-1/src/include/optimizer/cost.h to include:

extern DLLIMPORT double cpu_index_tuple_cost;
//extern double cpu_index_tuple_cost;

Now, what no one has mentioned so far is that this last modification will
not work unless you have a java JDK installation in Cygwin.  Getting java
into Cygwin is apparently tricky, because I had a lot of problems, but the
easiest way is to download the Blackdown java JDK-1.4.1 for linux from here.
http://www.blackdown.org/java-linux/mirrors.html  Follow the directions in
the install-j2sdk file.  I wasn't able to get the java plugin or webstart to
work, but you don't need it anyway.

Regards,

Will