[postgis-users] Error enabling PostGIS extension

[Kevin Berger]

Hi,

 

We installed the 64-bit version of PostgreSQL database, version 9.2.3. We then downloaded and installed postgis-bundle-pg92x64-setup-2.1.8-1.exe. When we try to create a postgis extension in our PostgreSQL database, we get error:

 

Is there anything we can do to fix this?

 

Kevin

[Kevin Berger]

Hi,

 

We installed the 64-bit version of PostgreSQL database, version 9.2.3. We then downloaded and installed postgis-bundle-pg92x64-setup-2.1.8-1.exe. When we try to create a postgis extension in our PostgreSQL database, we get error:

[Kevin Berger]

[Paul Ramsey]

Follow the error, see if the referenced DLL exists where expected and/or if any dependencies of that DLL are missing, using http://www.dependencywalker.com/. If that seems too technical, offer to hire an expert, there's several on this forum I'm sure.

ATB,

P

_______________________________________________
postgis-users mailing list
postgi...@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users

[Regina Obe]

You need to upgrade your PostgreSQL 9.2 to higher than 9.2.3 – upgrade to latest micro for 9.2

 

The PostgreSQL group changed the api somewhere between 9.2.5 and 9.2.7, I forget.  So the PostGIS binaries on stackbuilder assume you are running a newer PostgreSQL 9.2 micro.

 

It's rare they make such a change in a micro release, but they had to and it broke a lot of old install packages, forcing packagers to build new ones.

 

Hope that helps,

Regina