# pgRouting Manual (2.1.0)

## Installation

This is a basic guide to download and install pgRouting.

Note

additional notes can be found in Installation Notes

## Download

Binary packages are provided for the current version on the following platforms:

### Windows

Winnie Bot Builds:

- Winnie PostgreSQL 9.2-9.5 32-bit/64-bit

Production Builds:

- Production builds are part of the Spatial Extensions/PostGIS Bundle available via Application StackBuilder
- Can also get PostGIS Bundle from

### Ubuntu/Debian

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.

### RHEL/CentOS/Fedora

- Fedora RPM’s: https://admin.fedoraproject.org/pkgdb/acls/name/pgRouting

### FreeBSD

pgRouting can be installed via ports:

    cd /usr/ports/databases/pgRouting
    make install clean

### OS X

- Homebrew

    brew install pgrouting

### Source Package

You can find all the pgRouting Releases:

https://github.com/pgRouting/pgrouting/releases

See Build Guide to build the binaries from the source.

### Using Git

Git protocol (read-only):

    git clone git://github.com/pgRouting/pgrouting.git

HTTPS protocol (read-only):

    git clone https://github.com/pgRouting/pgrouting.git

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";