This is a static archive of our old OpenStreetMap Help Site. Please post any new questions and answers at community.osm.org.

Update osm2pgsql database from apidb database

0

Suppose we have two databases:

  1. With osm2pgsql schema.
  2. With apidb schema.

Updating osm2pgsql data from apidb is quite simple, by using --replicate-apidb command, which is provided by osmosis.

Do we have the opposite way to update apidb data from osm2pgsql database?

asked 13 Aug '19, 15:39

YUNtee's gravatar image

YUNtee
16335
accept rate: 0%


One Answer:

1

No, it is not possible because information is lost when importing data into an osm2pgsql database. For example, it does not keep version numbers, user IDs, or timestamps, and might drop some objects altogether when they are deemed unnecessary for rendering.

answered 13 Aug '19, 16:36

Frederik%20Ramm's gravatar image

Frederik Ramm ♦
82.5k927201273
accept rate: 23%

Ok, thanks for the answer!

(14 Aug '19, 11:02) YUNtee

Source code available on GitHub .