Opened 10 years ago

Closed 6 years ago

#2438 closed defect (invalid)

osm2pgsql 900913.sql failed to parse

Reported by: mdiener Owned by: jburgess777@…
Priority: major Milestone:
Component: osm2pgsql Version:
Keywords: Cc:

Description

mdiener@nb01:~/Dev/osm2pgsql$ ./osm2pgsql -d gis -U mdiener -W * -H localhost -P 5432 -l -c /home/mdiener/Geo_data/austria.osm11112009.bz2 osm2pgsql SVN version 0.69-18551

Password:
Using projection SRS 4326 (Latlong)
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=10000000

Reading in file: 900913.sql
Entity: line 1: parser error : Document is empty
INSERT INTO spatial_ref_sys (srid, auth_name, auth_srid, srtext, proj4text)VALUE
900913.sql : failed to parse
Error occurred, cleaning up

Change History (4)

comment:1 Changed 10 years ago by Tom Hughes

Owner: changed from Tom Hughes to jburgess777@…

comment:2 Changed 10 years ago by jburgess777@…

Did you really use that '*'? If so, that is your problem, the shell is expanding that to all files in the directory.

I suspect you just want:

./osm2pgsql -d gis -U mdiener -W -H localhost -P 5432 -l -c /home/mdiener/Geo_data/austria.osm11112009.bz2

On most unix systems you can drop the -H & -P options since it will default to contacting the server on localhost anyway. If mdiener is your username and we remove all the other parameters which are the defaults then this line should be all you need:

./osm2pgsql -l /home/mdiener/Geo_data/austria.osm11112009.bz2

Are you sure you want to import the data as latlong? If you are intending to use this with the default mapnik style sheet then you'll want to use the default (900913) projection.

comment:3 Changed 8 years ago by Tom Hughes

Component: utilsosm2pgsql

comment:4 Changed 6 years ago by amm

Resolution: invalid
Status: newclosed

Closing as it is out of date, and possibly was never a bug in the first place

Note: See TracTickets for help on using tickets.