[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