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 1qx7r0-00GDXT-Ez for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 15:37:30 +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 1qx7qy-0081TK-Nu for pgsql-general@arkaria.postgresql.org; Sun, 29 Oct 2023 15:37:28 +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 1qx7qy-0081TC-Ct for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 15:37:28 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qx7qw-002uLQ-7K for pgsql-general@lists.postgresql.org; Sun, 29 Oct 2023 15:37:27 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-d9a4c0d89f7so2994348276.1 for ; Sun, 29 Oct 2023 08:37:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1698593845; x=1699198645; 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=rv7B4Av5MJ2U3ZbSN31fpWhA8dQpEYiuAf0KPhMlGyY=; b=YOF8IQ7ojgUoO897uXgAEX5EbRTAQpGf4/CH035KgQFm3RKeC7+X6+4bDgtqZAM6Qp LEL9VH8jiJGT2VBNLpffOxmyVopjaRv5TKkuPMGfSH3VFiX2o/t0pYLXPFknWKs0jjfO 13S/t4MkepmxU/JpahFBq6zRxyp6K9Fq3sN/Qsz/IpCZSBpRFwhbEXt4Sriw85BkXfk+ npDJT4cuulrM04/GVhxxUUl7dJfSzLnl6K0QZP1Y1FqBZr5OXVPoRf2k+2nAs71thjwZ MMA2CtgSINZyz5BsGmMpi+i8vKzkUAcYuVQHyMEcLXX4Ynn3AzQKQTpd4wnTm4Z9UwPr q9LQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1698593845; x=1699198645; 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=rv7B4Av5MJ2U3ZbSN31fpWhA8dQpEYiuAf0KPhMlGyY=; b=LF1PRRyd5qAU5fn92/E9mZMD1EPKp1/4JcwpWMMfzH+ZzQO0hzR2TQy5BaKNLGNiYS BzWFGjjjn6Zm3Sd7YheH+qUSDcFVMeCWY/c/Yn3a3HWpfHgroLtMvRK5VdEeCTYByfgq 0i3hM+aI57m4n6/8jA4Xs1v7jc3ziFhNCOVUoqQEs9PcnZ7y1D3T9xvT7poZlNhMOESJ jdErqccOcUFIPbiuC1EIQAA+AzKgARYkVGYmtnff4gU1E6UQxx7ixXTDE6S6DxvCYNC0 09ixaIbWCbqC3Lle5bdMIQzny/fgJRf2TPIMdKzM6bvX2KKAT7KN4Sv6HZ8Ya25uPHBd 3GYA== X-Gm-Message-State: AOJu0YwRiJ6tNnnXAYm8mrBs1fry9ZjFD8UcE/vcg97deAlSVJ2HjjIA SdyDY36Y56Zitvg6yi7Y0U43IG0rW2A= X-Google-Smtp-Source: AGHT+IEqgffKlca5l8roiZPwyIT7A9w2/ZGvWue3pZDtOLs3XEbp21EaSxWits4BL11rcTSxahINDQ== X-Received: by 2002:a25:da8f:0:b0:d9b:eb86:2b26 with SMTP id n137-20020a25da8f000000b00d9beb862b26mr7582414ybf.21.1698593845323; Sun, 29 Oct 2023 08:37:25 -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 b206-20020a2534d7000000b00d9caecd5c86sm2821430yba.62.2023.10.29.08.37.24 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Sun, 29 Oct 2023 08:37:25 -0700 (PDT) Message-ID: <11f5795f-ae2c-4123-93e7-b42d4a1115d7@gmail.com> Date: Sun, 29 Oct 2023 10:37:19 -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> From: Ron In-Reply-To: <81D43A87-7D3D-4F81-B462-641F15B5E332@gmail.com> 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 04:11, Paul Förster wrote: > Hi Peter > >> On Oct 29, 2023, at 02:43, Peter J. Holzer wrote: >> I don't think so. AFAIK Replication keeps the data files in sync on a >> bit-for-bit level and turning on checksums changes the data layout. >> Running a cluster where one node has checksums and the other doesn't >> would result in a complete mess. > I agree with the last sentence. This is why I asked if it is safe to enable checksums on a replica, switch over and then do it again on the ex primary, i.e. now new replica without doing a reinit. For that to work, the secondary files would have to remain identical to the primary files.  Theoretically that _should_ happen, but it might not, or whatever command that enables checksums after the fact might have a sanity check. As for safety, what do you mean by "safe"? -- Born in Arizona, moved to Babylonia.