I’ve imported several OSM datasets successfully to pgRouting but recently there’s one I can’t get around. There are no errors reported, no warning messages, but no tables are created in the database (I’m attaching a log at the end of the message). Is there any way I can check if something is going wrong, e.g. log file or similar?
Thank you,
Luís
$ osm2pgrouting -file “Luxembourg.osm” -conf “/usr/share/osm2pgrouting/mapconfig.xml” -dbname routing -user postgres -host localhost -passwd XXXXX
host=localhost user=postgres dbname=routing port=5432 password=system
connection success
Trying to load config file /usr/share/osm2pgrouting/mapconfig.xml
Trying to parse config
SE for
SE for
SE for
class name = motorway
class id = 101
class id = 101 name = motorway added to type name=highway
SE for
class name = motorway_link
class id = 102
class id = 102 name = motorway_link added to type name=highway
SE for
class name = motorway_junction
class id = 103
class id = 103 name = motorway_junction added to type name=highway
SE for
class name = trunk
class id = 104
class id = 104 name = trunk added to type name=highway
SE for
class name = trunk_link
class id = 105
class id = 105 name = trunk_link added to type name=highway
SE for
class name = primary
class id = 106
class id = 106 name = primary added to type name=highway
SE for
class name = primary_link
class id = 107
class id = 107 name = primary_link added to type name=highway
SE for
class name = secondary
class id = 108
class id = 108 name = secondary added to type name=highway
SE for
class name = tertiary
class id = 109
class id = 109 name = tertiary added to type name=highway
SE for
class name = residential
class id = 110
class id = 110 name = residential added to type name=highway
SE for
class name = living_street
class id = 111
class id = 111 name = living_street added to type name=highway
SE for
class name = service
class id = 112
class id = 112 name = service added to type name=highway
SE for
class name = track
class id = 113
class id = 113 name = track added to type name=highway
SE for
class name = pedestrian
class id = 114
class id = 114 name = pedestrian added to type name=highway
SE for
class name = services
class id = 115
class id = 115 name = services added to type name=highway
SE for
class name = bus_guideway
class id = 116
class id = 116 name = bus_guideway added to type name=highway
SE for
class name = path
class id = 117
class id = 117 name = path added to type name=highway
SE for
class name = cicleway
class id = 118
class id = 118 name = cicleway added to type name=highway
SE for
class name = footway
class id = 119
class id = 119 name = footway added to type name=highway
SE for
class name = bridleway
class id = 120
class id = 120 name = bridleway added to type name=highway
SE for
class name = byway
class id = 121
class id = 121 name = byway added to type name=highway
SE for
class name = steps
class id = 122
class id = 122 name = steps added to type name=highway
SE for
class name = unclassified
class id = 100
class id = 100 name = unclassified added to type name=highway
SE for
class name = road
class id = 100
class id = 100 name = road added to type name=highway
SE for
SE for
class name = lane
class id = 201
class id = 201 name = lane added to type name=cycleway
SE for
class name = track
class id = 202
class id = 202 name = track added to type name=cycleway
SE for
class name = opposite_lane
class id = 203
class id = 203 name = opposite_lane added to type name=cycleway
SE for
class name = opposite
class id = 204
class id = 204 name = opposite added to type name=cycleway
SE for
SE for
class name = grade1
class id = 301
class id = 301 name = grade1 added to type name=tracktype
SE for
class name = grade2
class id = 302
class id = 302 name = grade2 added to type name=tracktype
SE for
class name = grade3
class id = 303
class id = 303 name = grade3 added to type name=tracktype
SE for
class name = grade4
class id = 304
class id = 304 name = grade4 added to type name=tracktype
SE for
class name = grade5
class id = 305
class id = 305 name = grade5 added to type name=tracktype
SE for
SE for
class name = roundabout
class id = 401
class id = 401 name = roundabout added to type name=junction
Trying to load data
Trying to parse data
$ psql -h localhost -U postgres -W -d routing -c “\d”
Password for user postgres:
List of relations
Schema | Name | Type | Owner
--------±------------------±------±---------
public | geography_columns | view | postgres
public | geometry_columns | view | postgres
public | spatial_ref_sys | table | postgres
(3 rows)
On Thu, Aug 22, 2013 at 6:07 PM, Luís de Sousa <luis.a.de.sousa@gmail.com>wrote:
Dear all,
I've imported several OSM datasets successfully to pgRouting but recently
there's one I can't get around. There are no errors reported, no warning
messages, but no tables are created in the database (I'm attaching a log at
the end of the message). Is there any way I can check if something is
going wrong, e.g. log file or similar?
First of all, I did not receive an e-mail with your message, I can only see
it at Nabble.
I have installed osm2pgrouting from the Ubuntu repositories. No idea which
version it is, apparently there's no way to request that from the command
line.
Tweaking the arguments I found that using "127.0.0.1" instead of "localhost"
osm2pgrouting is able to finish processing this data set. Unfortunately it
leaves the ways table empty. This seems the same issue reported here [0].
With pgRouting 1.05 there were 3 packages: “regular” pgRouting and one for TSP and one for Driving Distance.
When you add the new Launchpad repository it tries to also upgrade pgRouting from old to new version. But the new version is not only one package and it contains the library files of DD and TSP, which don’t get removed.
I haven’t considered this use case when creating the packages and had to check how it is possible to remove these 2 packages as well with an upgrade.
Right now I have not enough time to look at this issue. I think a workaround would be to just uninstall these packages manually before with:
I think this only replaced one problem for another. I tried to recreate a
routing database to import again the data but the /usr/share/postlbs folder
no longer exists. Thinking that it might be missing due to packages lacking
I tried to reinstalled them, but I get errors with both (see below). So now
I have osm2pgrouting working but no pgrounting...
Luís
$ sudo apt-get install postgresql-9.1-pgrouting-tsp
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed
postgresql-9.1-pgrouting-tsp
0 upgraded, 1 newly installed, 0 to remove and 24 not upgraded.
Need to get 0 B/12.0 kB of archives.
After this operation, 76.8 kB of additional disk space will be used.
(Reading database ... 486495 files and directories currently installed.)
Unpacking postgresql-9.1-pgrouting-tsp (from
.../postgresql-9.1-pgrouting-tsp_1.05-1~precise2_amd64.deb) ...
dpkg: error processing
/var/cache/apt/archives/postgresql-9.1-pgrouting-tsp_1.05-1~precise2_amd64.deb
(--unpack):
trying to overwrite '/usr/lib/postgresql/9.1/lib/librouting_tsp.so', which
is also in package postgresql-9.1-pgrouting 2.0.0-rc1-ppa20~precise1
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-9.1-pgrouting-tsp_1.05-1~precise2_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
$ sudo apt-get install postgresql-9.1-pgrouting-dd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed
postgresql-9.1-pgrouting-dd
0 upgraded, 1 newly installed, 0 to remove and 24 not upgraded.
Need to get 0 B/69.6 kB of archives.
After this operation, 253 kB of additional disk space will be used.
(Reading database ... 486495 files and directories currently installed.)
Unpacking postgresql-9.1-pgrouting-dd (from
.../postgresql-9.1-pgrouting-dd_1.05-1~precise2_amd64.deb) ...
dpkg: error processing
/var/cache/apt/archives/postgresql-9.1-pgrouting-dd_1.05-1~precise2_amd64.deb
(--unpack):
trying to overwrite '/usr/lib/postgresql/9.1/lib/librouting_dd.so', which
is also in package postgresql-9.1-pgrouting 2.0.0-rc1-ppa20~precise1
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-9.1-pgrouting-dd_1.05-1~precise2_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
On Tue, Sep 3, 2013 at 12:24 AM, Luís de Sousa <luis.a.de.sousa@gmail.com>wrote:
Hi again Daniel,
I think this only replaced one problem for another. I tried to recreate a
routing database to import again the data but the /usr/share/postlbs folder
no longer exists. Thinking that it might be missing due to packages lacking
I tried to reinstalled them, but I get errors with both (see below). So now
I have osm2pgrouting working but no pgrounting...
Luís
Hi Luís,
You have installed the new pgRouting 2.0, which contains many changes and
there might be lot of outdated documentation now available in internet.
It probably helps to read the new documentation. It will answer most of
your questions: http://docs.pgrouting.org/
Daniel
$ sudo apt-get install postgresql-9.1-pgrouting-tsp
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed
postgresql-9.1-pgrouting-tsp
0 upgraded, 1 newly installed, 0 to remove and 24 not upgraded.
Need to get 0 B/12.0 kB of archives.
After this operation, 76.8 kB of additional disk space will be used.
(Reading database ... 486495 files and directories currently installed.)
Unpacking postgresql-9.1-pgrouting-tsp (from
.../postgresql-9.1-pgrouting-tsp_1.05-1~precise2_amd64.deb) ...
dpkg: error processing
/var/cache/apt/archives/postgresql-9.1-pgrouting-tsp_1.05-1~precise2_amd64.deb
(--unpack):
trying to overwrite '/usr/lib/postgresql/9.1/lib/librouting_tsp.so', which
is also in package postgresql-9.1-pgrouting 2.0.0-rc1-ppa20~precise1
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-9.1-pgrouting-tsp_1.05-1~precise2_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)
$ sudo apt-get install postgresql-9.1-pgrouting-dd
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following NEW packages will be installed
postgresql-9.1-pgrouting-dd
0 upgraded, 1 newly installed, 0 to remove and 24 not upgraded.
Need to get 0 B/69.6 kB of archives.
After this operation, 253 kB of additional disk space will be used.
(Reading database ... 486495 files and directories currently installed.)
Unpacking postgresql-9.1-pgrouting-dd (from
.../postgresql-9.1-pgrouting-dd_1.05-1~precise2_amd64.deb) ...
dpkg: error processing
/var/cache/apt/archives/postgresql-9.1-pgrouting-dd_1.05-1~precise2_amd64.deb
(--unpack):
trying to overwrite '/usr/lib/postgresql/9.1/lib/librouting_dd.so', which
is also in package postgresql-9.1-pgrouting 2.0.0-rc1-ppa20~precise1
Errors were encountered while processing:
/var/cache/apt/archives/postgresql-9.1-pgrouting-dd_1.05-1~precise2_amd64.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)