I had that problem once. It was related to a missing (or outdated) libxml2-2.dll in the /bin folder. I would stop the postgres service and try manually recopying all of the files to their appropriate locations.
- John On Thu, Mar 29, 2012 at 6:25 AM, <feurb...@clix.pt> wrote: > 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 >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
