pgRouting is a separate extension used in addition to PostGIS. Its download and installation is vastly simplified by DEB, RPM, and OS X packages and Windows binaries available at http://pgrouting.org/download.html.
pgRouting doesn't deal well with non-default schema, 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, we'll need to add that as an extension, as well:
--CREATE EXTENSION postgis; CREATE EXTENSION pgrouting;
We will start by loading a test dataset. You can get some really basic sample data ...