[Geocoding] Turning on fsync and full_page_writes after installation
Simon Nuttall
info at cyclestreets.net
Thu Dec 19 04:26:51 UTC 2013
After 10 days on a 1.2TB / 32GB Quad Processor a full planet import
has completed and is continually running minutely updates. Great!
The installation instructions say:
66
For the initial import, you should also set:
fsync = off
full_page_writes = off
Don't forget to switch them on again afterwards or you risk database corruption.
99
So my question is how to turn these back on. It seems they need to be
set in the postgresql.conf file.
Presumably that means restarting postgresql - so how do I do that
without corrupting the data?
Also I'll have to restart the minutely updates afterwards, but how do I do that?
It seems that the nominatim could be made into a service that can be
stopped and resumed.
--
Simon Nuttall
Route Master, CycleStreets.net
More information about the Geocoding
mailing list