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
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
