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

[John Callahan]

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, <feurbano at 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120329/c942b59f/attachment.html>