[OSM-newbies] Unable to update PostgreSQL database with changesets

Poul Møller Hansen freebsd at pbnet.dk
Mon Aug 9 14:53:40 BST 2010


I have successfully imported planet data in a PostgreSQL database with 
this command
$ ./osm2pgsql -S default.style -s -d gis -C 4096 ~/planet-100512.osm.bz2

Now I'm trying to update the database with the changesets released since 
my planet version,
but nothing seems to be imported, as the total number of rows in the 
database are unchanged

The output of the job is here:

$ ./osm2pgsql -v -S default.style --append -s -d gis -C 4096 
~/changesets-100526.osm.bz2 -e6 -o ../expired_tiles/expire.list
osm2pgsql SVN version 0.69-22609

Using projection SRS 900913 (Spherical Mercator)
Setting up table: planet_osm_point
NOTICE:  table "planet_osm_point_tmp" does not exist, skipping
Setting up table: planet_osm_line
NOTICE:  table "planet_osm_line_tmp" does not exist, skipping
Setting up table: planet_osm_polygon
NOTICE:  table "planet_osm_polygon_tmp" does not exist, skipping
Setting up table: planet_osm_roads
NOTICE:  table "planet_osm_roads_tmp" does not exist, skipping
Mid: pgsql, scale=100, cache=4096MB, maxblocks=524289*8192
Setting up table: planet_osm_nodes
Setting up table: planet_osm_ways
Setting up table: planet_osm_rels

Reading in file: /home/pmh/changesets-100526.osm.bz2
Processing: Node(0k) Way(0k) Relation(0k)
Going over pending ways


Going over pending relations

node cache: stored: 0(-nan%), storage efficiency: -nan%, hit rate: -nan%
Stopping table: planet_osm_nodes
Committing transaction for planet_osm_point
Committing transaction for planet_osm_line
Committing transaction for planet_osm_polygon
Committing transaction for planet_osm_roads
Stopping table: planet_osm_ways
Completed planet_osm_point
Completed planet_osm_roads
Stopped table: planet_osm_ways
Completed planet_osm_polygon
Stopped table: planet_osm_nodes
Stopping table: planet_osm_rels
Completed planet_osm_line

Any hint on what I'm doing wrong ?

Thanks,
  Poul




More information about the newbies mailing list