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 1u5u2e-007noS-FB for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 22:18:37 +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 1u5u2a-003DGL-3B for pgsql-general@arkaria.postgresql.org; Fri, 18 Apr 2025 22:18:32 +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 1u5u2Z-003DEH-Jr for pgsql-general@lists.postgresql.org; Fri, 18 Apr 2025 22:18:32 +0000 Received: from mail-pf1-x436.google.com ([2607:f8b0:4864:20::436]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u5u2W-000oNy-2c for pgsql-general@postgresql.org; Fri, 18 Apr 2025 22:18:31 +0000 Received: by mail-pf1-x436.google.com with SMTP id d2e1a72fcca58-736b0c68092so1920058b3a.0 for ; Fri, 18 Apr 2025 15:18:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ardentperf-com.20230601.gappssmtp.com; s=20230601; t=1745014708; x=1745619508; darn=postgresql.org; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:subject:cc:to:from:date:from:to:cc:subject:date :message-id:reply-to; bh=7y3EkfHWRcKx9XC9M1+eQz5NfAkxpCsOTrmjF1Ohx2g=; b=ACo8jMYJcsmQ/7OJ5OXWf4J72kkT1zMv0mEcrtKJcu1ETRWAOAvOX+lCNF/Y9PldUT yf8awuOyp5yl24I2dD5tuqZqDQo3GRpiwH3PnzvZKL6YtjTx4NFIBnAdY+YE5ZzxaMXs M9jNBfOehONwfrLSKnRcTpPq5xHgMlWcilQByN67DAP4k+AYwhem18YkBVQQKAfEP3fw SPJwx7Ightt6K01jiQDJAnISd3JLq8dzfdhHfmIY/TlQ+Jo2bdWcqQe38Unc0X4+mU6O dAL9BqQIDgEc8a6+Cpc3My6+fuUG5GCsK17FNIiHaSvuDEj+BjU6ehh3XBqtf4aw3K1S PRJw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1745014708; x=1745619508; h=content-transfer-encoding:mime-version:references:in-reply-to :message-id:subject:cc:to:from:date:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=7y3EkfHWRcKx9XC9M1+eQz5NfAkxpCsOTrmjF1Ohx2g=; b=QvOCcqzcf31hw4r+IxF/5pCNzIwYkxfpewtyOxfv0AMgC7lqdFztWQAtYxEdhOiQRj 0RZRvVCtMcAmOuMMNKi0RHWp6wDbCDAt6qc2DpdJ7LuEzQs9apgzag92F3uwttwEE/zJ NZWzGtFSM5dtycw0jBbPIq7B2s7fJlXQgxBLEo6+R59iJlusO2UApqKWPFj0vz4hIoEE 6d+IXvl6zBcy2XBdUHQmckDTayv4ke7vjPCxHUpqvQI45Ca4nltrqS1Jsm4NNZzy02Tc BzpoHViZZFi1MhVwpMkvvxvh/X5QQ9eVgAHeY2RFlW9DJb5svKxc0flPYgxFvtgRyf/n 38Gw== X-Gm-Message-State: AOJu0YxtgZ/fWTaqDjP+ZQsmSmApxfqOQdWAh1R8fHj2syPKEtiUt0ou fUvPL1LuWZiCRZry+l9L78t1u3sErHtmFa8C4kESv2VaYrbkIpbyDxmv5IJjlg== X-Gm-Gg: ASbGncvJoF4fQ9G9pO+Uu8AYQYYkS5YeEmXAaOjzwQQe0m6bZdoQ3tPNUI1PRByCbbS xpH0yYBw0ItbihJLC9eC++93R/5je44MOegVqZGJK2xjYNhCsbNqaCdm8jJDzcgId1NIBOdKiDo N1TEx7s1NJ3V+Xw9jK4K8yjht+nXGxUgozMVNCjmBRysJtWcVdAUb+0hjuTs3SVQJ8AZfo2I1O6 7KIsHukuFJm934oHGISiHckEkSrnxfl/dhCdt7xLf56dycxRkPS/HnpHtMxNxxP3c7NgcB4Xxn+ 3n74RXyprzDjKm0FaWNA9cNl5G/WwMbGeAjMkkaliUAnlqJDE21HcKy+ZJURm7k8Kp399Y0UgN0 a X-Google-Smtp-Source: AGHT+IFomuKgpHK/3oEpvMtMg6/sawopyK0WAmEqdB+g9q5NRckTBLfn6W/45k2SAdLw2cJ0U2GVqg== X-Received: by 2002:a05:6a00:32cf:b0:739:48f2:4374 with SMTP id d2e1a72fcca58-73dc14ab781mr4941879b3a.10.1745014707758; Fri, 18 Apr 2025 15:18:27 -0700 (PDT) Received: from ardentperf.com (97-113-70-15.tukw.qwest.net. [97.113.70.15]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-73dbf8ea9a4sm2101891b3a.41.2025.04.18.15.18.27 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 18 Apr 2025 15:18:27 -0700 (PDT) Date: Fri, 18 Apr 2025 15:18:26 -0700 From: Jeremy Schneider To: Ron Johnson Cc: "pgsql-general@postgresql.org" Subject: Re: verify checksums online Message-ID: <20250418151826.11f54034@ardentperf.com> In-Reply-To: References: <20250418141817.2457ac8d@ardentperf.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 18 Apr 2025 17:32:19 -0400 Ron Johnson wrote: > On Fri, Apr 18, 2025 at 5:18=E2=80=AFPM Jeremy Schneider > wrote: >=20 > > 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? > > >=20 > https://www.postgresql.org/docs/17/app-pgchecksums.html >=20 > "The server must be shut down cleanly before running pg_checksums." Yes I read the docs. This utility has evolved over time including a complete rename, and I was just doublechecking here that we didn't miss a doc update in case this sentence applied to enable/disable but not to verify. As I said I'm assuming it's all accurate but just doing the paranoid double-check -Jeremy