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

feurbano at clix.pt feurbano at clix.pt
Thu Mar 29 03:25:15 PDT 2012


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





More information about the postgis-users mailing list