<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'>
<p class="MsoNormal"><span style="color:#4F81BD">Hello fellow postgis users,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">I am trying to figure out how to
install the most current postgis 2.0 binaries for windows 7 32 bit. The
instructions posted in the readme and on the download page are a very unclear
and vague to someone like myself who is not familiar with installing programs
other than simply downloading a file, double clicking it, and then pressing an
install button. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">I will explicity explain
my install process below (I didn’t download anything else except the
binaries <span style="background:white">(r8221) and of course postgres 9.1.1
which is currently installed</span>:<a href="http://postgis.refractions.net/download/windows/experimental.php"><span style="color:#4F81BD">http://postgis.refractions.net/download/windows/experimental.php</span></a>)<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">First, I downloaded the
postgis-pg91-binaries-2.0.0svn folder, extracted it to my C drive and it
contained the following files/directories inside:</span><o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">bin<o:p></o:p></p>
<p class="MsoNormal">lib<o:p></o:p></p>
<p class="MsoNormal">Plugins.d<o:p></o:p></p>
<p class="MsoNormal">share<o:p></o:p></p>
<p class="MsoNormal">makepostgisdb.bat<o:p></o:p></p>
<p class="MsoNormal">README.txt<o:p></o:p></p>
<p class="MsoNormal">README_EXTENSIONS.txt<o:p></o:p></p>
<p class="MsoNormal">README_Raster.txt<o:p></o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#4F81BD">Then I referred to the
directions on the website which state the following:<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";
color:#555555;background:white">9.1+ CREATE EXTENSION syntax. <b>To
install:</b></span><span style="font-size:12.0pt;font-family:"Times New Roman","serif""><o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#555555">First
copy the share/extension files into your PostgreSQL share/extension folder.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#555555">Then
in any database you'd like to spatially enable, run at least postgis (which
contains both geometry and raster support) and optionally postgis_topology
commands.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#555555">CREATE
EXTENSION postgis; <br>
CREATE EXTENSION postgis_topology;<o:p></o:p></span></b></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#555555"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="color:#4F81BD">So, I follow these instructions and put the contents of
extension in the extension folder and the contents of contrib into the contrib
folder of my postgis install. I didn’t worry about any of the other files
because it doesn’t specify that I needed to in the aforementioned install
directions.<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="color:#4F81BD">Next I load pg admin and try to spatially enable a
database by running the commands specified and I get the following message:<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><b><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:#555555"><o:p> </o:p></span></b></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:red">ERROR:
could not access file "$libdir/postgis-2.0": No such file or
directory<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:red"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:red">**********
Error **********<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:red"><o:p> </o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:red">ERROR:
could not access file "$libdir/postgis-2.0": No such file or
directory<o:p></o:p></span></p>
<p class="MsoNormal" style="line-height:13.5pt;background:white"><span style="font-size:9.0pt;font-family:"Verdana","sans-serif";color:red">SQL state:
58P01<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal"><span style="color:#4F81BD">I’m sure I am forgetting some
steps, but this is all that the install page stated that I needed to do, so
that is what I did. Again, I have no knowledge of installing programs manually
and what that entails.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">If someone could please give me
explicit instructions on exactly how to get a fully functional postgis 2.0
install on my computer with all features enabled and a template created in my
database (like the 1.53 postgis stack builder install creates) I would really
appreciate it! <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">I have been struggling with this
for weeks and I honestly have no idea what to do as I can’t find any detailed
instructions online. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">If my version of postgres is
incompatible I am happy to get a version that will work with 2.0 as my main
reason for having postgres is to use postgis. <o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">Thanks,<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color:#4F81BD">Andrew<o:p></o:p></span></p> </div></body>
</html>