[postgis-users] PostGIS 1.1.5 Win32 Binaries for PostgreSQL 8.2 beta 1 available

[TECHER David]

Hi Mike

Thanks for your reply,

First of all, I spent a night in order to trying to build compil with
postgis
with the last snapshot from postgresql but without success :-( i.e.

ftp://ftp.fr.postgresql.org/binary/v8.2beta1/win32/

I've got the same error as you had i.e.

ERROR:  could not load library "D:/PSQL82/lib/liblwgeom.dll": The
specified module could not be found


Then since the last postgresql win32 installer was built from the
snapshot from

ftp://ftp.fr.postgresql.org/source/v8.2beta1/ then it worked but by
building everything
from source even for postgresql

I don't really not have any more info why...that's the first time I got
this error :-(

But I'm used to compil postgis on win32 only with restrict usage!

Hope someone has a idea how to solve it!!!

Else you can download all my binaries from this link

http://www.davidgis.fr/download/postgresql-8.2beta1-postgis-1.1.5-geos-2.2.3-proj-4.4.9.zip    
(32 M)

For a manual installation the following link could be usefull

1) http://archives.postgresql.org/pgsql-hackers-win32/2005-07/msg00022.php

or

2) http://dev2dev.bea.com/pub/a/2005/05/intro_to_postgresql.html

!!! I HOPE SOMEONE HAS A BETTER IDEA!!!

Mike Leahy a écrit :

>Hello list/David,
>
>I tried using these binaries with the PG 8.2 beta 1 windows binaries,
>and when I tried loading PostGIS, I got the following:
>
>postgres=# \i ../share/contrib/lwpostgis.sql
>BEGIN
>NOTICE:  type "histogram2d" is not yet defined
>DETAIL:  Creating a shell type definition.
>psql:../share/contrib/lwpostgis.sql:47: NOTICE:  type "histogram2d" is
>not yet defined
>DETAIL:  Creating a shell type definition.
>ERROR:  could not load library "D:/PSQL82/lib/liblwgeom.dll": The
>specified module could not be found.
>
>psql:../share/contrib/lwpostgis.sql:47: ERROR:  could not load library
>"D:/PSQL82/lib/liblwgeom.dll": The specified module could not be found.
>
>ERROR:  current transaction is aborted, commands ignored until end of
>transaction block
>psql:../share/contrib/lwpostgis.sql:52: ERROR:  current transaction is
>aborted, commands ignored until end of transaction block
>ERROR:  current transaction is aborted, commands ignored until end of
>transaction block
>etc....
>etc....
>etc....
>psql:../share/contrib/lwpostgis.sql:3685: ERROR:  current transaction is
>aborted, commands ignored until end of transaction block
>ERROR:  current transaction is aborted, commands ignored until end of
>transaction block
>psql:../share/contrib/lwpostgis.sql:3732: ERROR:  current transaction is
>aborted, commands ignored until end of transaction block
>ROLLBACK
>postgres=#
>
>The library is definitely found at "D:/PSQL82/lib/liblwgeom.dll", so I
>checked using Dependency Walker, and it seems that the dll isn't linking
>to postgres.exe and liblwgeom_c-1.dll (both of which are in the bin
>folder).  I tried adding the bin folder to the PATH environment
>variable, but still no luck.  Any guesses?
>
>Thanks in advance for any suggestions,
>Mike
>
>
>TECHER David wrote:
>  
>
>>Hi PostGISers,
>>
>> PostGIS 1.1.5 is out!
>>
>>[I am waiting  Marc does the installer ;-)]
>>!! BUT IT IS A TEMPORAY SOLUTION that I give you here!!
>>
>>Since the postgis Win32 installer for 1.1.5 is not yet available, I've
>>built my own binaries
>>
>>from postgresql 8.2beta1 for
>>
>>* postgresql 8.2 beta1
>>*  geos 2.2.3 (As Paul said in a recent a mail, I'm agree with him for
>>the idea to wait before
>>                       building geos 3.0.0rc1 on win32 since it is in
>>dev version.)
>>* proj 4.4.9
>>* postgis 1.1.5
>>
>>I've built it from the source which was used for the postgreql 8.2 beta1
>>available at
>>
>>
>>ftp://ftp.fr.postgresql.org/source/v8.2beta1/
>>
>>As Marc said and fixed the bug for MinGW (see his recent mail), all
>>regression test succeeded!
>>
>>pgsql2shp too ;-) (thanks Marc)
>>
>>INSTRUCTIONS:
>>==========
>>
>>POSTGREQL:
>>Install postgresql 8.2 beta1 o win32 from
>>
>>ftp://ftp.fr.postgresql.org/binary/v8.2beta1/win32/
>>
>>it should be installed in "C:\Program Files\PostgreSQL\8.2beta1" by default
>>
>>- !! INSTALL IT WITHOUT THE OPTIONAL POSTGIS !! -
>>
>>POSTGIS:
>>
>>U can download the binaries from here
>>
>>http://www.davidgis.fr/download/win32/postgis-1.1.5/postgis-1.1.5-win32.zip
>>
>>I don't try to build the java drivers (not enough times sorry!)
>>
>>unzip it into "C:\Program Files\PostgreSQL\8.2beta1"
>>
>>In order to creating a PostGIS Database called "testgis"
>>
>>as postgres user do
>>
>>createdb testgis
>>psql -d testgis -f C:\Program
>>Files\PostgreSQL\8.2beta1\share\contrib\lwpostgis.sql"
>>psql -d testgis -f C:\Program
>>Files\PostgreSQL\8.2beta1\share\contrib\lspatial_ref_sys.sql"
>>
>>I hope this instructions above will work for you ;-)
>>and Marc will have enough times to build the installer ;-)
>>
>>    
>>
>_______________________________________________
>postgis-users mailing list
>postgis-users at postgis.refractions.net
>http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>  
>


-- 
--david;
http://www.davidgis.fr

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20061021/a7c61091/attachment.html>