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