Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwUGd-00C45V-Vt for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 21:21:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qwUGb-001PEi-KG for pgsql-general@arkaria.postgresql.org; Fri, 27 Oct 2023 21:21:17 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwUGb-001PEZ-1V for pgsql-general@lists.postgresql.org; Fri, 27 Oct 2023 21:21:17 +0000 Received: from momjian.us ([72.94.173.45]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qwUGX-002dF7-Oo for pgsql-general@postgresql.org; Fri, 27 Oct 2023 21:21:15 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=momjian.us; s=2023062407; h=In-Reply-To:Content-Transfer-Encoding:Content-Type: MIME-Version:References:Message-ID:Subject:Cc:To:From:Date:Sender:Reply-To: Content-ID:Content-Description; bh=cqZCp4olomD+UaH5zQ821/FlSP1yz8E0tpjMGAN9B04=; b=yaqCQ99aHmQCcbji6IPSQXU6UN O8xUPWyedxQ5cXjxkdRIX+fjkNU9Etn7zZsuc4JeKzw1sftFe800cx2qO5bmgYL0MonINqn1ypxSM vz/7tYVA5Jm3no3llk+XN57R28mtLnxMHmsdUVw3aAQDxPJaIyfhCBjMODEbLoUhOpYQOsL4d22/4 05CUshcssnhGT7ScJ4UgKRBo4ukB/69swWD4//kfE0qqv5GtSw/rJNMO6cpWl44QLA9UJu7Q1Ddm1 xlqvRHIOSY2XU7wCw+mudeivn9qM8u6SL+IVOWFXo0dbOU1+E1u1hqUeu8AuWe7N8qX8ugE+eWCUh 7ORmjDyQ==; Received: from bruce by momjian.us with local (Exim 4.96) (envelope-from ) id 1qwUGV-004HLX-06; Fri, 27 Oct 2023 17:21:11 -0400 Date: Fri, 27 Oct 2023 17:21:11 -0400 From: Bruce Momjian To: Daniel Gustafsson Cc: Paul =?utf-8?Q?F=C3=B6rster?= , "pgsql-general@postgresql.org >> PG-General Mailing List" Subject: Re: pg_checksums? Message-ID: References: <22272207-E6E5-4DD5-9BD4-5F6B647E2C3B@gmail.com> <0D18D31E-EF52-434D-875C-08BEC8DDD553@yesql.se> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <0D18D31E-EF52-434D-875C-08BEC8DDD553@yesql.se> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, Oct 27, 2023 at 10:45:16PM +0200, Daniel Gustafsson wrote: > > On 27 Oct 2023, at 20:34, Paul Förster wrote: > > > a) why isn't it possible to enable checksumming while a database cluster is up? > > It is surprisingly complicated to enable checksums on a live cluster, a patch > was submitted a while back but ultimately never made it into postgres. The > below threads may shine some light on the problem: > > https://www.postgresql.org/message-id/flat/CABUevEx8KWhZE_XkZQpzEkZypZmBp3GbM9W90JLp%3D-7OJWBbcg%40mail.gmail.com > https://www.postgresql.org/message-id/flat/560A2239-5DE2-4B9C-92BC-878C6822F47C%40yesql.se#10b665b2193445a3d7f24be7917a952c Yeah, it was a big surprise that this feature was so hard to implement because we have _no_ infrastructure for having multiple data layouts active in a live system. The discussion eventually made that clear. If we have more features that need this kind of dynamic ability, we might revisit this feature too. -- Bruce Momjian https://momjian.us EDB https://enterprisedb.com Only you can decide what is important to you.