Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOWVf-0001Mp-UC for pgsql-docs@arkaria.postgresql.org; Thu, 18 Aug 2022 03:47:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1oOWVe-00067p-Qu for pgsql-docs@arkaria.postgresql.org; Thu, 18 Aug 2022 03:47:54 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOWVe-00067g-If for pgsql-docs@lists.postgresql.org; Thu, 18 Aug 2022 03:47:54 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1oOWVc-0003xP-8x for pgsql-docs@lists.postgresql.org; Thu, 18 Aug 2022 03:47:53 +0000 Received: from compute4.internal (compute4.nyi.internal [10.202.2.44]) by mailout.nyi.internal (Postfix) with ESMTP id 836B55C015C; Wed, 17 Aug 2022 23:47:51 -0400 (EDT) Received: from mailfrontend1 ([10.202.2.162]) by compute4.internal (MEProxy); Wed, 17 Aug 2022 23:47:51 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm1; t=1660794471; x=1660880871; bh=2RiMbTnEO/ rrR23uIn49OaKCLNr+Fcv+CkuMSdE0UhQ=; b=jTRpVkT+FBa0GnZrOe79kQyeIP Uf/Mbj2MJnxtjhYgAeybLjIVc3u6lL39i2gjo3J29Yhqnsfr7WyX9z382JosqSvK 4OVYUK0Hhpyn4EyrpeyMyn5HpIBoQq/mNe6/AOHZZcuvEO/LIFFRO6WEMJ2TRpGh dAvpaj0pY0d1pFUuONFnaHUE0jrNpBdSULq8COZDUZLDTJzQF0XRM9s7JVC0hBqD pzRjNvc3F1o+vfpes+xWCOsL4W4egJ0IEhRp2St8eMiBqEu1Mx9MoYVUrro67mIC NpJ7djqm789d8i6n1WDOLdFIqfipHe0mhXKt+wt7eSoZq5ZUCK8ZpR/jH8Kg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1660794471; x=1660880871; bh=2RiMbTnEO/rrR23uIn49OaKCLNr+ Fcv+CkuMSdE0UhQ=; b=CJE2uXwiS+dcl2+dVnQWjKJwJv4ZtopI4A8UwLgZDsme Ji91Nr7n8HRgiRJebuCTIFUgKCLwd2x4yepiAWOLlddBC0N1LTgYXFdnwZj4pcUA oolr2uudxyjGJ6wZAiLq4NVKfsiwyVYdaapXF1LKTkJ0wtj3gul8Ruw0N4wPqb84 6Xhez0tF9R9gMn6zq3LNelGjool3pBS/wwObW4hWNORzG+/xzA6OnILzAZ9OlbUT pNgIAXFden7qxXuz8hZ0zg7tL5g5qjr8gOWEAMjTI/rn5vGY3q7qmPfwiz/kkwJN vs9CiGS5W+ASqPgjsuoI//3u2AW+Ptt2czbVu0OICA== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrvdehjedgjeejucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucgfrhhlucfvnfffucdljedtmdenucfjughrpeffhf fvvefukfhfgggtuggjsehgtderredttdejnecuhfhrohhmpefoihgthhgrvghlucfrrghq uhhivghruceomhhitghhrggvlhesphgrqhhuihgvrhdrgiihiieqnecuggftrfgrthhtvg hrnhepveetjefgjeevgedukeehieeuieeuieevueeiudegheevuefggfduueelgeelieet necuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepmhhitg hhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 17 Aug 2022 23:47:50 -0400 (EDT) Date: Thu, 18 Aug 2022 12:47:47 +0900 From: Michael Paquier To: =?utf-8?B?0JzQsNC60YHQuNC8INCv0LHQu9C+0LrQvtCy?= Cc: pgsql-docs@lists.postgresql.org Subject: Re: PostgreSQL 15 minor documentation improvements Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="RRrTvNa9bKzTBMtG" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --RRrTvNa9bKzTBMtG Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Aug 17, 2022 at 06:09:13PM +0300, =D0=9C=D0=B0=D0=BA=D1=81=D0=B8=D0= =BC =D0=AF=D0=B1=D0=BB=D0=BE=D0=BA=D0=BE=D0=B2 wrote: > I have prepared a small patch with possible changes of these places, and > also a separate patch with some improvements concerning missed/inapt tags. > Please have a look. archive_command is used only when archive_library is not set AFAIK, but an archive_library could also freely use an archive_command if it wishes to. But, yes, I agree that the current wording in backup.sgml is kind of confusing because of this reason, so I am fine to have a reference to both archive_library *and* archive_command in this area of the docs. All WAL records required for the backup must contain sufficient full-p= age writes, which requires you to enable full_page_writes on th= e primary and - not to use a tool in your archive_library to remove - full-page writes from WAL files. + not to use a tool to remove full-page writes from WAL files. Hmm. My opinion here is to do a simplification, and remove simply the last part of the paragraph about tools that manipulate WAL files as the first sentence makes it clear, in my opinion, that if those FPWs are not around the server could become kaput. Most of the changes in PGSQL15_tags_fix.patch seem right to me. Still, you'd better check that the docs compile, as of: > --- a/doc/src/sgml/basebackup-to-shell.sgml > +++ b/doc/src/sgml/basebackup-to-shell.sgml > @@ -12,9 +12,9 @@ > called shell. This makes it possible to run > pg_basebackup --target=3Dshell or, depending on how= this > module is configured, > - pg_basebackup --target=3Dshell:DETAIL_STRING, and c= ause > - a server command chosen by the server administrator to be executed for > - each tar archive generated by the backup process. The command will rec= eive > + pg_basebackup --target=3Dshell:DETAIL_STRING, I am pretty sure that this line is going to cause a compilation failure of the docs. Anyway, this should be use a markup, no? -- Michael --RRrTvNa9bKzTBMtG Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmL9tmMACgkQnvQgOdby QH2gZQ//S/dfZpZOfu5G6T+gbjW3ep9FYTswkN1GuiOePRp3Y01a62fDvU9YkXJh xlQJ9Q4pcCvpYfvkf68dI1RJVe0rWmnfnkYN32TIIwZ+3H8Y/XiTR7lrwRbfjvju PqITQkdWt6ugYzLarfIqdLd5rudsBPEbl6HZvUBS3m8l/mu0YJakDFRrDZZkYemd jVu/4pLe7inqh2nDTpPH1/JGcHGRgkCK9qEPJ8dySnYenjCpxLFSuwbYbgdgDVrN xc17wPIelb3hBNj/DoFVAbueXee4TwpWea9JhbvzllMcVVz/A5wCluLs6jXr6MdZ FOVCnVnKiLb1cmsFkmJt4uv8TlLOgq9Z/yLkQwhtZF29Ia3O6iASI1I092OjT80H U0damPwsqblC98X3k1LeDyhfnmUhM8JARrEHHVnd6VoYkXhcn2t42KJui89rVXNN IA+oMHekSUI2yaerQ0IKB/VUisqdLsDeWeXiUzDJwOmlMJVvKTm9XsgbmuVt76x5 SlT9SBQY23jOZqWAPeuNG6V3yLSvUYzNE8kt1U456LmOlUGHU4EXyxZbt0fT+mP2 fovK9tgrwz9qzoTzdogX5WH4pjAXeDGEd0xX78fWqcTQoX48bkGPDlx9Hpvs/6Xq atQomvRQltDl0fl+tZP9HbFK5zKaK4qMlVOpDez+WQIyYMQD1VE= =Lkq+ -----END PGP SIGNATURE----- --RRrTvNa9bKzTBMtG--