On Sat, 2007-08-25 at 12:08 -0400, Stephen Woodbridge wrote: > I'm trying to upgrade postGIS on my WinXP laptop. The installer is > aborting with the following error: > > Output folder: C:\DOCUME~1\woodbri\LOCALS~1\Temp\postgis_installer > UserName=postgres > Password=**** > Port=5432 > Checking for existing PostGIS installation... > ERROR: Could not open file > C:\DOCUME~1\woodbri\LOCALS~1\Temp\postgis_installer\check_templatepostgis_output.txt > > > > The batch file used for this test is: > > set PGPASSWORD=**** > set PGPORT=5432 > "C:\Program Files\PostgreSQL\8.1\bin\psql.exe" -U postgres -h > localhost -l -t -c "SELECT 'true' FROM pg_database WHERE > datname='template_postgis'" -d template1 > > "C:\DOCUME~1\woodbri\LOCALS~1\Temp\postgis_installer\check_templatepostgis_output.txt" > > 2> > "C:\DOCUME~1\woodbri\LOCALS~1\Temp\postgis_installer\check_templatepostgis_error.txt" > > the SELECT above returns zero rows. I tried adding a database > "template_postgis" but that did not help resolve the issue? > > "POSTGIS="1.1.3" GEOS="2.2.2-CAPI-1.1.0" PROJ="Rel. 4.4.9, 29 Oct 2004" > USE_STATS" > > "PostgreSQL 8.1.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) > 3.4.2 (mingw-special)" > > > Any thoughts on working around this issue? > > Thanks, > -Steve
Hi Steve, Perhaps it could be a permissions issue? The first thing to try would be to run the batch file manually from a CMD prompt and see if the same error occurs. That part of the Windows installer hasn't changed for a couple of releases... HTH, Mark. -- ILande - Open Source Consultancy http://www.ilande.co.uk _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users