Hi Jinfu,<div><br></div><div>Look at the "Note" in the workshop: <a href="http://workshop.pgrouting.org/chapters/osm2pgrouting.html#run-osm2pgrouting">http://workshop.pgrouting.org/chapters/osm2pgrouting.html#run-osm2pgrouting</a></div>

<div>When you don't need to care about server security you can set the settings in pg_hba.conf to trust.</div><div><br></div><div>Daniel<br><br><div class="gmail_quote">On Wed, May 30, 2012 at 8:34 AM, Dave Potts <span dir="ltr"><<a href="mailto:dave.potts@pinan.co.uk" target="_blank">dave.potts@pinan.co.uk</a>></span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Hello,<br>
<br>
>From the text of the error message, it appears your having a problem<br>
connecting to your database, its not a pgroute package error but rather a<br>
postgres error.<br>
<br>
What happens if you try<br>
<br>
psql -d routing -U postgres<br>
<br>
This should connect directly to your database without using any of the<br>
routing software.<br>
<div><div class="h5"><br>
<br>
<br>
<br>
Jinfu Leng wrote:<br>
> Hello all,<br>
><br>
> I created the database "routing" from the "template_routing", and<br>
> downloaded the .osm file of London. But I got a problem when I was trying<br>
> yo import this .osm file to the database.<br>
><br>
> command:<br>
> "osm2pgrouting -file "London.osm" -conf<br>
> "/usr/share/osm2pgrouting/mapconfig.xml" -dbname routing -user postgres<br>
> -clean"<br>
> error message:<br>
> "connection failed"<br>
><br>
> Any ideas?<br>
><br>
> Thanks a advance.<br>
> Jinfu<br>
</div></div>> _______________________________________________<br>
> pgrouting-dev mailing list<br>
> <a href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a><br>
> <a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
><br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
--<br>
<br>
<br>
_______________________________________________<br>
pgrouting-dev mailing list<br>
<a href="mailto:pgrouting-dev@lists.osgeo.org">pgrouting-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/pgrouting-dev" target="_blank">http://lists.osgeo.org/mailman/listinfo/pgrouting-dev</a><br>
</font></span></blockquote></div><br><br clear="all"><div><br></div>-- <br><span style="font-family:arial,sans-serif;font-size:13px;border-collapse:collapse">Georepublic UG & Georepublic Japan<br>eMail: <a href="mailto:daniel.kastl@georepublic.de" style="color:rgb(66,99,171)" target="_blank">daniel.kastl@georepublic.de</a><br>

Web: <a href="http://georepublic.de/" style="color:rgb(66,99,171)" target="_blank">http://georepublic.de</a></span><br>
</div>