This is a basic guide to download and install pgRouting.
additional notes can be found in Installation Notes
Binary packages are provided for the current version on the following platforms:
Winnie Bot Builds:
- Production builds are part of the Spatial Extensions/PostGIS Bundle available via Application StackBuilder
- Can also get PostGIS Bundle from
Ubuntu packages are available in Launchpad repositories:
- stable https://launchpad.net/~georepublic/+archive/pgrouting
- unstable https://launchpad.net/~georepublic/+archive/pgrouting-unstable
# Add pgRouting launchpad repository ("stable" or "unstable") sudo add-apt-repository ppa:georepublic/pgrouting[-unstable] sudo apt-get update # Install pgRouting packages sudo apt-get install postgresql-9.1-pgrouting
Use UbuntuGIS-unstable PPA to install PostGIS 2.0.
pgRouting can be installed via ports:
cd /usr/ports/databases/pgRouting make install clean
brew install pgrouting
You can find all the pgRouting Releases:
See Build Guide to build the binaries from the source.
Installing in the database¶
pgRouting is an extension.
CREATE EXTENSION postgis; CREATE EXTENSION pgrouting;
Upgrading the database¶
To upgrade pgRouting to version 2.1.0 use the following command:
ALTER EXTENSION pgrouting UPDATE TO "2.1.0";