[Live-demo] pgrouting converter fail

[Hamish]

Brian Hamlin wrote:
> > I suspect the host= portion of the connection string, but have no
> > proof of that

Daniel wrote:
> Oh, maybe the host name could be an answer. Good idea!I remember that I
> once couldn't connect with localhost but 127.0.0.1 was OK ... or the
> other way round. This might depend on the pg_hba.conf settings.
>
> Currently I don't specify host name, so it takes 127.0.0.1 as default
> value. Maybe it works when host is set as "localhost".It would then be
> osm2pgrouting -file "$TMP/sampledata.osm" \
>   -conf "/usr/share/osm2pgrouting/mapconfig.xml" \
>   -dbname $OSM_DB \
>    -host localhost \
>    -user $USER_NAME \
>    -clean 


bingo! now it works in my test VM. it takes a few minutes to run but is
no worse than 5 minutes or so. pity there's no --quiet flag like psql has.

I can now connect, load, and query the pgrouting PostGIS database in QGIS.


nice work guys,
Hamish