Startup – Dijkstra routing

pgRouting is a separate extension used in addition to PostGIS, which is now available in the PostGIS bundle on the Application Stack Builder (recommended for Windows). It can also be downloaded and installed by DEB, RPM, and macOS X packages and Windows binaries available at http://pgrouting.org/download.html.

For macOS users, it is recommended that you use the source packages available on Git (https://github.com/pgRouting/pgrouting/releases), and use CMake, available at https://cmake.org/download/, to make the installation build.

Packages for Linux Ubuntu users can be found at http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS22UbuntuPGSQL95Apt.

Getting ready

pgRouting doesn't deal well with nondefault schemas, so before we begin, we will set the schema in our user preferences using the following command:

ALTER ROLE me SET search_path TO chp06,public;

Next, we need to add the pgrouting extension to our database. If PostGIS is not already installed on the database,...