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 _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
