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 1qxA3v-00GRA6-NH for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 17:58:59 +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 1qxA2u-008prj-NG for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 17:57:56 +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 1qxA2u-008prb-9P for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 17:57:56 +0000 Received: from mail-ej1-x62d.google.com ([2a00:1450:4864:20::62d]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxA2n-003hC5-N6 for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 17:57:55 +0000 Received: by mail-ej1-x62d.google.com with SMTP id a640c23a62f3a-99c3d3c3db9so595960266b.3 for ; Sun, 29 Oct 2023 10:57:49 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698602267; x=1699207067; 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=XKyWB4iQzAqA/uuswPiHeVaEEYMkSRLYowlgFE5rVzw=; b=IOOL6CnTp1GUFe2VgnrEa4oP9L5mYUKPnGJvuYxDToUL+MaYk2FF1Ud/YgzFM9kM4W 2D86j3KFjmyla7K2H53yWKE/dIqR84Szf0Juakqvfm4Z+ozYwB4+fQQMRXfy3W0Qemdn J6+do3C1De37cdpoWFuESMzZlc7tBeLX36K2lqquofSNkhlpdddMAOJbwAvnFcsJv72b AxHkIF61W8T71/12fmGemd88QNwQv9r5Nq2/Q3h3TZ37cF7jQEOrl1D8Voebc7RmtZX1 +JUfgtHrSyDpd+d0n+Hl5vT8fTTySziw4e4y6gX/aoAU8w6KqCG/gGSeLPJFETYSpQAf 5BFQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698602267; x=1699207067; 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=XKyWB4iQzAqA/uuswPiHeVaEEYMkSRLYowlgFE5rVzw=; b=d+wgK9hjs3NHh1sQDk7nr3+Oqnth0NtFRZjbyGbhyWmOEDnpMjDkV4mwME408BGbyA cK77WCrbv0jwmp3n0AgMavMATApDTrQsox8LIjXu+2FuCAc9knwhhV9rOVWp7rasDhkN LAkgn8WDpm64dQOiw7Q+CU85E++9HCdAeVuOtfpan3BKoRYSqXgCHtGKT5UFpIsCNlEH I7mo6OUlS0nWs23tBi7Xe0IQVfijMcG3snHCUGpPwkhrtfJ7cbwE+PF+9I3N2NLwW3xr b4mziQ+IrWiHnSWFRaA30BPnlsf4FOM7WFhCp/Ok+YmFPo5/wDFRahuGLm7BpPE/blb+ egWg== X-Gm-Message-State: AOJu0YyTv+EROoVWrl42pEMvPrlQOlN6oGHYvVAoT9OqoD8yld9RNzRR l/bBaREBy2Fjynwwj7CWIpE= X-Google-Smtp-Source: AGHT+IFAKfpTe/QfNvhGxkHH4eYWh23eKK/bPWQTWxlGZqkRnpl0R1uH4qsaEgNrJuWixJBusmDioA== X-Received: by 2002:a17:906:6a25:b0:9bd:931e:30d8 with SMTP id qw37-20020a1709066a2500b009bd931e30d8mr6345715ejc.14.1698602266918; Sun, 29 Oct 2023 10:57:46 -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 v16-20020a170906565000b009b9977867fbsm4679849ejr.109.2023.10.29.10.57.46 (version=TLS1_2 cipher=ECDHE-ECDSA-AES128-GCM-SHA256 bits=128/128); Sun, 29 Oct 2023 10:57:46 -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: <11f5795f-ae2c-4123-93e7-b42d4a1115d7@gmail.com> Date: Sun, 29 Oct 2023 18:57:15 +0100 Cc: pgsql-general@lists.postgresql.org Content-Transfer-Encoding: quoted-printable Message-Id: 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> <11f5795f-ae2c-4123-93e7-b42d4a1115d7@gmail.com> To: Ron 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:37, Ron wrote: >=20 > As for safety, what do you mean by "safe"? Safe in the sense that, if I enable checksums on a replica, switch over = and the enable checksums on the other side, if this is ok, or whether = future mutations on the primary will corrupt the replica. That's why I asked if I need to perform a patronictl reinit. Cheers Paul=