[postgis-users] postgres 8.1 postgis 1.3.1 upgrade issues on win32

Stephen Woodbridge woodbri at swoodbridge.com
Sat Aug 25 09:08:34 PDT 2007


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



More information about the postgis-users mailing list