[postgis-users] Installation problem on Windows Server 2008

[Paragon Corporation]

Ryan,
 
We tested them on  64-bit (windows 2008, 2008 R2, 2003, and 7) so we know it
works on all those.  Admittedly we were mostly focussed on 9.1 so we can't
be absolutely sure we tested the 9.0 on windows 2008 R2 (but we did on
windows 7 64-bit).  We were testing against the EnterpriseDb distributed
PostgreSQL's 64-bit so its possible ESRI compiled their own and they require
dependencies we left out since we assumed they were present because EDB
packages had them.
 
The most common culprit is the libxml2-2.dll   (though I thought we included
that one in our last packaging)
 
You should check dependency walker to see what dependencies you may be
missing.
 
http://dependencywalker.com/ (use the x64 one).
 
 
Keep in mind the dependencies are in the bin of your PostgreSQL install --
so you'll need to add that path in the dependency walker add path for it to
find them.
 
Also make sure the version of PostgreSQL you have is 64-bit. It's possible
the ESRI cd only comes with 32-bit in which case you should use the 32-bit
9.0 PostGIS 2.0. (even though you are running on a 64-bit OS).
 
You can do a 
 
SELECT version();
 
and it should have a 64-bit in there somewhere if you are using 64-bit
PostgreSQL.  
 
Let us know how it turns out.
 
Leo and Regina
http://www.postgis.us
 


  _____  

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Timmons,
Ryan P
Sent: Monday, May 14, 2012 5:53 PM
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Installation problem on Windows Server 2008



I am getting this error on the installation of Postgis 2.0.0 for Postgres
9.0 on a 64 bit windows server 2008 system, at the point where it tries to
make template_postgis_20:

 

psql:C:/CEMSA/PostgreSQL/9.0/share/contrib/postgis-2.0/postgis.sql:69:
ERROR:  could not load library
"C:/CEMSA/PostgreSQL/9.0/lib/postgis-2.0.dll": The specified module could
not be found.



I checked the path and postgis-2.0.dll is indeed there.  I have retried a
few times experimenting with permissions (even temporarily promoting the
"postgres" account to a machine administrator to make sure it can read
there), still getting same error.

 

My postgres version is 9.0.5.  We are aiming to eventually combine this with
ESRI's ArcGIS Server/ArcSDE so used the postgres installer from the ESRI CD.


 

I scanned the list archives after joining and found
http://postgis.refractions.net/pipermail/postgis-users/2012-May/033957.html
.  The "should work on Windows XP" makes me wonder if Server 2008 is not
supported?  The windows instructions
(http://postgis.refractions.net/download/windows/) talk about 32 vs. 64 bit,
but no mention of XP vs. 7 vs. Server etc.

 

Thanks in advance,

Ryan

 

Ryan Timmons

Research Scientist, O/A014S 

Control Systems & Information Sciences

Lockheed Martin SSC

Cell: 248-895-1935

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120514/e1d8373d/attachment.html>