Re: Offline enabling/disabling of data checksums

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Offline enabling/disabling of data checksums
Дата
Msg-id 20190322103926.GY20192@paquier.xyz
обсуждение исходный текст
Ответ на Re: Offline enabling/disabling of data checksums  (Michael Banck <michael.banck@credativ.de>)
Список pgsql-hackers
On Fri, Mar 22, 2019 at 10:04:02AM +0100, Michael Banck wrote:
> How about this:
>
> + <refsect1>
> +  <title>Notes</title>
> +  <para>
> +   When enabling checksums in a cluster, the operation can potentially take a
> +   long time if the data directory is large.  During this operation, the
> +   cluster or other programs that write to the data directory must not be
> +   started or else data-loss will occur.
> +  </para>

Sounds fine to me.  Will add an extra paragraph on that.

> Maybe it could be formulated like "If pg_checksums is aborted or killed
> in its operation while enabling or disabling checksums, the cluster
> will have the same state with respect of checksums as before the
> operation and pg_checksums needs to be restarted."?

We could use that as well.  With the current patch, and per the
suggestions from Fabien, this holds true as the control file is
updated and flushed last.
--
Michael

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Performance issue in foreign-key-aware join estimation
Следующее
От: Petr Jelinek
Дата:
Сообщение: Re: Special role for subscriptions