Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hDHx6-0004Vr-Lx for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Apr 2019 00:15:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hDHx4-0007TL-VQ for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Apr 2019 00:15:54 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hDHx4-0007TE-GH for pgsql-hackers@lists.postgresql.org; Mon, 08 Apr 2019 00:15:54 +0000 Received: from mail-it1-x133.google.com ([2607:f8b0:4864:20::133]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hDHx1-0007Uh-3z for pgsql-hackers@postgresql.org; Mon, 08 Apr 2019 00:15:53 +0000 Received: by mail-it1-x133.google.com with SMTP id k64so18149219itb.5 for ; Sun, 07 Apr 2019 17:15:50 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=telsasoft-com.20150623.gappssmtp.com; s=20150623; h=date:from:to:cc:subject:message-id:references:mime-version :content-disposition:in-reply-to:user-agent; bh=9FcRf4pXZ7H8CBsH+3WriKimVJFImgLxuVCgLnyDdFo=; b=B0K9hATIsQ3xW7mtqdmVSCQsCv48JJ7jS7DJunAzIJOc0eS416LjyeqX4INeofwyNK cWULtkzOZ1ulDHC9bPPHE2fVc7rvYCuniAktTGsHMhX+iPdGs432NaYRM0LXdp6LtojO szkWzOa2gVmBvqUIph14GX6EX2Rr68g+zuMEPMqucr1kqq0JOgY1Udh2kaaJK0J7v9XO 7vqgODWKR3d/doslTKCl/Ctc/2r3zSY91Ys7/86JBkWivS5zW2Muok8UTqukculpEGbk F9TDJkrKd0BPjiNqVjuzh5GjX7SVRz2ilThzezs3UXSZeMbF/oMDadfSNio92v6Tk5RT nwLQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:date:from:to:cc:subject:message-id:references :mime-version:content-disposition:in-reply-to:user-agent; bh=9FcRf4pXZ7H8CBsH+3WriKimVJFImgLxuVCgLnyDdFo=; b=Fai7d4ZSsGU9pP3tckb0ryRFyGYIeX+LYWjImOyBQjTiisA8cTKz29CNRVNPAzv/TI rgmTaUGhxsRlxSOSEJXnrtC8itURqfSiJVWyvJnvvtdontv/yhoMFAj4/FUt02x4lpVI DIWWRpybMAsteKMCbE0t9ZP4optwHLuqhHwVFFNItgvK7SA2x5H74ixbPeoYDnRM6aFl GxEnFPoPLNfjkXotgtbBL8d2uNyL6VKj7Ux2FK/QYp0CY3B0Mad4HtsVjbQU7J88m9+Q Bu3q8w0BlTGlBbtqP2NCz/nWkrtntskHuCtt59PuFK/ub2CrThTMwJuJjTOrjsTXPF2+ UMGQ== X-Gm-Message-State: APjAAAWcH+D9OzuAfSvwJ/mraPjLkBlr72oFu0KOc5ymLX+aeAxobjxF hN3YpTwZFqsLu0ezPPQkYVWZtA== X-Google-Smtp-Source: APXvYqyMsyKr0pVmr0eHV/nBPaSvjvWFm3WWiBgxD09wR/OwjK60KmcZ7sb5gbntRDDtuMM4ZKkC6g== X-Received: by 2002:a02:b097:: with SMTP id v23mr19217613jah.42.1554682548909; Sun, 07 Apr 2019 17:15:48 -0700 (PDT) Received: from pryzbyj (charmander.telsasoft.com. [50.244.222.1]) by smtp.gmail.com with ESMTPSA id m30sm4228694iti.41.2019.04.07.17.15.47 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Sun, 07 Apr 2019 17:15:47 -0700 (PDT) Received: by pryzbyj (Postfix, from userid 1000) id D9800801065; Sun, 7 Apr 2019 19:15:46 -0500 (CDT) Date: Sun, 7 Apr 2019 19:15:46 -0500 From: Justin Pryzby To: Michael Paquier Cc: pgsql-hackers@postgresql.org Subject: Re: clean up pg_checksums.sgml Message-ID: <20190408001546.GD10080@telsasoft.com> References: <20190329143210.GI5815@telsasoft.com> <20190330015123.GP1954@paquier.xyz> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="WYTEVAkct0FjGQmd" Content-Disposition: inline In-Reply-To: <20190330015123.GP1954@paquier.xyz> User-Agent: Mutt/1.5.23 (2014-03-12) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --WYTEVAkct0FjGQmd Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Mar 30, 2019 at 10:51:23AM +0900, Michael Paquier wrote: > On Fri, Mar 29, 2019 at 09:32:10AM -0500, Justin Pryzby wrote: > > PFA patch with minor improvements to documentation. > > Patch does not apply, and I have reworded the last paragraph about > failures while operating. Sorry, the patch was on top of an brief effort I made to rename "check checksums" to "verify checksums", before asking about the idea. PFA patch to master. Justin > > Also, what do you think about changing user-facing language from > > "check checksum" to "verify checksum" ? I see that commit ed308d78 > > actually moved in the other direction, but I preferred "verify". > > Yes, that's a debate that we had during the discussion for the new > switches, and we have decided to use --check over --verify for the > default option. On the one hand, "Check checksums" is rather > redundant, but that's more consistent with the option name. "Verify > checksums" is perhaps more elegant. My opinion is that having some > consistency between the option names and the docs is nicer. --WYTEVAkct0FjGQmd Content-Type: text/x-diff; charset=us-ascii Content-Disposition: attachment; filename="0001-Clean-up-pg_checksums.sgml.patch" From f151f8200c65f4a3ae61afe444f213e190e94013 Mon Sep 17 00:00:00 2001 From: Justin Pryzby Date: Thu, 28 Mar 2019 19:20:52 -0500 Subject: [PATCH] Clean up pg_checksums.sgml --- doc/src/sgml/ref/pg_checksums.sgml | 18 +++++++++--------- 1 file changed, 9 insertions(+), 9 deletions(-) diff --git a/doc/src/sgml/ref/pg_checksums.sgml b/doc/src/sgml/ref/pg_checksums.sgml index 47d4a62..01c65fe 100644 --- a/doc/src/sgml/ref/pg_checksums.sgml +++ b/doc/src/sgml/ref/pg_checksums.sgml @@ -39,15 +39,16 @@ PostgreSQL documentation pg_checksums checks, enables or disables data checksums in a PostgreSQL cluster. The server must be shut down cleanly before running - pg_checksums. The exit status is zero if there - are no checksum errors when checking them, and nonzero if at least one - checksum failure is detected. If enabling or disabling checksums, the + pg_checksums. When verifying checksums, the exit + status is zero if there are no checksum errors, and nonzero if at least one + checksum failure is detected. When enabling or disabling checksums, the exit status is nonzero if the operation failed. - While checking or enabling checksums needs to scan or write every file in - the cluster, disabling checksums will only update the file + When verifying checksums, every file in the cluster is scanned; + When enabling checksums, every file in the cluster is also rewritten. + Disabling checksums only updates the file pg_control. @@ -218,10 +219,9 @@ PostgreSQL documentation If pg_checksums is aborted or killed while - enabling or disabling checksums, the cluster will keep the same - configuration for data checksums as before the operation attempted. - pg_checksums can be restarted to - attempt again the same operation. + enabling or disabling checksums, the cluster's checksum state will be + unchanged, and pg_checksums would need to be + rerun and start its operation from scratch. -- 2.1.4 --WYTEVAkct0FjGQmd--