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 1qxAUh-00GTyC-Ap for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 18:26:39 +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 1qxAUf-008yQX-MR for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 18:26:37 +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 1qxAUf-008yQO-Bg for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 18:26:37 +0000 Received: from mail-yb1-xb34.google.com ([2607:f8b0:4864:20::b34]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qxAUY-003hOX-Rt for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 18:26:36 +0000 Received: by mail-yb1-xb34.google.com with SMTP id 3f1490d57ef6-d9ac31cb051so3059899276.3 for ; Sun, 29 Oct 2023 11:26:30 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698603988; x=1699208788; darn=lists.postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=+V19bfJnuWn9t+z04WAzh6/SmMMT5Q0KhRtvQrncIfw=; b=ThF0NP/ZUACAyEOyHe1evgA0CAWNJ5BJwfybbwRYfUK1zXV6H5rM5ln53tMO+XaOsb Gor7alyP5cfk36lobEuKAMxf2wJMuWLB+idEvJCPiqBKyqIjzKAUepU4G+6JcY/LB1Yf hECjQobSMyi4mx3mhOYT9Qx6KgZCQ2RQYhueujxhWTj2ommMxgdgp1abDfPk7gwBV2Hk A0cXeDI361ICwmd8scUeiN2/8NTsYj7qw6SUFFj7dQ8C2F3hCDmWMAmXrIZWZNRRgmqS RjrGKiwEQ0C5srwWzWySs/go6bbByvxolMbLwXzj6yRb6nTHuTCZ3tx/pi65/om1pfVv Jsog== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698603988; x=1699208788; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=+V19bfJnuWn9t+z04WAzh6/SmMMT5Q0KhRtvQrncIfw=; b=CUai7h0NMw3ei6pb88Swt5ChG/VRcvoQ3kwmRy7DaDlAnhPA0Bv/tH8eZB6Y4Hpy8e TQZ8rT0HBJSWK2hP98iD+jzjRJBg3Hh1qu85r0ceLhPVoVXnA+GByuBWm11piXPr1UDz n4oynR6F9oSe69YZd/6i42WUbX/DZfcZ6Uf//xPIrhbjNDRopOpLd9D6Z4Tzq04qXGO2 8+7Ng/HnsU68jH1jr0UskIbLrdh8vomzpPQLUi1JYSOGDrJgyxcayzgu8FJn4Btf9hG8 z49TdkZIVVye20X567CbM4rOPFpeQa2Qju5rsQApbxKcuaiZrtTvitOPbT/dBa7iV1ig ypyw== X-Gm-Message-State: AOJu0Yx+l4bAN/oYLGSUI0BdQL9whq7S8fldncc7wzQpHa0izLNLthqy XHY5A4ws9tDPwoeBzn80MJuTbTtO/D8= X-Google-Smtp-Source: AGHT+IElVW811iafXHOXX40LGe2TFUZ/OiMpERjB3stbXo4KMlxmZjLFcI6IP1JmuSJ4lQgX4Vi9ZQ== X-Received: by 2002:a25:ca48:0:b0:d9c:a7fa:dbcb with SMTP id a69-20020a25ca48000000b00d9ca7fadbcbmr7753783ybg.22.1698603988436; Sun, 29 Oct 2023 11:26:28 -0700 (PDT) Received: from ?IPV6:2600:1700:bd2c:b810:d564:3b8d:339c:be87? ([2600:1700:bd2c:b810:d564:3b8d:339c:be87]) by smtp.googlemail.com with ESMTPSA id w31-20020a25ac1f000000b00d9ac390fa31sm2970764ybi.10.2023.10.29.11.26.28 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 29 Oct 2023 11:26:28 -0700 (PDT) Message-ID: <76e7a32e-f433-41fa-9b03-96efdb3a5223@gmail.com> Date: Sun, 29 Oct 2023 13:26:27 -0500 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: pg_checksums? Content-Language: en-US To: pgsql-general@lists.postgresql.org 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> From: Ron In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 10/29/23 12:57, Paul Förster wrote: > Hi Ron, > >> On Oct 29, 2023, at 16:37, Ron wrote: >> >> 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. Trying it would tell you something. > That's why I asked if I need to perform a patronictl reinit. Best to ask Percona. -- Born in Arizona, moved to Babylonia.