Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ckwq0-0000on-Fw for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Mar 2017 17:54:24 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1ckwpz-00032e-RA for pgsql-hackers@arkaria.postgresql.org; Mon, 06 Mar 2017 17:54:23 +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_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ckwpz-00032U-7c for pgsql-hackers@postgresql.org; Mon, 06 Mar 2017 17:54:23 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by magus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ckwps-0000Yw-B1 for pgsql-hackers@postgresql.org; Mon, 06 Mar 2017 17:54:22 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 232565F796; Mon, 6 Mar 2017 12:53:13 -0500 (EST) Date: Mon, 6 Mar 2017 12:53:13 -0500 From: Stephen Frost To: Robert Haas Cc: David Steele , Michael Paquier , Pg Hackers Subject: Re: PATCH: Make pg_stop_backup() archive wait optional Message-ID: <20170306175312.GX9812@tamriel.snowman.net> References: <758e3fd1-45b4-5e28-75cd-e9e7f93a4c02@pgmasters.net> <35b7530c-68ce-7090-e13c-e39e4dac9bca@pgmasters.net> <967b90bd-6b65-a18a-5266-bfa9191c40e6@pgmasters.net> <0f46c90e-2884-59be-69bf-8f467d4c9ba2@pgmasters.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="P4iVvP27TPzU8KQW" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 12:52:10 up 240 days, 19:16, 15 users, load average: 0.06, 0.11, 0.13 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org --P4iVvP27TPzU8KQW Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Robert, all, * Robert Haas (robertmhaas@gmail.com) wrote: > On Sat, Mar 4, 2017 at 9:12 AM, David Steele wrote: > > Yes, that makes sense. Attached are two patches as requested: > > > > 01 - Just marks pg_stop_backup() variants as parallel restricted > > 02 - Add the wait_for_archive param to pg_stop_backup(). > > > > These apply cleanly on 272adf4. >=20 > Committed 01. Nobody's offered an opinion about 02 yet, so I'm not > going to commit that, but one minor nitpick: >=20 > + WAL to be archived. This behavior is only useful for backup > + software which independently monitors WAL archiving, otherwise WAL > + required to make the backup consistent might be missing and make the= backup >=20 > I think this should really say "...which independently monitors WAL > archiving. Otherwise, WAL..." Regarding 02, I certainly see that as valuable for the reasons which David outlined in his initial email. I can certainly take point on getting it committed, but I wouldn't complain if someone else does either. Thanks! Stephen --P4iVvP27TPzU8KQW Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYvaIIAAoJEO1sijiDR2RVkGsQAJ5CB3vp87JmDSh5M0xKlesY s0qvE4GdpHtg9iOE+OZhtunV+9ppkHvBQdsW6HRXN7tQFNojOtkLLHGc+KZlUqnO LjgrcalZWodbxqbJTZgj96HiXLP/WoDSTI2tBuCI/ym5qRamJL7SlqGm9bKYZx+h E9pyYzLtch/CAQmNSh7nIdy89ZyoSBqykYZaTfKqW/7gFfuhzBLmCqLMEur/9g6r qH6FJ6nJdcI4WSo3GCEkm1hSyaxrLlTQNP27aZrcWEyTvX6hbxazubJK9GuFeWmF /oOKS3Kl7Xayt5Hy4dUgPjtZM2gpfymXpRj7b+Pkv7602tAc+goS3Sv9hAh0Dp6z eM23GaXo6xE/tj/0k9EeU/mx9CBPtfk0ENL9mSoWaEW+S6jEW5KbytVkB+gC9Rjl scCq9R0ZAqXZ0kr9YIVD9/WYlSdjgaVvsD6oWpUGAYNeTNL7Tl1xp/3re8hO7qkn D/S7sri9Z5yqIH/S08Cq3YCzGP+oeE2Hbf7Ks0sCxewr/VFqFAyDpUZeMBz6spHK nIMR+CzKnHykLbFHvDJM1ezvU89WlxwkDxnsxjCD+doQ7x81LlZUTT3aYF1HsRb+ Jr35Ee4Eo5N7mWEDkfxPMf6iJdutZzX79JgwNVU4CK1eIOw7hmr4Xih6yrERv5cv a3s0iel/CGnz94fNw8cg =WotV -----END PGP SIGNATURE----- --P4iVvP27TPzU8KQW--