Re: Offline enabling/disabling of data checksums - Mailing list pgsql-hackers

From Christoph Berg
Subject Re: Offline enabling/disabling of data checksums
Date
Msg-id 20190314142815.GD32045@msg.df7cb.de
Whole thread Raw
In response to Re: Offline enabling/disabling of data checksums  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Offline enabling/disabling of data checksums
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Offline enabling/disabling of data checksums
Next
From: Magnus Hagander
Date:
Subject: Re: Offline enabling/disabling of data checksums