[postgis-users] Postgis issue installing under win64 with Postgres 9.5.2

Mon Apr 4 07:46:30 PDT 2016

Thank you so much for your work on this!

On Sat, Apr 2, 2016 at 10:38 AM, Regina Obe <lr at pcorp.us> wrote:

> Update to my update.
>
>
>
> I recompiled the curl support with same version of OpenSSL shipped with
> PostgreSQL 9.5.2 and that seems to install okay.
>
>
>
> We'll do more tests before we repackage PostGIS 2.2.2 and also have to
> test the 32-bit.
>
>
>
> So disregard last link I gave and use this one instead.
>
>
>
>
> http://winnie.postgis.net/download/windows/pg95/buildbot/libcurl7.48withsslx64.zip
>
>
>
> The zip should also work on 9.3 x64 and 9.4x64 for those that are having
> the same issue on there.  Haven't checked those out to see if they suffer
> the same problem
>
>
>
>
>
> Thanks for reporting,
>
> Regina
>
> http://www.postgis.us
>
> http://postgis.net
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] *On
> Behalf Of *Regina Obe
> *Sent:* Friday, April 01, 2016 9:34 PM
>
> *To:* 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> *Subject:* Re: [postgis-users] Postgis issue installing under win64 with
> Postgres 9.5.2
>
>
>
> Okay more news.  I think I've pretty much confirmed the libeasy32.dll and
> ssleasy32.dll are the culprit.  Because if I replace the libcurl-4.dll with
> one that does not include SSL support (meaning it has no dependency on
> those two files),
>
>
>
> CREATE EXTENSION postgis;
>
>
>
> Works fine on the 9.5.2.
>
>
>
> So if you are in a rush (this goes for the person who was having issue
> with 9.4, as I expect has the same issue).
>
>
>
>
>
> I have put a zip file on Winnie (will work for 9.4 as well since the 9.4 I
> ship with the same GDAL library as 9.5)
>
>
>
>
>
>
> http://winnie.postgis.net/download/windows/pg95/buildbot/libcurl-no-ssl_forPostgreSQ9.5.2users.zip
>
>
>
> This is a curl binary compiled without SSL support so doesn't rely on
> ssleasy32.dll and libeasy32.dll
>
>
>
> Replace the one you have currently with this one.
>
>
>
> I still need to ship one with SSL support after I recompile – since main
> reason I bother shipping SSL is because CURL is also used by WWW_FDW which
> I use heavily with SSL.
>
>
>
> I think for most PostGIS users (except possibly for OGR_FDW users, the SSL
> support is not needed)
>
>
>
>
>
> Thanks,
>
> Regina
>
>
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org
> <postgis-users-bounces at lists.osgeo.org>] *On Behalf Of *Regina Obe
> *Sent:* Friday, April 01, 2016 9:10 PM
> *To:* 'PostGIS Users Discussion' <postgis-users at lists.osgeo.org>
> *Subject:* Re: [postgis-users] Postgis issue installing under win64 with
> Postgres 9.5.2
>
>
>
> Okay I think it’s a change they made in PostgreSQL 9.5.2 that is the
> culprit.
>
>
>
> I do see that they updated libeasy32.dll and ssleasy32.dll so I'm
> suspecting that might be it.  I will investigate.
>
>
>
> To test I used the EDB 9.5.1 binaries – installed a fresh put of PostGIS
> 2.2.2 in that on my Windows 7 64-bit
>
>
>
> Did
>
>
>
> CREATE EXTENSION postgis;
>
>
>
> Worked fine.
>
>
>
> Repeated the same exercise with the PostgreSQL 9.5.2 binaries and got the
> same error you did.
>
>
>
> ERROR:  could not load library
> "C:/ming64gcc48/projects/postgresql/rel/pgsqltest/lib/rtpostgis-2.2.dll":
> The specified procedure could not be found.
>
>
>
> So lesson here – stay away from the PostgreSQL 9.5.2  Windows (64-bit at
> least) if you are using PostGIS until I figure out what's up here and can
> package a new PostGIS 2.2.2 build that's compatible with 095.2
>
>
>
> Thanks,
>
> Regina
>
>
>
>
>
>
>
> *From:* postgis-users [mailto:postgis-users-bounces at lists.osgeo.org
> <postgis-users-bounces at lists.osgeo.org>] *On Behalf Of *Lucas
> Fairchild-Madar
> *Sent:* Friday, April 01, 2016 7:40 PM
> *To:* postgis-users at lists.osgeo.org
> *Subject:* Re: [postgis-users] Postgis issue installing under win64 with
> Postgres 9.5.2
>
>
>
> Sorry, this is 2012R2 Standard Edition, 64 bit.
>
> When I did an uninstall/reinstall between the winnie build and postgis
> build I uninstalled the entire postgres installation and installed a new
> one (keeping the data directory). There's not any information on this
> server yet.
>
> I tried the libxml2.dll to libxml2-2.dll trick with the same results.
>
> At no point were any 32 bit binaries used. Dependency walker (in static
> analysis mode) shows no 32 bit dependencies. The non-winnie build was for
> postgis-bundle-pg95x64-setup-2.2.1-1.exe.
>
> Is there any other information I can give you to help debug this issue? I
> will try to roll back to 9.5.1 at some point soon and see how that behaves.
>
> Thanks!
>
> Lucas
>
>
>
> On Fri, Apr 1, 2016 at 8:53 PM, "Regina Obe" <lr at pcorp.us> wrote:
>
>
> This is 2012 not 2012R2?  I don't think I have a 2012 only to test on but
> haven't had an issue with 2012r2 or windows 2008 variants.
>
>
>
> That said, I haven't upgraded to 9.5.2 yet (still 9.5.1) though that
> shouldn't matter.  I'll double check to make sure.
>
>
>
> The general culprit for this is the libxml2-2.dll
>
>
>
> For whatever reason you are using a PostgreSQL 32-bit and trying to use
> 64-bit PostGIS binaries or you are using PostgreSQL 64-bit and using
> PostGIS 32-bit binaries
>
>
>
> Reinstalling won't fix this since it won't replace files libxml2-2.dll if
> it see it already there snce sometimes EDB distributes it and sometimes
> they don't.  So you'd have to explicitly overwrite those.
>
> You can do so just copying libxml2.dll to libxml2-2.dll
>
>
>
> I would suggest giving that a try first.
>
>
>
> Hope that helps,
>
> Regina
>
>
>
>
>
>
>
> From: postgis-users [mailto:postgis-users-bounces at lists.osgeo.org] On
> Behalf Of Stefano Iacovella
> Sent: Friday, April 01, 2016 3:49 AM
> To: PostGIS Users Discussion <postgis-users at lists.osgeo.org>
> Subject: Re: [postgis-users] Postgis issue installing under win64 with
> Postgres 9.5.2
>
>
>
> I had exactly the same problem with a 9.3 PostgreSQL for windows x64.
>
>
>
>
> ---------------------------------------------------
> 41.95581N 12.52854E
>
>
> http://www.linkedin.com/in/stefanoiacovella
>
> http://twitter.com/#!/Iacovellas
>
>
>
> 2016-04-01 8:28 GMT+02:00 Lucas Fairchild-Madar <lucas.madar at gmail.com
> <mailto:lucas.madar at gmail.com> >:
>
> I'm trying to install postgis on a windows machine running windows server
> 2012 64 bit. This is a fresh install using the 9.5.2 release from
> EnterpriseDB and the 64 bit installer from
> download.osgeo.org/postgis/windows/pg95/ <
> http://download.osgeo.org/postgis/windows/pg95/> .
>
> I receive this error when running CREATE EXTENSION:
>
> ERROR:  could not load library "S:/PostgreSQL/9.5/lib/rtpostgis-2.2.dll":
> The specified procedure could not be found.
>
> I have also tried uninstalling and reinstalling the entire binary system
> and using the latest winnie build from
> winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip
> <
> http://winnie.postgis.net/download/windows/pg95/buildbot/postgis-pg95-binaries-2.2.2w64gcc48.zip>
> which has the same results.
>
> Just creating a function from rtpostgis-2.2.dll results in the same
> problem:
>
>
> db# CREATE OR REPLACE FUNCTION postgis_raster_lib_version()
>     RETURNS text AS '$libdir/rtpostgis-2.2', 'RASTER_lib_version'
>     LANGUAGE 'c' IMMUTABLE;
> ERROR:  could not load library "S:/PostgreSQL/9.5/lib/rtpostgis-2.2.dll":
> The specified procedure could not be found.
>
> I've verified the file is there and that the symbol RASTER_lib_version
> exists inside. Dependency walker shows no obvious problems although I am
> not an expert at using it.
>
> # select version();
>                            version
> -------------------------------------------------------------
>  PostgreSQL 9.5.2, compiled by Visual C++ build 1800, 64-bit
>
> Is it possible this is a new issue introduced with PG 9.5.2?
>
>
>
> Thanks!
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org <mailto:postgis-users at lists.osgeo.org>
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <
> http://lists.osgeo.org/pipermail/postgis-users/attachments/20160401/ef9d0d03/attachment-0001.html
> >
>
> ------------------------------
>
> Subject: Digest Footer
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
> ------------------------------
>
> End of postgis-users Digest, Vol 170, Issue 1
> *********************************************
>
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160404/0edd5798/attachment.html>