[pgrouting-dev] Problems in Importing .osm to Database

[Jinfu Leng]

Hey Daniel, Dave,

Thanks. The problem is solved by settings the pg_hba.conf to trust.

But I got some error messages like:
"We DON'T need a way of type  and class
We need a way of type highway and class steps
We need a way of type highway and class footway
We need a way of type highway and class steps
We need a way of type highway and class footway"

Do these errors matter? Or I can ignore them and go to the next step?

Thanks again,
Jinfu

On Wed, May 30, 2012 at 10:44 PM, Daniel Kastl <daniel at georepublic.de>wrote:

> Hi Jinfu,
>
> Look at the "Note" in the workshop:
> http://workshop.pgrouting.org/chapters/osm2pgrouting.html#run-osm2pgrouting
> When you don't need to care about server security you can set the settings
> in pg_hba.conf to trust.
>
> Daniel
>
>
> On Wed, May 30, 2012 at 8:34 AM, Dave Potts <dave.potts at pinan.co.uk>wrote:
>
>> Hello,
>>
>> From the text of the error message, it appears your having a problem
>> connecting to your database, its not a pgroute package error but rather a
>> postgres error.
>>
>> What happens if you try
>>
>> psql -d routing -U postgres
>>
>> This should connect directly to your database without using any of the
>> routing software.
>>
>>
>>
>>
>> Jinfu Leng wrote:
>> > Hello all,
>> >
>> > I created the database "routing" from the "template_routing", and
>> > downloaded the .osm file of London. But I got a problem when I was
>> trying
>> > yo import this .osm file to the database.
>> >
>> > command:
>> > "osm2pgrouting -file "London.osm" -conf
>> > "/usr/share/osm2pgrouting/mapconfig.xml" -dbname routing -user postgres
>> > -clean"
>> > error message:
>> > "connection failed"
>> >
>> > Any ideas?
>> >
>> > Thanks a advance.
>> > Jinfu
>> > _______________________________________________
>> > pgrouting-dev mailing list
>> > pgrouting-dev at lists.osgeo.org
>> > http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>> >
>>
>>
>> --
>>
>>
>> _______________________________________________
>> pgrouting-dev mailing list
>> pgrouting-dev at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>>
>
>
>
> --
> Georepublic UG & Georepublic Japan
> eMail: daniel.kastl at georepublic.de
> Web: http://georepublic.de
>
> _______________________________________________
> pgrouting-dev mailing list
> pgrouting-dev at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/pgrouting-dev
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/pgrouting-dev/attachments/20120531/b0c7a832/attachment.html>