Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm working on a postgreSQL ,postGIS and pgRouting project on Windows 7
I need to work on a stable version (no time for risks), and I can see that many people are asking the same question many places..
I think because there is not a clear instruction about the compatible and stable versions anywhere, so we (Win-pgRouting beginners) would appreciate a complete answer from senior users..

Here are the tools I would like to use:
PostgreSQL 8.4
postGIS ??
pgRouting ??
OpenLayers ??
GeoServer ??
osm2po ??

Here are some facts I found on during my search about stable versions compatible with pgRouting
1) pgRouting on postgreSQL 9 is not a stable version (it is in beta form).

2) Expert users confirming that version 8 is used by most of them who are working on the collection of tools that I'm interested in…

3)Problems with the new version collections…

4)This is a pgRouting4Windows mail list response, it is written couple of days ago it is stating explicitly by the Win pgRouting binaries' developers that it does not work properly with PostgreSQL 9 and they are at this moment forming a group of developers who are willing to build a stable version

From your experience using this collection of tools, what versions do you suggest that I should use? I installed postgreSQL8.4, but I’m not sure which compatible versions I should install for postGIS and pgRouting and if you have any suggestions for QGIS ,OpenLayers and osm2po, because I'm new to the area so I'm not sure if compatibility even matters for some of those tools,

I appreciate your support,

share|improve this question
@AndreSilva - I think she is trying to build her software suite around PGRouting, and wants to make sure the versions she chooses are compatible with it. – Get Spatial Apr 25 '13 at 1:26
Your prior question strongly suggested that the real constraint was that you wanted to know what Pg, PostGIS, etc versions worked best with the current PgRouting. No? – Craig Ringer Apr 25 '13 at 3:12
Thanks all for your replays. If that helps, I'm trying to build a web-based road network map on PostgreSQL; where users can ask for the shortest path from src to dist. Then the user get it displayed along with the estimate time required to get there + if the road has an incident then the impact time is added to the estimate time to get an actual time. Dear Craig Ringer, yes you are right, this is my question.. – user17476 Apr 25 '13 at 4:39
up vote 1 down vote accepted

I can confirm that the following setup works for me on Win7, but I'm only running the system for experimental purposes!

PostgreSQL 8.4 with

select PostGIS_full_version()
"POSTGIS="1.4.2" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21 August 2008" USE_STATS" for Windows as listed on

QGIS version doesn't really matter. QGIS 1.8 will do.

I've successfully adjusted the instructions at to work with our in-house routing webservice but haven't tried with pgRouting.

share|improve this answer
Dear underdark, thanks for answering my question, I installed them, but I did not test pgRouting yet.. thanks again.. – user17476 Apr 27 '13 at 19:04

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.