[Geocoding] Turning on fsync and full_page_writes after installation

Tom Hughes tom at compton.nu
Thu Dec 19 17:37:42 UTC 2013


On 19/12/13 04:26, Simon Nuttall wrote:

> 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?

Most postgres settings (though not all) can be changed with a simple 
reload rather than a restart. The documentation usually says if a 
parameter can only be set at server start and neither of these does.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://compton.nu/



More information about the Geocoding mailing list