[postgis-users] Postgis-0.7.4 + PSQL-7.3.1- installation

[Barbara Olga Kastelliz]

Hello,
I have recently installed postgresql-7.3.1 with postgis-0.7.4,
on Windows 2000. Many thanks to the archiv and the group.
what had to be done, can be found in the archiv, but in different mails.

1. file: pstgresql/src/include/optimizer/cost.h: DLLIMPORT has to be added in
line:
extern DLLIMPORT double cpu_index_tuple_cost

2. compiling of postgresql:  
postgresql-7.2.3-gcc3.patch
applying the patch with the executable patch is not necessary, the files
	/usr/share/postgresql/src/makefiles/Makefile.win	and
	/usr/share/postgresql/src/template/win to 
 have to look like that: (archiv, mail form Assefa Yewondwossen, Jan 9th,
2003):

# $Header: /cvsroot/pgsql-server/src/makefiles/Makefile.win,v 1.18 2002/09/05
18:28:46 petere Exp $
LDFLAGS+= -g
DLLTOOL= dlltool
DLLWRAP= dllwrap
DLLLIBS= -L/usr/local/lib -lcygipc -lcrypt
BE_DLLLIBS= -L$(top_builddir)/src/backend -lpostgres
DLLINIT = $(top_builddir)/src/utils/dllinit.o
MK_NO_LORDER=true
MAKE_DLL=true
# linking with -lm or -lc causes program to crash
# (see http://sources.redhat.com/cygwin/faq/faq.html#SEC110)
LIBS:=$(filter-out -lm -lc, $(LIBS))

AROPT = crs
DLSUFFIX = .dll
CFLAGS_SL =

%.dll: %.o
	$(DLLTOOL) --export-all --output-def $*.def $<
	$(DLLWRAP) -o $@ --def $*.def $< $(DLLINIT) $(SHLIB_LINK)
	rm -f $*.def

ifneq (,$(findstring backend,$(subdir)))
ifeq (,$(findstring conversion_procs,$(subdir)))
override CPPFLAGS+= -DBUILDING_DLL
endif
endif

ifneq (,$(findstring ecpg/lib,$(subdir)))
override CPPFLAGS+= -DBUILDING_DLL
endif

# required by Python headers
ifneq (,$(findstring src/pl/plpython,$(subdir)))
override CPPFLAGS+= -DUSE_DL_IMPORT
endif



#file: /usr/share/postgresql/src/template/win:

CFLAGS=-O2
SRCH_LIB=/usr/local/lib
LIBS=-lcygipc



next: configuring postgresql with:

$ LDFLAGS=-L/usr/local/lib ./configure --enable-multibyte
--with-CXX --with-perl --prefix=/usr --sysconfdir=/etc 
--docdir=/usr/doc/postgresql-$version

I have no idea, if --with-perl is necessary, but
without it, I was not able to compile postgresql because I got the Error,
not able to make executables.
to the /etc directory I added the folder postgresql, there I copied
libpostgis.a and libpostgres.a,
maybe it had no effect on the result?
$ make

3.) Postgis installation

in the postgis makefile this line had to be added:
SHLIB_LINK := $(LDFLAGS) ../../src/backend/libpostgres.a
makefile:
.........
#---------------------------------------------------------------
# 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.)

# next line added
SHLIB_LINK := $(LDFLAGS) ../../src/backend/libpostgres.a
#---------------------------------------------------------------
....


$ make
$ make install

in the resulting file postgis.sql I had to replace:
$libdir/postgis.dll
with the absolute path to the postgis.dll file:
/usr/share/postgresql/contrib/postgis/postgis.dll
again I don't know wether this was because of a misconfiguration in my case,
or if this occurs more often, but it worked.

hope this will help somebody,
greetings, 
barbara