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

[Mike Leahy]

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 ;-)
>