[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] windows binaries for rc1 avaialble -- should fix people's issues
From: Chris English <sglish () hotmail ! com>
Date: 2012-03-29 20:54:26
Message-ID: SNT117-W64CC535CE101B57405C6BCC5480 () phx ! gbl
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Regina,
Worked great, no snags, going off to wrestle with tiger_geocoder_2010.
Thanks,
Chris English
From: lr@pcorp.us
To: postgis-users@postgis.refractions.net
Date: Thu, 29 Mar 2012 13:32:24 -0400
Subject: Re: [postgis-users] windows binaries for rc1 avaialble -- should fix people's issues
All we have windows binaries rc1 up.
John,
You were right about the xml. We neglected to package
this dll in the postgis 2.0.0 experimental builds thinking that EDB builds
already had them. Theirs has a different name though.
So I think all people who were installing with on an instance
that had postgis 1.5. didn't notice it because we distributed that dll with the
postgis 1.5s.
We didn't notice the issues until trying ot install on a
virgin windows xp install. Anyrate the rc1s up should work fine for
everythong
http://www.postgis.org/download/windows/experimental.php
For
people who had issues before, please let us know if you still have issues with
the rc1 builds.
Looks
like there will be an Rc2 since we've already got fixes up and tickets.
We;d like as many people testing so we can have a good RC2.
Thanks,
Regina
From:
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of
John Callahan
Sent: Thursday, March 29, 2012 8:54
AM
To: PostGIS Users Discussion
Subject: Re:
[postgis-users] Installation problem
withpostgis-pg91-binaries-2.0.0beta4w32
I had that problem once. It was related to a missing (or
outdated) libxml2-2.dll in the /bin folder. I would stop the postgres
service and try manually recopying all of the files to their appropriate
locations.
- John
On Thu, Mar 29, 2012 at 6:25 AM, <feurbano@clix.pt> wrote:
Dear list,
we are trying to install the latest
available experimental binaries for
windows
(postgis-pg91-binaries-2.0.0beta4w32).
We installed postgres
9.1 (32bit) and than run the installer
file
'makepostgisdb_using_extensions.bat' with the proper (hopefully)
set.
We get this error:
"C:\Program Files
(x86)\PostgreSQL\9.1\bin\psql" -d "sam" -c "CREATE
EXTENSION
postgis;"
ERROR: could not load library "C:/Program
Files
(x86)/PostgreSQL/9.1/lib/postgis-2.0.dll": The specified module
could not be found.
We are installing on a Windows Server 2008 R2
64-bit and we have installed
postgresql-9.1.3-1-windows.exe
(32-bit)
The file 'makepostgisdb_using_extensions.bat' look like
this:
REM this is an example of how to create a new db and spatially
enable it using
CREATE EXTENSION
set PGPORT=5432
set
PGHOST=localhost
set PGUSER=postgres
set PGPASSWORD=***
set
THEDB=sam
REM PGINSTALL=C:\Program Files\PostgreSQL\9.1
set
PGINSTALL=C:\Program Files (x86)\PostgreSQL\9.1
set
PGADMIN=%PGINSTALL%\pgAdmin III
set PGBIN=%PGINSTALL%\bin\
set
PGLIB=%PGINSTALL%\lib\
set POSTGISVER=2.0
xcopy bin\*.*
"%PGBIN%"
xcopy /I /S bin\postgisgui\* "%PGBIN%\postgisgui"
xcopy /I
plugins.d "%PGADMIN%\plugins.d"
xcopy lib\*.* "%PGLIB%"
xcopy
share\extension\*.* "%PGINSTALL%\share\extension"
xcopy /I
share\contrib\postgis-%POSTGISVER%
"%PGINSTALL%\share\contrib\postgis-%POSTGISVER%"
"%PGBIN%\psql"
-c "CREATE DATABASE %THEDB%"
"%PGBIN%\psql" -d "%THEDB%" -c
"CREATE EXTENSION postgis;"
"%PGBIN%\psql" -d "%THEDB%" -c "CREATE
EXTENSION postgis_topology;"
REM Uncomment the below line if this is
a template database
REM "%PGBIN%\psql" -d "%THEDB%" -c "UPDATE
pg_database SET datistemplate = true
WHERE datname = '%THEDB%';GRANT ALL
ON geometry_columns TO PUBLIC; GRANT ALL ON
spatial_ref_sys TO
PUBLIC"
"C:/Program Files
(x86)/PostgreSQL/9.1/lib/postgis-2.0.dll" is where it is
supposed to
be.
Any suggestion?
Thanks a
lot
Ferdinando
_______________________________________________
postgis-users
mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[Attachment #5 (text/html)]
<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Tahoma
}
--></style></head>
<body class='hmmessage'><div dir='ltr'>
Regina,<br><br>Worked great, no snags, going off to wrestle with \
tiger_geocoder_2010.<br><br>Thanks,<br>Chris English<br><br><div><div \
id="SkyDrivePlaceholder"></div><hr id="stopSpelling">From: lr@pcorp.us<br>To: \
postgis-users@postgis.refractions.net<br>Date: Thu, 29 Mar 2012 13:32:24 \
-0400<br>Subject: Re: [postgis-users] windows binaries for rc1 avaialble -- \
should fix people's issues<br><br>
<meta http-equiv="Content-Type" content="text/html; charset=unicode">
<meta name="Generator" content="Microsoft SafeHTML">
<div dir="ltr" align="left"><span class="ecx795502617-29032012"><font color="#0000ff" \
face="Arial" size="2">All we have windows binaries rc1 up.</font></span></div> <div \
dir="ltr" align="left"><span class="ecx795502617-29032012"><font color="#0000ff" \
face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2">John,</font></span></div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" size="2">You were \
right about the xml. We neglected to package this dll in the postgis 2.0.0 \
experimental builds thinking that EDB builds already had them. Theirs has a \
different name though.</font></span></div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" size="2">So I think \
all people who were installing with on an instance that had postgis 1.5. didn't \
notice it because we distributed that dll with the postgis \
1.5s. </font></span></div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" size="2">We didn't \
notice the issues until trying ot install on a virgin windows xp install. \
Anyrate the rc1s up should work fine for everythong</font></span></div>
<div dir="ltr" align="left"><span class="ecx795502617-29032012"><font color="#0000ff" \
face="Arial" size="2"></font></span> </div> <div dir="ltr" align="left"><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div><font color="#0000ff" face="Arial" \
size="2"></font> </div> <div><font color="#0000ff" face="Arial" size="2"><a \
href="http://www.postgis.org/download/windows/experimental.php" \
target="_blank">http://www.postgis.org/download/windows/experimental.php</a></font></div>
<div><font color="#0000ff" face="Arial" size="2"></font> </div>
<div><span class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2">For people who had issues before, please let us know if you still have \
issues with the rc1 builds.</font></span></div>
<div><span class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2"></font></span> </div> <div><span class="ecx795502617-29032012"><font \
color="#0000ff" face="Arial" size="2">Looks like there will be an Rc2 since we've \
already got fixes up and tickets. We;d like as many people testing so we can \
have a good RC2.</font></span></div> <div><span class="ecx795502617-29032012"><font \
color="#0000ff" face="Arial" size="2"></font></span> </div> <div><span \
class="ecx795502617-29032012"><font color="#0000ff" face="Arial" \
size="2">Thanks,</font></span></div> <div><span class="ecx795502617-29032012"><font \
color="#0000ff" face="Arial" size="2">Regina</font></span></div> <div><span \
class="ecx795502617-29032012"></span> </div> <div><br></div>
<blockquote style="border-left:#0000ff 2px \
solid;padding-left:5px;margin-left:5px;margin-right:0px" dir="ltr"> <div dir="ltr" \
class="ecxOutlookMessageHeader" align="left" lang="en-us"> <hr tabindex="-1">
<font face="Tahoma" size="2"><b>From:</b>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <b>On Behalf Of
</b>John Callahan<br><b>Sent:</b> Thursday, March 29, 2012 8:54
AM<br><b>To:</b> PostGIS Users Discussion<br><b>Subject:</b> Re:
[postgis-users] Installation problem
withpostgis-pg91-binaries-2.0.0beta4w32<br></font><br></div>
<div></div>I had that problem once. It was related to a missing (or
outdated) libxml2-2.dll in the /bin folder. I would stop the postgres
service and try manually recopying all of the files to their appropriate
locations.
<div><br clear="all">
<div>- John</div>
<div><br></div>
<div><br></div><br><br><br><br>
<div class="ecxgmail_quote">On Thu, Mar 29, 2012 at 6:25 AM, <span dir="ltr"><<a \
href="mailto:feurbano@clix.pt">feurbano@clix.pt</a>></span> wrote:<br> \
<blockquote style="border-left:#ccc 1px solid;padding-left:1ex" \
class="ecxgmail_quote">Dear list,<br>we are trying to install the latest available \
experimental binaries for windows<br>(postgis-pg91-binaries-2.0.0beta4w32).<br>We \
installed postgres 9.1 (32bit) and than run the installer
file<br>'makepostgisdb_using_extensions.bat' with the proper (hopefully)
set.<br>We get this error:<br><br>"C:\Program Files
(x86)\PostgreSQL\9.1\bin\psql" -d "sam" -c "CREATE
EXTENSION<br>postgis;"<br>ERROR: could not load library "C:/Program
Files<br>(x86)/PostgreSQL/9.1/lib/postgis-2.0.dll": The specified module
could not be found.<br><br>We are installing on a Windows Server 2008 R2
64-bit and we have installed<br>postgresql-9.1.3-1-windows.exe
(32-bit)<br><br>The file 'makepostgisdb_using_extensions.bat' look like
this:<br>REM this is an example of how to create a new db and spatially
enable it using<br>CREATE EXTENSION<br>set PGPORT=5432<br>set
PGHOST=localhost<br>set PGUSER=postgres<br>set PGPASSWORD=***<br>set
THEDB=sam<br>REM PGINSTALL=C:\Program Files\PostgreSQL\9.1<br>set
PGINSTALL=C:\Program Files (x86)\PostgreSQL\9.1<br>set
PGADMIN=%PGINSTALL%\pgAdmin III<br>set PGBIN=%PGINSTALL%\bin\<br>set
PGLIB=%PGINSTALL%\lib\<br>set POSTGISVER=2.0<br>xcopy bin\*.*
"%PGBIN%"<br>xcopy /I /S bin\postgisgui\* "%PGBIN%\postgisgui"<br>xcopy /I
plugins.d "%PGADMIN%\plugins.d"<br>xcopy lib\*.* "%PGLIB%"<br>xcopy
share\extension\*.* "%PGINSTALL%\share\extension"<br>xcopy /I
share\contrib\postgis-%POSTGISVER%<br>"%PGINSTALL%\share\contrib\postgis-%POSTGISVER%"<br>"%PGBIN%\psql" \
-c "CREATE DATABASE %THEDB%"<br>"%PGBIN%\psql" -d "%THEDB%" -c
"CREATE EXTENSION postgis;"<br>"%PGBIN%\psql" -d "%THEDB%" -c "CREATE
EXTENSION postgis_topology;"<br><br>REM Uncomment the below line if this is
a template database<br>REM "%PGBIN%\psql" -d "%THEDB%" -c "UPDATE
pg_database SET datistemplate = true<br>WHERE datname = '%THEDB%';GRANT ALL
ON geometry_columns TO PUBLIC; GRANT ALL ON<br>spatial_ref_sys TO
PUBLIC"<br><br><br>"C:/Program Files
(x86)/PostgreSQL/9.1/lib/postgis-2.0.dll" is where it is<br>supposed to
be.<br>Any suggestion?<br><br>Thanks a
lot<br><br>Ferdinando<br><br><br>_______________________________________________<br>postgis-users \
mailing list<br><a \
href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</a><br><a \
href="http://postgis.refractions.net/mailman/listinfo/postgis-users" \
target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br></blockquote></div><br></div></blockquote>
<br>_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users</div> \
</div></body> </html>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic