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

Flatnode files in DB cluster

0

Hi I have setup Postgres as cluster model (master & slave). Imported planet data with Flatnode_File config in master server & DB data will sync to slave(not flatnode file) Now I want to query(geocode/reverse) in both master & slave. Is there any problem(performance/data related) will arrive while querying in slave?

asked 14 Jul '18, 15:55

Rajavelu_M's gravatar image

Rajavelu_M
253●45●48●58
accept rate: 33%

One Answer:

1

You only need the flatnode file on the master. It is used during import and data update, not querying. Master/slave should work. The slave database cannot be written to directly so make sure you keep the @define('CONST_Log_DB', false); (settings.php).

answered 14 Jul '18, 18:21

mtmail's gravatar image

mtmail
4.8k●15●74
accept rate: 27%

@mtmail: Thank you

(14 Jul '18, 20:19) Rajavelu_M

Note that if you use a syncing mechanism that can do per-table sync (like e.g. slony), you only need to replicate a subset of all tables for geocoding to work. The list of required tables is here: https://github.com/openstreetmap/Nominatim/blob/master/utils/setup.php#L658-L672

(15 Jul '18, 09:24) Frederik Ramm ♦