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 1h7FJL-00007e-MG for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2019 08:13:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h7FJJ-0002Xz-Lr for pgsql-hackers@arkaria.postgresql.org; Fri, 22 Mar 2019 08:13:53 +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 1h7FJJ-0002Xs-A7 for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2019 08:13:53 +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 1h7FJF-0006s3-UQ for pgsql-hackers@lists.postgresql.org; Fri, 22 Mar 2019 08:13:52 +0000 Received: from gauss.credativ.com (localhost [127.0.0.1]) by gauss.credativ.com (Postfix) with ESMTP id E9CA21E1D83; Fri, 22 Mar 2019 09:13:44 +0100 (CET) Received: from kohn.fritz.box (ppp-188-174-61-168.dynamic.mnet-online.de [188.174.61.168]) (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 7D2A81E19C7; Fri, 22 Mar 2019 09:13:44 +0100 (CET) Message-ID: <1553242423.4884.1.camel@credativ.de> Subject: Re: Offline enabling/disabling of data checksums From: Michael Banck To: Michael Paquier , Fabien COELHO Cc: Andres Freund , Magnus Hagander , Sergei Kornilov , PostgreSQL Developers Date: Fri, 22 Mar 2019 09:13:43 +0100 In-Reply-To: <20190322002727.GJ20192@paquier.xyz> References: <20190319161317.utyo6pnkxznxu4bu@alap3.anarazel.de> <1553013016.9697.57.camel@credativ.de> <20190319164717.ex2pw66zusbdqg2o@alap3.anarazel.de> <20190319230907.GA3488@paquier.xyz> <20190320051750.GA26601@paquier.xyz> <20190320125451.GA20192@paquier.xyz> <20190320225924.GC20192@paquier.xyz> <20190322002727.GJ20192@paquier.xyz> 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 Freitag, den 22.03.2019, 09:27 +0900 schrieb Michael Paquier: > I have added in the docs a warning about a host crash while doing the > operation, with a recommendation to check the state of the checksums > on the data folder should it happen, and the previous portion of the > docs about clusters. Your suggestion sounds adapted. I would be > tempted to add a bigger warning in pg_rewind or pg_basebackup about > that, but that's a different story for another time. > > Does that look fine to you? Don't we need a big warning that the cluster must not be started during operation of pg_checksums as well, now that we don't disallow it? 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