[postgis-users] Installation problem with postgis-pg91-binaries-2.0.0beta4w32

[feurbano at clix.pt]

The file is there.
Thanks John for the suggestion, I finally solved my problem installing postgis 64
bit (with no problems).
Ferdi

On Qui Mar 29 11:25 , <feurbano at clix.pt> sent:

>Dear list,
>we are trying to install the latest available experimental binaries for windows
>(postgis-pg91-binaries-2.0.0beta4w32).
>We installed postgres 9.1 (32bit) and than run the installer file
>'makepostgisdb_using_extensions.bat' with the proper (hopefully) set.
>We get this error:
>
>"C:\Program Files (x86)\PostgreSQL\9.1\bin\psql"  -d "sam" -c "CREATE EXTENSION
>postgis;"
>ERROR:  could not load library "C:/Program Files
>(x86)/PostgreSQL/9.1/lib/postgis-2.0.dll": The specified module could not be found.
>
>We are installing on a Windows Server 2008 R2 64-bit and we have installed
>postgresql-9.1.3-1-windows.exe (32-bit)
>
>The file 'makepostgisdb_using_extensions.bat' look like this:
>REM this is an example of how to create a new db and spatially enable it using
>CREATE EXTENSION
>set PGPORT=5432
>set PGHOST=localhost
>set PGUSER=postgres
>set PGPASSWORD=***
>set THEDB=sam
>REM PGINSTALL=C:\Program Files\PostgreSQL\9.1
>set PGINSTALL=C:\Program Files (x86)\PostgreSQL\9.1
>set PGADMIN=%PGINSTALL%\pgAdmin III
>set PGBIN=%PGINSTALL%\bin\
>set PGLIB=%PGINSTALL%\lib\
>set POSTGISVER=2.0
>xcopy bin\*.* "%PGBIN%"
>xcopy /I /S bin\postgisgui\* "%PGBIN%\postgisgui"
>xcopy /I plugins.d "%PGADMIN%\plugins.d"
>xcopy lib\*.* "%PGLIB%"
>xcopy share\extension\*.* "%PGINSTALL%\share\extension"
>xcopy /I share\contrib\postgis-%POSTGISVER%
>"%PGINSTALL%\share\contrib\postgis-%POSTGISVER%"
>"%PGBIN%\psql"  -c "CREATE DATABASE %THEDB%"
>"%PGBIN%\psql"  -d "%THEDB%" -c "CREATE EXTENSION postgis;"
>"%PGBIN%\psql"  -d "%THEDB%" -c "CREATE EXTENSION postgis_topology;"
>
>REM Uncomment the below line if this is a template database
>REM "%PGBIN%\psql" -d "%THEDB%" -c "UPDATE pg_database SET datistemplate = true
>WHERE datname = '%THEDB%';GRANT ALL ON geometry_columns TO PUBLIC; GRANT ALL ON
>spatial_ref_sys TO PUBLIC"
>
>
>"C:/Program Files (x86)/PostgreSQL/9.1/lib/postgis-2.0.dll" is where it is
>supposed to be.
>Any suggestion?
>
>Thanks a lot
>
>Ferdinando
>
>
>