Symbiatch - maailma on rikki

PostGIS 1.5.2SVN for PostgreSQL 9.0 Win64

23.09.2010 21.26 - ohjelmointi 

Binaries for PostGIS x64

Since I'm an eager PostgreSQL and PostGIS user and I'm sure I'm not the only one interested in using these in 64bit now that it's possible on Windows, I thought I'd put the PostGIS binaries up for grabs if someone needs them. PostGIS developers will have files available for Win32 PostgreSQL 9.0 soon (now?), but they won't distribute 64bit. So here you have them. I hope all the needed files are included, do tell me if they aren't.

Copy the postgis-1.5.dll to PostgreSQL's lib folder and the other files to bin folder. Then just run the installation scripts from PostGIS distribution (not included) and you're all set.

Note! I have not run any thorough regression tests on these. They are compiled from the SVN sources (r6009 r6029) and I've only modified a couple of places to get them to compile (read more below). I have run my own applications on them, so at least there aren't any immediate showstoppers with them. But as I said, no guarantees! I hope I'll have time to run tests on them someday.

Compilation and Whining

I really can't understand why PostGIS developers still want to compile the whole stuff using msys/mingw and that kind of stuff. We have Visual C++ (yes, the compiler is available for free), everything compiles with it and you don't have to whine about how hard it is to compile stuff for Windows because it's not GNU. Just to give some hints: I have never compiled GEOS, PROJ, PostGIS etc for any platform. Still I had Visual Studio solutions done for the whole stuff in under 30 minutes. It's not hard, really! It's only hard if you insist in doing stuff your way and not the way it's supposed to be done.

So, the binaries are compiled with the newest Visual C++ compiler and optimized with the default release settings. I had to change an initialization of two arrays (there is a notice in the source that it's not nice to do it as they've done) and change some includes to get things rolling.

Binaries for PostGIS 1.5.2SVN for PostgreSQL 9.0 Windows x64

28th Sep: updated to r6029

And thank you for the PostGIS authors for clarifying my whinings :) And especially for creating and maintaining the whole PostGIS, which I love!



Nicklas Avén (anon, 28.09.2010 13.58)

Nice :-)
I have not tried it since I don't have any 64-bit windiws installation. Have you put the changes you had to do in some place to find?

Tim Martin (anon, 20.10.2010 12.14)


This would be very useful, however I do not understand the line

"Then just run the installation scripts from PostGIS distribution (not included) and you're all set."

how can i go about this, I am more used to using the .exe so any help would be very useful


David (anon, 18.11.2010 18.43)

I would also appreciate it if you could give us some extra help on how to exactly install the binaries on a 64bit windows machine with Postgesql 9.0.
Many thanks!!!

Christian (anon, 19.02.2011 11.53)

Thank you for compiling PostGIS.

When I start the script after copying the files, I get a bunch of errors:

c:\Program Files\PostgreSQL\9.0>makepostgisdb.bat

c:\Program Files\PostgreSQL\9.0>set PGPORT=5433

c:\Program Files\PostgreSQL\9.0>set PGHOST=localhost

c:\Program Files\PostgreSQL\9.0>set PGUSER=postgres

c:\Program Files\PostgreSQL\9.0>set PGPASSWORD=xxx

c:\Program Files\PostgreSQL\9.0>set THEDB=template_postgis15

c:\Program Files\PostgreSQL\9.0>set PGBIN=C:\Programme\PostgreSQL\9.0\bin\

c:\Program Files\PostgreSQL\9.0>"C:\Programme\PostgreSQL\9.0\bin\\psql" -c "CREATE DATABASE templat

c:\Program Files\PostgreSQL\9.0>"C:\Programme\PostgreSQL\9.0\bin\\psql" -d "template_postgis15" -c
FEHLER: Sprache »plpgsql« existiert bereits

c:\Program Files\PostgreSQL\9.0>"C:\Programme\PostgreSQL\9.0\bin\\psql" -d "template_postgis15" -f
psql:share/contrib/postgis-1.5/postgis.sql:58: FEHLER: konnte Bibliothek »C:/Program Files/Postgre
SQL/9.0/lib/postgis-1.5.dll« nicht laden: unknown error 126
psql:share/contrib/postgis-1.5/postgis.sql:64: FEHLER: aktuelle Transaktion wurde abgebrochen, Befe
hle werden bis zum Ende der Transaktion ignoriert
psql:share/contrib/postgis-1.5/postgis.sql:69: FEHLER: aktuelle Transaktion wurde abgebrochen, Befe

Seuthberg (anon, 25.11.2011 11.54) kotisivu

I do always receive "ERROR: could not load library >>C:/Program Files/PostgreSQL/9.1/lib/postgis.dll<<: unkown error 127" when he tries to create the funktions.
Any ideas?  |  Omat jutut  |  Muiden jutut  |  Kategoriat  |  kirjaudu