[GIS] postgis not valid win 32 application

postgis-2.2postgresqlwindows 8

I'm trying to setup Postgres 9.5 on my local machine x64 based win 8.

I've downloaded postgresql-9.5.1-1-windows.exe and also downloaded postgis-bundle-pg95x64-setup-2.2.2-1.exe

Postgres runs fine, but when trying to install postgis at the end of the instalation (when installer is attempting to install sample database) I get this error:

ERROR: could not load library "C:/PostgreSQLx86/9.5/lib/postgis-2.2.dll": %1 is not a valid Win32 application.

I've tried with the x64 and x32 versions also as you might notice i tried to install it on a non-spaces path PostgreSQLx86.

Still no luck.

Anyone can help me out ?

Best Answer

I sounds like you posibbly have a mix of 32 bit and a 64 bit versions of PostGres and PostGIS that are not mutually compatible with each other.

I find that the simplest way of installing Postgres with Postgis on Windows is to use the Enterprise DB installer. Using this install tool it is a very simple matter to get it all up and running. You can also easily add components after the install using the Enterprise DB stack builder tool.

Related Solutions

Python Installation – Installing libspatialindex on Windows 8

Not really sure but libspatialindex is only a C library (low level).

You should just need to use the Rtree Windows installer, a Python package using libspatialindex on the top.

In fact, since we answered, the install process has changed. You need to get a remote URL to a file ending with .whl (for "wheel", a new Python packaging way to ease installation) or you can download the file and install from it.

Then, you will do from command line:

# Install from remote ressource
pip install http://www.lfd.uci.edu/~gohlke/pythonlibs/djcobkfp/Rtree-0.8.2-cp27-cp27m-win_amd64.whl
# Or for local downloaded file
pip install Rtree-0.8.2-cp27-cp27m-win_amd64.whl

We know what we are installing because of file name convention:

Rtree-0.8.2 = Rtree version 0.8.2
cp27-cp27m = Version of Python = 2.7
win_amd64 = Windows 64 bits architecture

For installation, you can also use this page from official docs.

[GIS] PostgreSQL 9.4.7: PostGIS 2.2.1 via Stackbuilder Checksum issue

Cause for this must have been an unstable internet connection (hotspot via Smartphone). One should not try to install various things from the internet (eg. OSGeo4w etc.) at the same time over a weak internet connection. Patience is required here!

Second issue went away with reboot and reconnect to the PostgreSQL Database Server. No big deal at all.

Best Answer

Related Solutions

Python Installation – Installing libspatialindex on Windows 8

[GIS] PostgreSQL 9.4.7: PostGIS 2.2.1 via Stackbuilder Checksum issue

Related Question