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

[Lucas Fairchild-Madar]

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
> *********************************************
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20160401/8aac7cf8/attachment.html>