[postgis-users] PostGIS 0.9.1 - On Windows OK

[strk at refractions.net]

On Mon, Dec 13, 2004 at 03:05:01PM +0100, TECHER Jean David wrote:
> 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...

0.9.1 is a release from the 0_9 branch.
HEAD branch contains asgml and lwpostgis (will be 1.RC1)
--strk;

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