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

[Andy Allan]

2010/8/9 Poul Møller Hansen <freebsd at pbnet.dk>:
> 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

[...]

> Any hint on what I'm doing wrong ?

The file changesets-100526.osm.bz2 is all the metadata about
changesets up to that point - when the changeset was opened, who
created it and suchlike. It doesn't contain any geographical data.

You want a diff file (either an interval diff, or preferably
replication diffs). Have a look at
http://wiki.openstreetmap.org/wiki/Minutely_Mapnik and the osmosis
documentation for handling replication diffs.

Cheers,
Andy