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

[Mike Leahy]

Thanks for the help David,

Unfortunately, the same problem exists for me with the full binaries you
just posted (that the liblwgeom.dll won't load) - plus I had to move
libpq.dll from /lib folder to /bin.  Also, I'm pretty sure my earlier
conclusions drawn from using the Dependency Walker were wrong, as it
revealed similar dependency errors for a working installation that I
have, so the problem must lie in my own configuration somehow.  Perhaps
I'll give it another shot later, unless anyone has further suggestions...

Thanks again,
Mike

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