[postgis-users] can't run lwpostgis

[Ryan D. Enos]

On Sun, 2007-08-19 at 01:23 -0700, Ryan D. Enos wrote:
>/ Hi Everyone,
/>/ I'm sure this is an easy answer, but it has me held up and I'd really 
/>/ like to figure it out.
/>/ I am recently running Windows Vista with postgresql 8.2, I am attempting 
/>/ to upgrade to postgis 1.3.1.  As such, I have removed the earlier 
/>/ version of postgis using the postgres installer.  I have run the postgis 
/>/ 1.3.1 installer and am trying to do the 'softupgrade'. Here is the 
/>/ problem, when I run the command from:
/>/ C:\Program Files\PostgreSQL\8.2\share\contrib>psql -f 
/>/ lwpostgis_upgrade.sql -d il_voter_1
/>/ 'psql' is not recognized as an internal or external command, operable 
/>/ program or batch file.
/>/ 
/>/ 
/>/ When I run from:
/>/ C:\Program Files\PostgreSQL\8.2\bin>psql -f lwpostgis_upgrade.sql -d 
/>/ il_voter_1
/>/ Password:
/>/ lwpostgis_upgrade.sql: No such file or directory
/>/ 
/>/ But the file is definitely there!  I have even tried to build it myself 
/>/ using the suggestion from the documentation.
/>/ 
/>/ So, I'm sure this is just something about the way I have postgresql 
/>/ installed, but can anybody help me out on this.
/>/ Thanks.
/>/ Ryan
/
> Hi Ryan,

> If you look at the start menu, the PostgreSQL installers normally place
> a "Command Prompt" option under the "PostgreSQL 8.2" group which
> automatically sets the PATH to include C:\Program Files\PostgreSQL\8.2
> \bin. I'd use this, and then go for your first option:

> C:\Program Files\PostgreSQL\8.2\share\contrib>psql -f
> lwpostgis_upgrade.sql -d il_voter_1


> ATB,

> Mark.

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


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