<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Mike<br>
<br>
Thanks for your reply,<br>
<br>
First of all, I spent a night in order to trying to build compil with
postgis<br>
with the last snapshot from postgresql but without success :-( i.e.<br>
<br>
<pre wrap="">ftp://ftp.fr.postgresql.org/binary/v8.2beta1/win32/</pre>
I've got the same error as you had i.e. <br>
<pre wrap="">ERROR: could not load library "D:/PSQL82/lib/liblwgeom.dll": The
specified module could not be found</pre>
<br>
Then since the last postgresql win32 installer was built from the
snapshot from<br>
<br>
ftp://ftp.fr.postgresql.org/source/v8.2beta1/ then it worked but by
building everything<br>
from source even for postgresql<br>
<br>
I don't really not have any more info why...that's the first time I got
this error :-(<br>
<br>
But I'm used to compil postgis on win32 only with restrict usage!<br>
<br>
Hope someone has a idea how to solve it!!!<br>
<br>
Else you can download all my binaries from this link<br>
<br>
<a class="moz-txt-link-freetext" href="http://www.davidgis.fr/download/postgresql-8.2beta1-postgis-1.1.5-geos-2.2.3-proj-4.4.9.zip">http://www.davidgis.fr/download/postgresql-8.2beta1-postgis-1.1.5-geos-2.2.3-proj-4.4.9.zip</a>
(32 M)<br>
<br>
For a manual installation the following link could be usefull<br>
<br>
1)
<a class="moz-txt-link-freetext" href="http://archives.postgresql.org/pgsql-hackers-win32/2005-07/msg00022.php">http://archives.postgresql.org/pgsql-hackers-win32/2005-07/msg00022.php</a><br>
<br>
or<br>
<br>
2) <a class="moz-txt-link-freetext" href="http://dev2dev.bea.com/pub/a/2005/05/intro_to_postgresql.html">http://dev2dev.bea.com/pub/a/2005/05/intro_to_postgresql.html</a><br>
<br>
!!! I HOPE SOMEONE HAS A BETTER IDEA!!!<br>
<br>
Mike Leahy a écrit :
<blockquote cite="mid45391302.2020906@alumni.uwaterloo.ca" type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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
<a class="moz-txt-link-freetext" href="http://www.davidgis.fr/download/win32/postgis-1.1.5/postgis-1.1.5-win32.zip">http://www.davidgis.fr/download/win32/postgis-1.1.5/postgis-1.1.5-win32.zip</a>
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 ;-)
</pre>
</blockquote>
<pre wrap=""><!---->_______________________________________________
postgis-users mailing list
<a class="moz-txt-link-abbreviated" href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a>
<a class="moz-txt-link-freetext" href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</a>
</pre>
</blockquote>
<br>
<br>
<pre class="moz-signature" cols="72">--
--david;
<a class="moz-txt-link-freetext" href="http://www.davidgis.fr">http://www.davidgis.fr</a>
</pre>
</body>
</html>