[postgis-users] can't run lwpostgis

Ryan D. Enos renos at ucla.edu
Mon Aug 20 16:44:17 PDT 2007

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. 

>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,


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 :(



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>

More information about the postgis-users mailing list