<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<STYLE>.hmmessage P {
PADDING-BOTTOM: 0px; MARGIN: 0px; PADDING-LEFT: 0px; PADDING-RIGHT: 0px; PADDING-TOP: 0px
}
BODY.hmmessage {
FONT-FAMILY: Tahoma; FONT-SIZE: 10pt
}
</STYLE>
<META name=GENERATOR content="MSHTML 9.00.8112.16437"></HEAD>
<BODY class=hmmessage>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>Andrew,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>Did you read the README.txt file? The makepostgisdb.bat
packaged you just need to edit with the location to your PostgreSQL install and
then you should be able to just click on it and be set since it copies all the
necessary files</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>to the PostgreSQL directory.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>For the extension piece, I don't think that batch file manually
copies those but it sounds like you may have already copied those to your
PostgreSQL install, so you are probably set there.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>BTW - the current one up there doesn't have the new ST_GeomFromJSON
working (we just got compile piece working now). The next one we do
hopefully in a day or so will have that functionality.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>Hope that helps,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial>Regina</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=729445104-24112011><FONT color=#0000ff
face=Arial></FONT></SPAN> </DIV><BR>
<BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px"
dir=ltr>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT face=Tahoma><B>From:</B> postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>Andrew Joseph<BR><B>Sent:</B> Wednesday, November 23, 2011 11:28
PM<BR><B>To:</B> postgis-users@postgis.refractions.net<BR><B>Subject:</B>
[postgis-users] Problems installing postgis 2.0 on windows 7 32
bit<BR></FONT><BR></DIV>
<DIV></DIV>
<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-FAMILY: 'Verdana','sans-serif'; BACKGROUND: white; COLOR: #555555; FONT-SIZE: 9pt">9.1+
CREATE EXTENSION syntax. <B>To install:</B></SPAN><SPAN
style="FONT-FAMILY: 'Times New Roman','serif'; FONT-SIZE: 12pt"><O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #555555; FONT-SIZE: 9pt">First
copy the share/extension files into your PostgreSQL share/extension
folder.<O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #555555; FONT-SIZE: 9pt">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 style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #555555; FONT-SIZE: 9pt">CREATE
EXTENSION postgis; <BR>CREATE EXTENSION
postgis_topology;<O:P></O:P></SPAN></B></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #555555; FONT-SIZE: 9pt"><O:P></O:P></SPAN></B></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><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 style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="COLOR: #4f81bd"><O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><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 style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><B><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: #555555; FONT-SIZE: 9pt"><O:P></O:P></SPAN></B></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red; FONT-SIZE: 9pt">ERROR:
could not access file "$libdir/postgis-2.0": No such file or
directory<O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red; FONT-SIZE: 9pt"><O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red; FONT-SIZE: 9pt">**********
Error **********<O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red; FONT-SIZE: 9pt"><O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red; FONT-SIZE: 9pt">ERROR:
could not access file "$libdir/postgis-2.0": No such file or
directory<O:P></O:P></SPAN></P>
<P style="LINE-HEIGHT: 13.5pt; BACKGROUND: white" class=MsoNormal><SPAN
style="FONT-FAMILY: 'Verdana','sans-serif'; COLOR: red; FONT-SIZE: 9pt">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></BLOCKQUOTE></BODY></HTML>