[postgis-users] EXTERNAL: Re: Installation problem on Windows Server 2008

[Timmons, Ryan P]

Thanks for your reply.   Libxml2-2.dll was there

"select version()" gives
"PostgreSQL 9.0.5, compiled by Visual C++ build 1500, 64-bit"

DependencyWalker illuminated but did not solve the problem.   It flagged the following things as missing:
IEShims.dll   (found in C:\Program Files\Internet Explorer)
msvcr90.dll     (found in the depths of the redistributable C++ installation)
libiconv-2.dll  (got by running the 9.1 installer and copying over)

After editing PATH appropriately, I still got the same error on the installer.  At this point here is what dependency walker says:

C:\windows\system32\SHLWAPI.DLL
Warning: At least one module has an unresolved import due to a missing export function in a delay-load dependent module.

However I don't think this should matter.  See 2nd item on http://www.dependencywalker.com/faq.html.  Also using DependencyWalker on the postgis DLL in the 9.1 directory gave the same problem - and that one worked.

Oh well.  It's something else wrong with the ESRI postgres version, downloading the latest 9.0 postgresql release and installing postgis-for-postgres9.0 over that worked fine as well.  I will worry about merging with ArcSDE at a later time.


Ryan Timmons
Research Scientist, O/A014S
Control Systems & Information Sciences
Lockheed Martin SSC
Cell: 248-895-1935

From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paragon Corporation
Sent: Monday, May 14, 2012 4:06 PM
To: 'PostGIS Users Discussion'
Subject: EXTERNAL: Re: [postgis-users] Installation problem on Windows Server 2008

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> [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<mailto: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/20120515/f324c373/attachment.html>