Ticket #2438 (closed defect: invalid)

Opened 4 years ago

Last modified 15 months ago

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

comment:1 Changed 4 years ago by TomH

  • Owner changed from tom@… to jburgess777@…

comment:2 Changed 4 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 3 years ago by TomH

  • Component changed from utils to osm2pgsql

comment:4 Changed 15 months ago by amm

  • Status changed from new to closed
  • Resolution set to invalid

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.