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