Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h465M-0005SE-4U for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Mar 2019 15:46:28 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h465K-0008NW-7W for pgsql-hackers@arkaria.postgresql.org; Wed, 13 Mar 2019 15:46:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h465J-0008NP-Sb for pgsql-hackers@lists.postgresql.org; Wed, 13 Mar 2019 15:46:26 +0000 Received: from gauss.credativ.com ([93.94.130.89]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h465G-0003yX-G0 for pgsql-hackers@lists.postgresql.org; Wed, 13 Mar 2019 15:46:24 +0000 Received: from gauss.credativ.com (localhost [127.0.0.1]) by gauss.credativ.com (Postfix) with ESMTP id 679CF1E36F4; Wed, 13 Mar 2019 16:46:19 +0100 (CET) Received: from kohn.fritz.box (ppp-188-174-36-161.dynamic.mnet-online.de [188.174.36.161]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: mba@gauss.credativ.com) by gauss.credativ.com (Postfix) with ESMTPSA id 0AF1C1E1BC7; Wed, 13 Mar 2019 16:46:18 +0100 (CET) Message-ID: <1552491979.4947.71.camel@credativ.de> Subject: Re: Offline enabling/disabling of data checksums From: Michael Banck To: Magnus Hagander , Sergei Kornilov Cc: Michael Paquier , Fabien COELHO , PostgreSQL Developers Date: Wed, 13 Mar 2019 16:46:19 +0100 In-Reply-To: References: <20181221201616.GD4974@nighthawk.caipicrew.dd-dns.de> <20190311045323.GE1818@paquier.xyz> <155231347133.16480.11453587097036807558.pgcf@coridan.postgresql.org> <1552385626.4947.50.camel@credativ.de> <20190312124403.GM13812@paquier.xyz> <20190313021621.GP13812@paquier.xyz> <20190313093150.GE2988@paquier.xyz> <20190313101021.GF2988@paquier.xyz> <5217311552474471@myt2-66bcb87429e6.qloud-c.yandex.net> Organization: credativ GmbH Content-Type: text/plain; charset="UTF-8" X-Mailer: Evolution 3.22.6-1+deb9u1 Mime-Version: 1.0 Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Hi, Am Mittwoch, den 13.03.2019, 12:24 +0100 schrieb Magnus Hagander: > On Wed, Mar 13, 2019 at 11:54 AM Sergei Kornilov wrote: > > One new question from me: how about replication? > > Case: primary+replica, we shut down primary and enable checksum, and > > "started streaming WAL from primary" without any issue. I have > > master with checksums, but replica without. > > Or cluster with checksums, then disable checksums on primary, but > > standby think we have checksums. > > Enabling or disabling the checksums offline on the master quite > clearly requires a rebuild of the standby, there is no other way What about shutting down both and running pg_checksums --enable on the standby as well? Michael -- Michael Banck Projektleiter / Senior Berater Tel.: +49 2166 9901-171 Fax: +49 2166 9901-100 Email: michael.banck@credativ.de credativ GmbH, HRB Mönchengladbach 12080 USt-ID-Nummer: DE204566209 Trompeterallee 108, 41189 Mönchengladbach Geschäftsführung: Dr. Michael Meskes, Jörg Folz, Sascha Heuer Unser Umgang mit personenbezogenen Daten unterliegt folgenden Bestimmungen: https://www.credativ.de/datenschutz