<HTML dir=ltr><HEAD><TITLE>Re: [postgis-users] can't run lwpostgis</TITLE>
<META http-equiv=Content-Type content="text/html; charset=unicode">
<META content="MSHTML 6.00.6000.16525" name=GENERATOR></HEAD>
<BODY>
<DIV id=idOWAReplyText56634 dir=ltr>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>Ryan,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial color=#000000 size=2>lwpostgis_upgrade.sql is in the \share\contrib\postgis folder not the \share\contrib folder. It looks like from your path you were in just the contrib folder. </FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>try cding into postgis folder after launching the PostgreSQL command prompt and then give it another go.</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>alternatively just do</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>psql -f "C:\Program Files\PostgreSQL\8.2\share\contrib\postgis\lwpostgis_upgrade.sql" -d il_voter_1<BR></FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV>
<DIV dir=ltr><FONT face=Arial size=2>Hope that helps,</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2>Regina</FONT></DIV>
<DIV dir=ltr><FONT face=Arial size=2></FONT> </DIV></DIV>
<DIV dir=ltr><BR>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> postgis-users-bounces@postgis.refractions.net on behalf of Mark Cave-Ayland<BR><B>Sent:</B> Mon 8/20/2007 2:28 AM<BR><B>To:</B> PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] can't run lwpostgis<BR></FONT><BR></DIV>
<DIV>
<P><FONT size=2>On Sun, 2007-08-19 at 12:31 -0700, Ryan D. Enos wrote:<BR><BR>> Thanks Mark, I was hoping it would be that simple, but I am still getting the same error:<BR>> //lwpostgis_upgrade.sql: No such file or directory//<BR>><BR>> any other suggestions?<BR>> thanks.<BR>> Ryan<BR><BR>Hmmm, do the file permissions look reasonable for the<BR>lwpostgis_upgrade.sql file? Other than that, I don't think I can help<BR>you as I'm still using WinXP and have never really used Vista - all I<BR>can tell you is that the installer doesn't explicitly change any file<BR>permissions when extracting the files :(<BR><BR><BR>ATB,<BR><BR>Mark.<BR><BR>--<BR>ILande - Open Source Consultancy<BR><A href="http://www.ilande.co.uk/">http://www.ilande.co.uk</A><BR><BR><BR>_______________________________________________<BR>postgis-users mailing list<BR>postgis-users@postgis.refractions.net<BR><A href="http://postgis.refractions.net/mailman/listinfo/postgis-users">http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR></FONT></P></DIV></BODY></HTML>
<HTML><BODY><P><hr size=1></P>
<P><STRONG>
The substance of this message, including any attachments, may be confidential, legally privileged and/or exempt from disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error, please contact the sender and delete the material from any computer.
</STRONG></P></BODY></HTML>