pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Christoph Berg <myon@debian.org>
To: Magnus Hagander <magnus@hagander.net>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Sergei Kornilov <sk@zsrv.org>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>
Cc: Michael Banck <michael.banck@credativ.de>
Cc: PostgreSQL Developers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Offline enabling/disabling of data checksums
Date: Thu, 14 Mar 2019 15:28:15 +0100
Message-ID: <20190314142815.GD32045@msg.df7cb.de> (raw)
In-Reply-To: <CABUevEx7QZLOjWDvwTdm1VM+mjsDm7=ZmB8qck7nDmcHEY5O5g@mail.gmail.com>
References: <20190312124403.GM13812@paquier.xyz>
	<20190313021621.GP13812@paquier.xyz>
	<alpine.DEB.2.21.1903130805330.4059@lancre>
	<20190313093150.GE2988@paquier.xyz>
	<alpine.DEB.2.21.1903131037240.4059@lancre>
	<20190313101021.GF2988@paquier.xyz>
	<5217311552474471@myt2-66bcb87429e6.qloud-c.yandex.net>
	<CABUevEzM86WSaap-OZ0Dfou8T07NN1ki5B67xd0u8UeZEpqT5Q@mail.gmail.com>
	<20190314002342.GC3493@paquier.xyz>
	<CABUevEx7QZLOjWDvwTdm1VM+mjsDm7=ZmB8qck7nDmcHEY5O5g@mail.gmail.com>

Re: Magnus Hagander 2019-03-14 <CABUevEx7QZLOjWDvwTdm1VM+mjsDm7=ZmB8qck7nDmcHEY5O5g@mail.gmail.com>
> Are you suggesting we should support running with a master with checksums
> on and a standby with checksums off in the same cluster? That seems.. Very
> fragile.

The case "shut down master and standby, run pg_checksums on both, and
start them again" should be supported. That seems safe to do, and a
real-world use case.

Changing the system id to a random number would complicate this.

(Horrible idea: maybe just adding 1 (= checksum version) to the system
id would work?)

Christoph




view thread (149+ messages)  latest in thread

Message-ID: <20190314142815.GD32045@msg.df7cb.de>
Permalink:  ../20190314142815.GD32045@msg.df7cb.de/
Also on:    postgresql.org/message-id/20190314142815.GD32045@msg.df7cb.de

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-hackers@postgresql.org
  Cc: myon@debian.org, magnus@hagander.net, michael@paquier.xyz, sk@zsrv.org, coelho@cri.ensmp.fr, michael.banck@credativ.de, pgsql-hackers@lists.postgresql.org
  Subject: Re: Offline enabling/disabling of data checksums
  In-Reply-To: <20190314142815.GD32045@msg.df7cb.de>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox