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

[Mark Cave-Ayland]

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