[OSM-dev] The same OSM server but locally available

[Timo Juhani Lindfors]

Emilie Laffray <emilie.laffray at gmail.com> writes:
> Plus you can even filtered it at Osmosis level if you want to.

I tried that in

http://lists.openstreetmap.org/pipermail/dev/2010-June/019570.html

but failed with things like

Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "current_way_nodes" violates foreign key constraint "current_way_nodes_node_id_fkey"

since the replication data (*.osc) refers to nodes that are not in my partial database.

Afaik the only solutions are:

1) Include everything in your OSM database and forget about partial database

or

2) re-import an extract periodically and forget about using *.osc files.

-Timo