Postgis issue installing under win64 with Postgres 9.5.2

classic Classic list List threaded Threaded
10 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgis issue installing under win64 with Postgres 9.5.2

Lucas Fairchild-Madar
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/.

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 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Stefano Iacovella
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 <[hidden email]>:
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/.

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 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Regina Obe

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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email]>:

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/.

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 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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Lucas Fairchild-Madar
In reply to this post by 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" <[hidden email]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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Regina Obe

The only other thing I can think of that could cause the problem is a dependency in GDAL.

 

For example EDB does ship libeasy32.dll and ssleasy32.dll and I made sure in prior versions to use a version of curl that would be compatible with what they shipped.

 

I suppose that might have changed.

 

If that is the issue, then the postgis-2.2.dll should be fine since it would only have a libxml dependency.

 

Are you able to install the postgis.sql file in contrib/postgis-2.2 folder okay.  If so then that would point at a libgdal dependency issue.

 

I'll try to do a fresh install of PostgreSQL 9.5.2  and install of PostGIS 2.2.1  to see if I run into any issues.

 

Thanks,

Regina

 

From: postgis-users [mailto:[hidden email]] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: [hidden email]
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" <[hidden email]> 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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Regina Obe

Okay I seem to be having problems getting the new PostgreSQL 9.5.2 64-bit installed on my windows 2012 r2 64-bit box (haven't even gotten to PostGIS install).  Granted this box already has 9.4, but I've never had issues running multiple versions on same box  if they run on different ports and have another server running 9.4.something and 9.5.1 fine  together.

 

On 9.5.2 64-bit after it completes – I get this error I've never seen before:

 

 

Did you by chance get any errors installing PostgreSQL 9.5.2?

 

Thanks,

Regina

 

From: postgis-users [mailto:[hidden email]] On Behalf Of Regina Obe
Sent: Friday, April 01, 2016 8:36 PM
To: 'PostGIS Users Discussion' <[hidden email]>
Subject: Re: [postgis-users] Postgis issue installing under win64 with Postgres 9.5.2

 

The only other thing I can think of that could cause the problem is a dependency in GDAL.

 

For example EDB does ship libeasy32.dll and ssleasy32.dll and I made sure in prior versions to use a version of curl that would be compatible with what they shipped.

 

I suppose that might have changed.

 

If that is the issue, then the postgis-2.2.dll should be fine since it would only have a libxml dependency.

 

Are you able to install the postgis.sql file in contrib/postgis-2.2 folder okay.  If so then that would point at a libgdal dependency issue.

 

I'll try to do a fresh install of PostgreSQL 9.5.2  and install of PostGIS 2.2.1  to see if I run into any issues.

 

Thanks,

Regina

 

From: postgis-users [[hidden email]] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: [hidden email]
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" <[hidden email]> 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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Regina Obe
In reply to this post by Lucas Fairchild-Madar

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:[hidden email]] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: [hidden email]
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" <[hidden email]> 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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Regina Obe

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:[hidden email]] On Behalf Of Regina Obe
Sent: Friday, April 01, 2016 9:10 PM
To: 'PostGIS Users Discussion' <[hidden email]>
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 [[hidden email]] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: [hidden email]
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" <[hidden email]> 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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Regina Obe

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:[hidden email]] On Behalf Of Regina Obe
Sent: Friday, April 01, 2016 9:34 PM
To: 'PostGIS Users Discussion' <[hidden email]>
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 [[hidden email]] On Behalf Of Regina Obe
Sent: Friday, April 01, 2016 9:10 PM
To: 'PostGIS Users Discussion' <[hidden email]>
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 [[hidden email]] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: [hidden email]
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" <[hidden email]> 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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users
Reply | Threaded
Open this post in threaded view
|

Re: Postgis issue installing under win64 with Postgres 9.5.2

Lucas Fairchild-Madar
Thank you so much for your work on this!

On Sat, Apr 2, 2016 at 10:38 AM, Regina Obe <[hidden email]> 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:[hidden email]] On Behalf Of Regina Obe
Sent: Friday, April 01, 2016 9:34 PM


To: 'PostGIS Users Discussion' <[hidden email]>
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 [[hidden email]] On Behalf Of Regina Obe
Sent: Friday, April 01, 2016 9:10 PM
To: 'PostGIS Users Discussion' <[hidden email]>
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 [[hidden email]] On Behalf Of Lucas Fairchild-Madar
Sent: Friday, April 01, 2016 7:40 PM
To: [hidden email]
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" <[hidden email]> 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:[hidden email]] On Behalf Of Stefano Iacovella
Sent: Friday, April 01, 2016 3:49 AM
To: PostGIS Users Discussion <[hidden email]>
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 <[hidden email] <mailto:[hidden email]> >:

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
[hidden email] <mailto:[hidden email]>
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
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users

------------------------------

End of postgis-users Digest, Vol 170, Issue 1
*********************************************

 


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users


_______________________________________________
postgis-users mailing list
[hidden email]
http://lists.osgeo.org/mailman/listinfo/postgis-users