NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum

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
253454858
accept rate: 33%


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).

permanent link

answered 14 Jul '18, 18:21

mtmail's gravatar image

mtmail
4.8k1574
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 ♦
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×689
×147
×5
×3

question asked: 14 Jul '18, 15:55

question was seen: 1,902 times

last updated: 15 Jul '18, 09:24

NOTICE: help.openstreetmap.org is no longer in use from 1st March 2024. Please use the OpenStreetMap Community Forum