i was following this http://workshops.boundlessgeo.com/tutorial-routing/#preparing-data tutorial about building a routing application and thus im stuck in the step of preparing the data as to i dont know where to execute the ogr commands that it says there. attached is the picture of the step and in it is the commands im talking about.
hi to all those who'd encounter this problem. here is how i was able to answer it. at first i used this command
ogr2ogr -where "highway <> ''" -select 'name,highway,oneway,surface' -lco GEOMETRY_NAME=the_geom -lco FID=id -t_srs EPSG:3857 -f PostgreSQL PG:"dbname=routing user=postgres" -nln edges portland-me.osm-line.shp
but it seems that i needed to arrange it the right way and specify the file path and an adivce is to give enough permission to the user that you are using. and even after overcoming the problem posted here. i got stopped by two other errors till i was successful. when you get to those two errors, you can read this one Import a shapefile to postgis with ogr2ogr gives: Unable to open datasource
thus the final command i used is this
ogr2ogr -select name,highway,oneway,surface -where "highway <> ''" -f "PostgreSQL" "PG:host=localhost user=postgres dbname=routing password=password" "E:\paopao theis files not to be deleted\portland-me.osm-line.shp" -lco GEOMETRY_NAME=the_geom -lco FID=gid -lco PRECISION=no -nlt PROMOTE_TO_MULTI -nln edges -overwrite
im so sorry if its not really well explained. even i myself dont completely understand how i made it. it was just through trial and error. cheers everyone