I’ve set up my PostgreSQL gis db correctly (fairly sure), and configured it for PostGIS, but I am getting these errors when executing a osm2pgql command (tried with multiple osm files) :
jrbaldwin-MacBook-Pro:~ jrbaldwin$ osm2pgsql -c -G -U jrbaldwin -d gis redhook.osm
osm2pgsql SVN version 0.70.5 (32bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table “planet_osm_point” does not exist, skipping
NOTICE: table “planet_osm_point_tmp” does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table “planet_osm_line” does not exist, skipping
NOTICE: table “planet_osm_line_tmp” does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table “planet_osm_polygon” does not exist, skipping
NOTICE: table “planet_osm_polygon_tmp” does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table “planet_osm_roads” does not exist, skipping
NOTICE: table “planet_osm_roads_tmp” does not exist, skipping
Mid: Ram, scale=100
Reading in file: redhook.osm
error while opening file redhook.osm
jrbaldwin-MacBook-Pro:~ jrbaldwin$ osm2pgsql -c -G -U jrbaldwin -d gis new-york.osm
osm2pgsql SVN version 0.70.5 (32bit id space)
Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE: table “planet_osm_point” does not exist, skipping
NOTICE: table “planet_osm_point_tmp” does not exist, skipping
Setting up table: planet_osm_line
NOTICE: table “planet_osm_line” does not exist, skipping
NOTICE: table “planet_osm_line_tmp” does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE: table “planet_osm_polygon” does not exist, skipping
NOTICE: table “planet_osm_polygon_tmp” does not exist, skipping
Setting up table: planet_osm_roads
NOTICE: table “planet_osm_roads” does not exist, skipping
NOTICE: table “planet_osm_roads_tmp” does not exist, skipping
Mid: Ram, scale=100
Reading in file: new-york.osm
error while opening file new-york.osm
//------//
What am I missing?