[postgis-users] PostGIS 0.9.1 - On Windows OK

[TECHER Jean David]

Hi Paul,

I compiled on Windows Geos 2.1.0, Proj 4.4.9, PostGIS 0.9.1 with PG CVS from
today...

All seems to be OK...The binaries (with postgis.sql, libpostgis.dll,
shp2pgsql.exe and so on...) are available here

http://postgresqlwin32.free.fr/download/pgsql800win32/binary-DLL/binaries-po
stgis-0.9.1_geos-2.1.0_proj-4.4.9.zip

I will wait for PostGIS 1.RC1 as you said...I noticed that lwpostgis was
renamed to postgis.sql and asgml has been removed...



================================ Build Instructions
==============================================================

1. Install MinGW/Msys from http://www.mingw.org
 and Perl (Active Perl....)
 and wget (wget-1.9-1-bin.exe from http://gnewin32.sourceforge.net)
  with a CVS Client for Windows , with bison, with flex and so on ...

    cd /home/david
    mkdir src-2004-12-13

2. GEOS 2.1.0

 cd /home/david/src-2004-12-13
 wget http://geos.refractions.net/geos-2.1.0.tar.bz2
 tar xvjf geos-2.1.0.tar.bz2

Open the directory  geos-2.1.0/source/headers/geos

Copy the file timeval.h to this directory
then replace in file profiler.h

  #include <sys/time.h>

by
  #include "timeval.h"

OK then do

   configure --prefix=/c/pgsql800win32
   make
   ùake install

3. PROJ 4.4.9

   cd /home/david/src-2004-12-13
 wget ftp://ftp.remotesensing.org/pub/proj/proj-4.4.9.tar.gz
 tar xvzf proj-4.4.9.tar.gz
 cd proj-4.4.9
 configure --prefix=/c/pgsql800win32 && make install

4. Creaing DLL for GEOS and PROJ

cd /c/pgsql800win32/lib
g++ -shared -o
libgeos.dll -Wl,--out-implib=libgeos.dll.a -Wl,--export-all-symbols -Wl,--en
able-auto-import -Wl,--whole-archive libgeos.a -Wl,--no-whole-archive
/c/mingw/lib/libmingw32.a
cd /c/pgsql800win32/lib
gcc -shared -o
libproj.dll -Wl,--out-implib=libproj.dll.a -Wl,--export-all-symbols -Wl,--en
able-auto-import -Wl,--whole-archive libproj.a -Wl,--no-whole-archive
/c/mingw/lib/libmingw32.a


5. PostgreSQL (CVS 2004-12-13 at 11:54 French Hours) and PostGIS 0.9.1

  cd /home/david/src-2004-12-13
  cvs -d:pserver:anoncvs at anoncvs.postgresql.org:/projects/cvsroot login
  cvs -z3 -d:pserver:anoncvs at anoncvs.postgresql.org:/projects/cvsroot co -P
pgsql
  cd pgsql/
  configure --prefix=/c/pgsql800win32 --without-readline --without-zlib &&
make
  cd contrib
  wget http://postgis.refractions.net/postgis-0.9.1.tar.gz
  tar xvzf postgis-0.9.1.tar.gz
  cd postgis-0.9.1
  cat Makefile | sed 's/\/usr\/local/\/c\/pgsql800win32/g' > Makefile
  make
  make install
  cp loader/*.exe /c/pgsql800win32/bin
  cd ../..
  make install

P.S: The PostGIS Documentation (HTML and PDF) was done using xlstproc (HTML)
et dblatex (PDF)
   The PG contrib was added to the distribution:
   cd //home/david/src-2004-12-13/pgsql/contrib
   make install

============================================================================
===========================

Do U think it could be able to put a function liek this to make easier
creating spatial  index on postgis???


CREATE OR REPLACE FUNCTION create_gis_index(text)
  RETURNS text AS
$BODY$
DECLARE
rec record;
BEGIN

SELECT INTO rec f_geometry_column FROM geometry_columns WHERE f_table_name
like $1;


  IF FOUND THEN
    EXECUTE 'CREATE INDEX ' || $1 || '_index_spatial ON '|| $1 || ' USING
gist('|| rec.f_geometry_column  || ' gist_geometry_ops)';
    RETURN 'Index Spatial sur ' || $1 || '...OK';
  END IF;


  RETURN 'Index Spatial sur ' || $1 || '...OK';
END;
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;
ALTER FUNCTION create_gis_index(text) OWNER TO postgres;

THANKS
----------------------------------------------------------------
TECHER Jean David
Responsable Informatique 01MAP
e-mail: davidtecher at yahoo.fr
site perso : http://techer.pascal.free.fr/postgis/
site pro: http://www.01map.com/download/
K-S:"The greatest trick the devil pulled off was convincing people he didn't
exist"
------------------------------------------------------------
----- Original Message -----
From: "Paul Ramsey" <pramsey at refractions.net>
To: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
Sent: Monday, December 13, 2004 7:34 AM
Subject: [postgis-users] PostGIS 0.9.1


> I have rolled out the numerous changes in the 0.9 branch to a 0.9.1
> release.
>
> Next up is a 1.0RC1 release. I hope people will take a little time to
> test the 1.0RC series, as it represents a major shift in the code base.
>
> Thanks,
>
> Paul
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>