[postgis-users] can't run lwpostgis

[Ryan D. Enos]

Thanks Regina,
that was where it was of course and it turns out this was partially a Vista permissions issue and partially my confusion.
I knew the file was there originally but Vista will not let me access files from there - don't know why.  In my attempts to fix that, I had lost track of the file and moved a corrupted version to the wrong folder.
I was still not able to run lwpostgis from \share\contrib\postgis
but when I moved it to \bin it worked. 
Thanks.
Ryan

>Ryan,
>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.  
 
>try cding into postgis folder after launching the PostgreSQL command prompt and then give it another go.
 
>alternatively just do
>psql -f "C:\Program Files\PostgreSQL\8.2\share\contrib\postgis\lwpostgis_upgrade.sql" -d il_voter_1

 
>Hope that helps,
>Regina
 

________________________________

From: postgis-users-bounces at postgis.refractions.net <http://postgis.refractions.net/mailman/listinfo/postgis-users> on behalf of Mark Cave-Ayland
Sent: Mon 8/20/2007 2:28 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] can't run lwpostgis



On Sun, 2007-08-19 at 12:31 -0700, Ryan D. Enos wrote:

>/ Thanks Mark, I was hoping it would be that simple, but I am still getting the same error:
/>/ //lwpostgis_upgrade.sql: No such file or directory//
/>/
/>/ any other suggestions?
/>/ thanks.
/>/ Ryan
/
Hmmm, do the file permissions look reasonable for the
lwpostgis_upgrade.sql file? Other than that, I don't think I can help
you as I'm still using WinXP and have never really used Vista - all I
can tell you is that the installer doesn't explicitly change any file
permissions when extracting the files :(


ATB,

Mark.

--
ILande - Open Source Consultancy
http://www.ilande.co.uk <http://www.ilande.co.uk/> 


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net <http://postgis.refractions.net/mailman/listinfo/postgis-users>
http://postgis.refractions.net/mailman/listinfo/postgis-users