[pgrouting-users] PgRouting sew-devel-2_0 : topology problem

Frédéric Bonifas fredericbonifas at gmail.com
Mon Mar 18 07:48:17 PDT 2013


I have built PgRouting from the sew-devel-2_0 branch. I am using
Postgis 2.0 and PostgreSql 9.1.8

I have created a database "routing" and created the postgis and
pgrouting extensions on it :
createdb routing
createlang plpgsql routing
psql -d routing -c "CREATE EXTENSION postgis;"
psql -d routing -c "CREATE EXTENSION pgrouting;"

I did not run the following lines because I assume that "CREATE
EXTENSION pgrouting;" does that but I may be wrong. Anyway, the
/usr/share/postlbs/ directory is empty.
psql -d routing -f /usr/share/postlbs/routing_core.sql
psql -d routing -f /usr/share/postlbs/routing_core_wrappers.sql
psql -d routing -f /usr/share/postlbs/routing_topology.sql

Then I run osm2pgrouting, from the georepublic ppa.
osm2pgrouting -file "data.osm" -conf
"/usr/share/osm2pgrouting/mapconfig.xml" -host localhost -dbname
routing -user postgres -clean

osm2pgrouting seems the end coorectly as I got :
size of streets: 41
size of splitted ways : 469

But while the "nodes" table is correctly filled, the "ways" and
"vertices_tmp" tables remain empty. I suspect this might be related to
routing_core.sql, routing_core_wrappers.sql and routing_topology.sql
that I did not run.
Does someone know what I am doing wrong ?

Thanks in advance

Frédéric Bonifas
+33672652807 skype:fredericbonifas

More information about the Pgrouting-users mailing list