osm2pqsql data loading issue

Question

Hi All,

I've tried to load planet-latest.osm.bz2 to postgresql DB using osm2pgsql tool. After unexpectable loading process interruption I reran osm2pgsql with --append flag, but got the following error:

Using projection SRS 900913 (Spherical Mercator) Setting up table: planet_osm_point Problem reading geometry information for table planet_osm_point - does it exist? Error occurred, cleaning up

Is there any way to continue loading process without data base rewriting?

Answer 1

1

Is it possible that there's a permission problem? Can you log in to the database with the same database user ID you instructed Osmosis to use and then do

select * from geometry_columns;

or does that result in an error message?

permanent link

answered 17 Jan '13, 14:09

Frederik Ramm ♦
82.5k●92●720●1273
accept rate: 23%

My OSM planet database owner is postgres. I logged in to the DB with postgres user ID and ran sql script you sent me. The geometry_columns table is empty. Table planet_osm_point doesn't exist in the DB.

(21 Jan '13, 14:17) jurasv

Answer 2

Osm2pgsql uses transactions in the initial phase of data loading. If during that phase an error occurs and osm2pgsql fails, postgresql rolls back the transaction entirely, leaving no trace of the failed import in the database.

Only once you reach the indexing phase is it possible (or desirable performance wise) to continue a failed import, although only by manually running all the steps osm2pgsql would run for you. In all other cases you have to or are better off starting the import from scratch.

osm2pqsql data loading issue

Follow this question

Related questions