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, we'll need to add it 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 from http://docs.pgrouting.org/latest/en/sampledata.html.
This sample data consists of a small grid of streets in which any functions can be run.
Then, run the create table and data insert scripts available at the dataset website. You should ...