Re: Offline enabling/disabling of data checksums

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: Offline enabling/disabling of data checksums
Дата
Msg-id
20190219050224.GV15532@paquier.xyz
Ответ на
Список
Дерево обсуждения
Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Robert Haas <robertmhaas@gmail.com>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Stephen Frost <sfrost@snowman.net>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Sergei Kornilov <sk@zsrv.org>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Andres Freund <andres@anarazel.de>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Andres Freund <andres@anarazel.de>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Andres Freund <andres@anarazel.de>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Andres Freund <andres@anarazel.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <fabien.coelho@mines-paristech.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Christoph Berg <myon@debian.org>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Andres Freund <andres@anarazel.de>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Sergei Kornilov <sk@zsrv.org>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Sergei Kornilov <sk@zsrv.org>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Sergei Kornilov <sk@zsrv.org>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Christoph Berg <myon@debian.org>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Sergei Kornilov <sk@zsrv.org>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Sergei Kornilov <sk@zsrv.org>
Re: Offline enabling/disabling of data checksums Fabien COELHO <fabien.coelho@mines-paristech.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Andres Freund <andres@anarazel.de>
Re: Offline enabling/disabling of data checksums Michael Paquier <michael@paquier.xyz>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Bernd Helmle <mailings@oopsware.de>
Re: Offline enabling/disabling of data checksums Michael Banck <michael.banck@credativ.de>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Bernd Helmle <mailings@oopsware.de>
Re: Offline enabling/disabling of data checksums Fabien COELHO <coelho@cri.ensmp.fr>
Re: Offline enabling/disabling of data checksums Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: Offline enabling/disabling of data checksums Magnus Hagander <magnus@hagander.net>
On Sun, Feb 17, 2019 at 07:31:38PM +0100, Michael Banck wrote:
> New patch attached.

- * src/bin/pg_verify_checksums/pg_verify_checksums.c
+ * src/bin/pg_checksums/pg_checksums.c
That's lacking a rename, or this comment is incorrect.

+#if PG_VERSION_NUM >= 100000
+   StaticAssertStmt(sizeof(ControlFileData) <= PG_CONTROL_MAX_SAFE_SIZE,
+                    "pg_control is too large for atomic disk writes");
+#endif
This is compiled with only one version of the control file data, so
you don't need that.

Any reason why we don't refactor updateControlFile() into
controldata_utils.c?  This duplicates the code, at the exception of
some details.
--
Michael
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Tom Lane
Дата:
FAQ