Installation

Table of Contents

Instructions for downloading and installing binaries for different Operative systems instructions and additional notes and corrections not included in this documentation can be found in Installation wiki

To use pgRouting postGIS needs to be installed, please read the information about installation in this Install Guide

Short Version

Extracting the tar ball 

tar xvfz pgrouting-3.2.2.tar.gz
cd pgrouting-3.2.2

To compile assuming you have all the dependencies in your search path: 

mkdir build
cd build
cmake  ..
make
sudo make install

Once pgRouting is installed, it needs to be enabled in each individual database you want to use it in. 

createdb routing
psql routing -c 'CREATE EXTENSION PostGIS'
psql routing -c 'CREATE EXTENSION pgRouting'

Get the sources

The pgRouting latest release can be found in https://github.com/pgRouting/pgrouting/releases/latest

wget

To download this release: 

wget -O pgrouting-3.2.2.tar.gz https://github.com/pgRouting/pgrouting/archive/v3.2.2.tar.gz

Goto Short Version to the extract and compile instructions.

git

To download the repository 

git clone git://github.com/pgRouting/pgrouting.git
cd pgrouting
git checkout v3.2.2

Goto Short Version to the compile instructions (there is no tar ball).

Enabling and upgrading in the database

Enabling the database

pgRouting is an extension and depends on postGIS. Enabling postGIS before enabling pgRouting in the database 

CREATE EXTENSION postgis;
CREATE EXTENSION pgrouting;

Upgrading the database

To upgrade pgRouting in the database to version 3.2.2 use the following command: 

ALTER EXTENSION pgrouting UPDATE TO "3.2.2";

More information can be found in https://www.postgresql.org/docs/current/sql-createextension.html

Dependencies

Compilation Dependencies

To be able to compile pgRouting, make sure that the following dependencies are met:

  • C and C++0x compilers * Compiling with Boost 1.56 up to Boost 1.74 requires C++ Compiler with C++03 or C++11 standard support * Compiling with Boost 1.75 requires C++ Compiler with C++14 standard support

  • Postgresql version = Supported versions by PostgreSQL

  • The Boost Graph Library (BGL). Version >= 1.56

  • CMake >= 3.2

optional dependencies

For user’s documentation

  • Sphinx >= 1.1

  • Latex

For developer’s documentation

  • Doxygen >= 1.7

For testing

  • pgtap

  • pg_prove

For using:

  • PostGIS version >= 2.2

Example: Installing dependencies on linux

Installing the compilation dependencies

Database dependencies 

sudo apt-get install
    postgresql-10 \
    postgresql-server-dev-10 \
    postgresql-10-postgis

Build dependencies 

sudo apt-get install
    cmake \
    g++ \
    libboost-graph-dev

Optional dependencies

For documentation and testing 

sudo apt-get install -y python-sphinx \
    texlive \
    doxygen \
    libtap-parser-sourcehandler-pgtap-perl \
    postgresql-10-pgtap

Configuring

pgRouting uses the cmake system to do the configuration.

The build directory is different from the source directory

Create the build directory 

$ mkdir build

Configurable variables

To see the variables that can be configured 

$ cd build
$ cmake -L ..

Configuring The Documentation

Most of the effort of the documentation has being on the HTML files. Some variables for the documentation:

Variable

Default

Comment

WITH_DOC

BOOL=OFF

Turn on/off building the documentation

BUILD_HTML

BOOL=ON

If ON, turn on/off building HTML for user’s documentation

BUILD_DOXY

BOOL=ON

If ON, turn on/off building HTML for developer’s documentation

BUILD_LATEX

BOOL=OFF

If ON, turn on/off building PDF

BUILD_MAN

BOOL=OFF

If ON, turn on/off building MAN pages

DOC_USE_BOOTSTRAP

BOOL=OFF

If ON, use sphinx-bootstrap for HTML pages of the users documentation

Configuring with documentation 

$ cmake -DWITH_DOC=ON ..

Note

Most of the effort of the documentation has being on the html files.

Building

Using make to build the code and the documentation

The following instructions start from path/to/pgrouting/build 

$ make          # build the code but not the documentation
$ make doc      # build only the documentation
$ make all doc  # build both the code and the documentation

We have tested on several platforms, For installing or reinstalling all the steps are needed.

Warning

The sql signatures are configured and build in the cmake command.

MinGW on Windows 

$ mkdir build
$ cd build
$ cmake -G"MSYS Makefiles" ..
$ make
$ make install

Linux

The following instructions start from path/to/pgrouting 

mkdir build
cd build
cmake  ..
make
sudo make install

When the configuration changes: 

rm -rf build

and start the build process as mentioned above.

Testing

Currently there is no make test and testing is done as follows

The following instructions start from path/to/pgrouting/ 

tools/testers/doc_queries_generator.pl
createdb  -U  ___pgr___test___
sh ./tools/testers/pg_prove_tests.sh 
dropdb  -U  ___pgr___test___

See Also

Indices and tables