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

How to sync database postgresql with openstreetmap using slony or pgpool.

0

I'm new in domain openstreetmap i would like you help me to resolve a problom. I would wish to sync my database postgresql with openstreetmap using slony or Pgpool. But i don't know how to do it, or whether it is possible to do it. I ensure you i have already done some research, but unfortunately i have not found some responses that answering my needs. If someone have some ideas please help me. thank you in advance

asked 19 Feb '16, 16:05

Abou's gravatar image

Abou
1111
accept rate: 0%


One Answer:

1

If you want to have a local postgresql database that has regular updates from the main openstreeetmap.org database/api, you can't use slony, and instead must use the osmosis replication procedure. You can keep a local database updated to practically the minute this way, and it's how everyone does it.

answered 19 Feb '16, 16:10

rorym's gravatar image

rorym
5.4k1449100
accept rate: 11%

Source code available on GitHub .