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 1u5t6R-007X2R-IU for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 21:18:28 +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 1u5t6O-002Nt6-4w for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 21:18:24 +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 1u5t6N-002Nqp-L7 for pgsql-general@lists.postgresql.org; Fri, 18 Apr 2025 21:18:24 +0000 Received: from mail-pf1-x42c.google.com ([2607:f8b0:4864:20::42c]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5t6K-000o0o-2Q for pgsql-general@postgresql.org; Fri, 18 Apr 2025 21:18:23 +0000 Received: by mail-pf1-x42c.google.com with SMTP id d2e1a72fcca58-7390d21bb1cso2095678b3a.2 for ; Fri, 18 Apr 2025 14:18:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ardentperf-com.20230601.gappssmtp.com; s=20230601; t=1745011099; x=1745615899; darn=postgresql.org; h=content-transfer-encoding:mime-version:message-id:subject:to:from :date:from:to:cc:subject:date:message-id:reply-to; bh=JSp18Zn2jtYn3pHGcxhA8WeizxsORb2xYwGiozoY918=; b=E7AaH/bgBcDbxBcHD21WvRQJ1lMCQnAATy56SJURHA6QwX8q/pTyCJ4pCCNoNhqcnN jAeQSimmwsTtOpcIeAdpN9i/DSnyWYxXn20P1MA1ZHILamrR7s0/kScIMoFuw06cUoNZ LDW9FgZ/XcmuhMf1oTSLUHRtcawSux7cfwQygjySZv8ypF3X0Y4+80aRYvB76ZWbBNSx OFTk18EIhuOZItgPtTAjhNHYQoKxAxCP+7jF3SjODZT4Tx2P1fsErjbaZG4WEuiDM7pB TZQW3Og6NFO2bkqCVfILxXihjU4ug3iO7NR2wkBy7mqy1Bz5NcHH9NuJ6Sa8BrZo8KTH eepQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745011099; x=1745615899; h=content-transfer-encoding:mime-version:message-id:subject:to:from :date:x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=JSp18Zn2jtYn3pHGcxhA8WeizxsORb2xYwGiozoY918=; b=f+z404lYY1I2soGHueqfjMj6gQ+EeTF0Drr/MNHZxpBXbqTmX7H+uUjw6Pc9jkvGR0 ocDDBilm1zaQWqBubDUf8u7ybJ5nkNVw6yEt1oPW5JMnGtcDUbe5DfCYV6nE9JbJfjok VkSFZFLlaBhThyF3F3zCRJIXUOBGspwhzGFGm+wlCSR+C8cosguzZbJkjACX7SUa+BRH o4CbfqRZpY+difudpJepkl78dF7vnlOTLOD0O4oZe7b0yQukN8is/gZtrpvgmHBeuX74 bcf4c3LmC/MB9yuA1AO94nEb4hoNl9TtJ3HWXrEWzaR/Z2+ow+7+f131GAfg5UpfBEqZ lZ4Q== X-Gm-Message-State: AOJu0YwapLq2ADNrHgrXtO/Ht16cXPcU76aoH/ejpa9MHPh/p2S0xeb1 Td4o6ros/+DI4/F5JrBLPSWFcicPBignaq90qJDqUAG4l3ppAy+po6t5UJ/5fBfdLFOM2CYaS6c PTg== X-Gm-Gg: ASbGncveJr9dV/47s9dU25tEJOQ3K02bA2GTCqmwbU+6VMTCMplrQZ22FATV04rkKmP r9EaowonpD92AlmzKFa7txFlhtUSTV0C3AToLDkauj3Iaci3liQNNFjXVUg6lJA4cHk+ASvHfXE KdZhmhNvwLeBPrZ/19JXt9cITKnajqXst6C6GJNZuT+o56Dmj/vyEUCb9am+R/U29b0BE21MfwQ vr6pHq5r30ooKL455irYfmpjxJXHe7gSbLtZJGE8m027dNV0c+wpd0EdSuGBkPPOOjQkdsD8SMh RlffNDN2VfmUOPUwpl2D9e2m6HjzbJB5/36O/BhvMwYpGIKE1RvxLII7t6x8QG+z1fX0LLy7lqs j X-Google-Smtp-Source: AGHT+IG3lWSxC1DvfVR1OrZvhgJPTXoGfrB0/4xwz1VZQZ+g0u2Luls7y+KhYRrrNyOm9E4X6JWHhw== X-Received: by 2002:a05:6a21:6d92:b0:1ee:dcd3:80d7 with SMTP id adf61e73a8af0-203cba9aa48mr6224572637.0.1745011099318; Fri, 18 Apr 2025 14:18:19 -0700 (PDT) Received: from ardentperf.com (97-113-70-15.tukw.qwest.net. [97.113.70.15]) by smtp.gmail.com with ESMTPSA id 41be03b00d2f7-b0db157c5b7sm1804697a12.76.2025.04.18.14.18.18 for (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Apr 2025 14:18:18 -0700 (PDT) Date: Fri, 18 Apr 2025 14:18:17 -0700 From: Jeremy Schneider To: "pgsql-general@postgresql.org" Subject: verify checksums online Message-ID: <20250418141817.2457ac8d@ardentperf.com> MIME-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk i should know the answer to this... but asking anyway i think there had been some mailing list discussions years ago? the pg_checksum utility in core still can't do an online check right? looking around, i think that michael's pg_checksums_ext still seems to be available in debian repos, and it advertises online checks, which makes me think that the core pg_checksum might still not have merged any code for online checking yet but i wanted to confirm with someone - my easiest options for online verifying checksums would be to trigger pg_basebackup then check pg_stat_database, or to install michael's utility? -Jeremy