<!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>
I have tried my own binaries on an other computer and installed it
manually<br>
<br>
runas /user:postgres cmd<br>
set PATH=C:\Program Files\PostgreSQL\8.2beta1\bin;C:\Program
Files\PostgreSQL\8.2beta1\lib;%PATH%<br>
set PGDATA=C:\Program Files\PostgreSQL\8.2beta1\data<br>
initdb -A trust<br>
createdb ....<br>
and so on<br>
<br>
it works<br>
but I think it is a better idea to wait that postgresql 8.2 is out
before<br>
building it.<br>
<br>
Perhaps I could try it for 8.1.5 if U want!<br>
<br>
Let me know!<br>
<br>
<br>
Mike Leahy a écrit :
<blockquote cite="mid453A9736.9000006@alumni.uwaterloo.ca" type="cite">
<pre wrap="">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:
</pre>
<blockquote type="cite">
<pre wrap="">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
<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)
For a manual installation the following link could be usefull
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>
or
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>
!!! I HOPE SOMEONE HAS A BETTER IDEA!!!
Mike Leahy a écrit :
</pre>
<blockquote 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>
<pre wrap="">
--
--david;
<a class="moz-txt-link-freetext" href="http://www.davidgis.fr">http://www.davidgis.fr</a>
------------------------------------------------------------------------
_______________________________________________
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>
<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>