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 1qxA79-00GRau-Uc for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 18:02:19 +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 1qxA78-008t7R-GL for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 18:02:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qxA78-008t7I-5N for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 18:02:18 +0000 Received: from mail-ej1-x62f.google.com ([2a00:1450:4864:20::62f]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxA76-003hE6-03 for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 18:02:17 +0000 Received: by mail-ej1-x62f.google.com with SMTP id a640c23a62f3a-9be3b66f254so553597466b.3 for ; Sun, 29 Oct 2023 11:02:15 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698602535; x=1699207335; darn=lists.postgresql.org; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=Q98ElXb/jI/abduR6dDyaw3kxIVjzNpqXfc1Rn99l00=; b=GSk0Z9z0kSii3XOpvscLcmQ6djKaZoV5QjS1OXsHRrAkcg7bAAGYbdTVyOKG3haz3s QTmCMMhpbmFyjBKQeQ4O4QUgHK+4qPiSMHUH5bcqkGrMsyH7QFxIC9kbpuhLnwfuVdUd olxpXwVsuCyvbkz9ontJfIuXO3smCcqxU28kCxhoMQTCiWshJbW5HOPnU1N/wY8csIAO C8vDlm/S5l7U9mjKZTamEXotqiN+i7Z8yoJSk4q2GYJmzRozzOCIxtk7B1g6JxIJuOkE UYX+WOCzxYro0mDedyPzOP2Svj4ZbtvlpfInGU/Ohcxtf1HSopSJfJV31V6BIf6255Q1 48/g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698602535; x=1699207335; h=to:references:message-id:content-transfer-encoding:cc:date :in-reply-to:from:subject:mime-version:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=Q98ElXb/jI/abduR6dDyaw3kxIVjzNpqXfc1Rn99l00=; b=gWcOsBRW0g+/5SBgXIPVmScHrDFgt35wQk6TXQmtITe7TsxvhdfZoa1mp/mFqxYt71 GMsqVEHPDPpf3KiYsLDoXDHz9ChE2dlI9APU09jvzy3Z2p7zERx5X/4s9zx+agZrmEGJ dobUJCU8paHcU0p60O2AlcVei+tVshA7TNIoOAVSFJXAshqu57A18uq5MlHbhoez7CNe uhI/zx/0IRbMhouxtqKyi7mzQ9VvCyJMGYrTAKeSOm0tTjc5q7oc9IbzIhog3l7c08Uw p4U36p3c0ee+YKDOzTXJbzEmlg4geMBpWMmlIyzDt7+Su6ZoqEaVspimjuE8pdGezI/9 pDVA== X-Gm-Message-State: AOJu0YygeU29MQrqQ5MEKWHoskKdLhzjsLRU3h/55IqP4i2CC8HMhd52 nTlLp/GLeJgGoY1zjqBL/Q9RC2ehR67uaQ== X-Google-Smtp-Source: AGHT+IG/Ho7PiknuwLYN88vbCnUw3m5THhy6j259/aqQAYSmEGXh3YQIp7Ks1ApUYgWAgJ1vBoA8AQ== X-Received: by 2002:a17:906:ef07:b0:9b2:b2f8:85dc with SMTP id f7-20020a170906ef0700b009b2b2f885dcmr6686752ejs.34.1698602534700; Sun, 29 Oct 2023 11:02:14 -0700 (PDT) Received: from smtpclient.apple (26-36-239-77.dyn.cable.fcom.ch. [77.239.36.26]) by smtp.gmail.com with ESMTPSA id k5-20020a1709063e0500b009b8a4f9f20esm4663589eji.102.2023.10.29.11.02.14 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 29 Oct 2023 11:02:14 -0700 (PDT) Content-Type: text/plain; charset=us-ascii Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.200.91.1.1\)) Subject: Re: pg_checksums? From: =?utf-8?Q?Paul_F=C3=B6rster?= In-Reply-To: <20231029153841.vl4bqwv33j3q2xgu@hjp.at> Date: Sun, 29 Oct 2023 19:01:43 +0100 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: <39A3E175-E161-4325-A4AE-41B088FFADF6@gmail.com> References: <22272207-E6E5-4DD5-9BD4-5F6B647E2C3B@gmail.com> <0D18D31E-EF52-434D-875C-08BEC8DDD553@yesql.se> <20231029014310.7pbdfhincj2tds4l@hjp.at> <81D43A87-7D3D-4F81-B462-641F15B5E332@gmail.com> <20231029104911.dj73ivozabdr5or4@hjp.at> <4614561A-6176-4136-BA96-74B05A7B6B5C@gmail.com> <20231029153841.vl4bqwv33j3q2xgu@hjp.at> To: "Peter J. Holzer" X-Mailer: Apple Mail (2.3774.200.91.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Ron, > On Oct 29, 2023, at 16:38, Peter J. Holzer wrote: > And this is where it would break down. The modifications can't be > applied to the replica any more because the replica now contains > checksums and the modifications don't. In the best case the replica > would catch the discrepancy and refuse to apply the modifications = which > would lead to the loss of these modifications. In the worst case it > would apply them anyway causing severe data corruption. ... > Not just the file headers. Every single data block. >=20 > (Ok, it looks like the space for the checksum is reserved even if > checksums aren't enabled[1]. So at least pg_checksums doesn't have to > move data around to enable them. But overwriting a page with a = checksum > with one without one would still be bad.) Those are the kind of answers and insights I was looking for. Thank you = very much. Ok, I will do a reinit then. Cheers Paul