'Re: [postgis-users] Problems installing postgis 2.0 on windows 7 32'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: postgis-users
Subject: Re: [postgis-users] Problems installing postgis 2.0 on windows 7 32
From: "Paragon Corporation" <lr () pcorp ! us>
Date: 2011-11-24 4:55:48
Message-ID: ADACCEF7B4AD4931B441DF63E852FDB4 () D
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

Andrew,

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
to the PostgreSQL directory.

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.

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.

Hope that helps,
Regina
http://www.postgis.us

  _____  

From: postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of Andrew
Joseph
Sent: Wednesday, November 23, 2011 11:28 PM
To: postgis-users@postgis.refractions.net
Subject: [postgis-users] Problems installing postgis 2.0 on windows 7 32 bit

Hello fellow postgis users,

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. 

I will explicity explain my  install process below (I didn't download
anything else except the binaries (r8221) and of course postgres 9.1.1 which
is currently installed:
<http://postgis.refractions.net/download/windows/experimental.php>
http://postgis.refractions.net/download/windows/experimental.php)

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:

bin

lib

Plugins.d

share

makepostgisdb.bat

README.txt

README_EXTENSIONS.txt

README_Raster.txt

Then I referred to the directions on the website which state the following:

9.1+ CREATE EXTENSION syntax. To install:

First copy the share/extension files into your PostgreSQL share/extension
folder.

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.

CREATE EXTENSION postgis; 
CREATE EXTENSION postgis_topology;

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.

Next I load pg admin and try to spatially enable a database by running the
commands specified and I get the following message:

ERROR:  could not access file "$libdir/postgis-2.0": No such file or
directory

********** Error **********

ERROR: could not access file "$libdir/postgis-2.0": No such file or
directory

SQL state: 58P01

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.

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! 

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. 

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. 

Thanks,

Andrew

[Attachment #5 (text/html)]

<!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>Andrew,</DIV>
<DIV dir=ltr align=left>&nbsp;</DIV>
<DIV dir=ltr align=left>Did you read the README.txt file?&nbsp; 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</DIV>
<DIV dir=ltr align=left>to the PostgreSQL directory.</DIV>
<DIV dir=ltr align=left>&nbsp;</DIV>
<DIV dir=ltr align=left>For the extension piece, I don't think that batch file manually 
copies those&nbsp; but it sounds like you may have already copied those to your 
PostgreSQL install, so you are probably set there.</DIV>
<DIV dir=ltr align=left>&nbsp;</DIV>
<DIV dir=ltr align=left>BTW - the current one up there doesn't have the new ST_GeomFromJSON 
working (we just got compile piece working now).&nbsp; The next one we do 
hopefully in a day or so will have that functionality.</DIV>
<DIV dir=ltr align=left>&nbsp;</DIV>
<DIV dir=ltr align=left>Hope that helps,</DIV>
<DIV dir=ltr align=left>Regina</DIV>
<DIV dir=ltr align=left><A 
href="http://www.postgis.us">http://www.postgis.us</A></DIV>
<DIV dir=ltr align=left>&nbsp;</DIV>
<DIV dir=ltr align=left>&nbsp;</DIV> 
<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>
 From: postgis-users-bounces@postgis.refractions.net 
 [mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of 
 Andrew Joseph Sent: Wednesday, November 23, 2011 11:28 
 PM To: postgis-users@postgis.refractions.net Subject: 
 [postgis-users] Problems installing postgis 2.0 on windows 7 32 
 bit </DIV>
 <DIV></DIV>
 <DIV dir=ltr>
 Hello fellow postgis 
 users,<O:P></O:P>
 <O:P></O:P>
 I am trying to figure out how 
 to install the most current postgis 2.0 binaries &nbsp;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>
 <O:P></O:P>
 I will explicity explain 
 my&nbsp; install process below (I didn&#8217;t download anything else except the 
 binaries (r8221) and of course postgres 9.1.1 
 which is currently installed:<A 
 href="http://postgis.refractions.net/download/windows/experimental.php">http://postgis.refractions.net/download/windows/experimental.php</A>)<O:P></O:P>
 <O:P></O:P>
 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:<O:P></O:P>
 <O:P></O:P>
 bin<O:P></O:P>
 lib<O:P></O:P>
 Plugins.d<O:P></O:P>
 share<O:P></O:P>
 makepostgisdb.bat<O:P></O:P>
 README.txt<O:P></O:P>
 README_EXTENSIONS.txt<O:P></O:P>
 README_Raster.txt<O:P></O:P>
 <O:P></O:P>
 Then I referred to the 
 directions on the website which state the following:<O:P></O:P>
 <O:P></O:P>
 9.1+ CREATE EXTENSION syntax.&nbsp;To install:<O:P></O:P> First copy the share/extension files into your PostgreSQL \
share/extension folder.<O:P></O:P>
 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>
 CREATE 
 EXTENSION postgis;&nbsp; CREATE EXTENSION 
 postgis_topology;<O:P></O:P>
 <O:P></O:P> 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&#8217;t worry about any of \
the other files because it doesn&#8217;t specify that I needed to in the \
aforementioned install directions.<O:P></O:P>
 <O:P></O:P>
 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>
 <O:P></O:P> ERROR:&nbsp; could not access file "$libdir/postgis-2.0": No such \
file or directory<O:P></O:P>
 <O:P></O:P> ********** Error **********<O:P></O:P>
 <O:P></O:P> ERROR: could not access file "$libdir/postgis-2.0": No such file or \
 directory<O:P></O:P>
 SQL 
 state: 58P01<O:P></O:P>
 <O:P></O:P>
 <O:P></O:P>
 I&#8217;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>
 <O:P></O:P>
 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>
 <O:P></O:P>
 I have been struggling with 
 this for weeks and I honestly have no idea what to do as I can&#8217;t find any 
 detailed instructions online. <O:P></O:P>
 <O:P></O:P>
 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>
 <O:P></O:P>
 Thanks,<O:P></O:P>
 <O:P></O:P>
 Andrew<O:P></O:P></DIV></BLOCKQUOTE></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] 