Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cjFu2-0001OD-N3 for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Mar 2017 01:51:34 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cjFu2-0003Lc-9b for pgsql-hackers@arkaria.postgresql.org; Thu, 02 Mar 2017 01:51:34 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cjFsS-00086c-Hn for pgsql-hackers@postgresql.org; Thu, 02 Mar 2017 01:49:56 +0000 Received: from mail-bn3nam01on0068.outbound.protection.outlook.com ([104.47.33.68] helo=NAM01-BN3-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cjFsN-0001Bd-Lg for pgsql-hackers@postgresql.org; Thu, 02 Mar 2017 01:49:55 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=BlueTreble.onmicrosoft.com; s=selector1-bluetreble-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version; bh=bVhDBHDxMcyrSHrVO7IeGOLgDnJYpv5CwHYKC5vJ6vs=; b=mHfZxL1P3RltxsrjPcVmiTMCvf3InZ/eh04iEsRevtOy8DCZpUahytX9VKymkgJIoCIXCsROGM1CiyUSeCPuS4ncwjw6B/A6nBFa7rUO2WdF1PbFPcEKpV/3Apj3N/OSGBnY3WH1FIuJ4Fp14FWKPGXC1c50LJKM1BgmrdhKM+g= Authentication-Results: postgresql.org; dkim=none (message not signed) header.d=none;postgresql.org; dmarc=none action=none header.from=BlueTreble.com; Received: from decina.local (24.205.140.236) by MWHPR11MB1645.namprd11.prod.outlook.com (10.172.55.10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.933.12; Thu, 2 Mar 2017 01:49:49 +0000 Subject: Re: PATCH: Make pg_stop_backup() archive wait optional To: David Steele , Pg Hackers References: <758e3fd1-45b4-5e28-75cd-e9e7f93a4c02@pgmasters.net> From: Jim Nasby Message-ID: Date: Wed, 1 Mar 2017 16:11:49 -0600 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0) Gecko/20100101 Thunderbird/45.7.1 MIME-Version: 1.0 In-Reply-To: <758e3fd1-45b4-5e28-75cd-e9e7f93a4c02@pgmasters.net> Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [24.205.140.236] X-ClientProxiedBy: MWHPR1201CA0004.namprd12.prod.outlook.com (10.174.253.14) To MWHPR11MB1645.namprd11.prod.outlook.com (10.172.55.10) X-MS-Office365-Filtering-Correlation-Id: 9e44f99a-7b88-450a-9191-08d4610e699c X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:MWHPR11MB1645; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;3:PFCyCxOg/uELXQm1FVkbjX68Yyxz52pZD/lwYBXV88/z18yTUQv7P84+C+LqfLs9lM8UsT3+jbcYPwA9yZP+t0IZq0twO1CKnj9JnUcA7ZMD3W988KT+bbiodmcn1HJd0zw+FPA8j64eoES8q+8il4v8AyD1bthSVxsMFWjOv0pueCNoCyrWDVC3VdjnhowuTQoQd91dYybKFCr4zK92oik21SKhoyT9t72QUk3LNiNHoM82kLwkhVoxgxiEEYOirdA/4hpvbaFAjG0pIErHCA==;25:MIBjmDBPCkNn4aBoTcKBB2FMRS+Dq2g+GHS2VcUVbsm0CurZoLCO46WFY5BKf6nEjBgS0P3XA6brpCmG7RejsgKrYiNYXWBOipk9TubLkFgCnZ1vl72o3Tm8QOu70EMVn5/n538PA8FqF+RtQKiaWp8MMJpuLNQmRyvasyoH2bFy9F4zeCLaz5c0E/uR+hYlLinHVJrN5zPLmN7pxnaoeFNZle1Ifm2AtjRjSK1f/OGRazU7wdNr1m3HHnJGzQhqO1wfoUs9QGR9QikvGcJ9/H++0JAeYRBghF47d4PpluXmKTYrHTkt29LVQRb7a+a4LYgrsDbjJQ2oMcF2DZ4QFCWohSjzm6ru+alrAruohcXFlzumQDP70NjvMi2FtTxDz1XDmqHY9irrnfz1YOtwS5jkd7RzxLbg0TRVRHHRYIxC3Fw25x4KQwpdG4Ptw86BT41dXVMBVfOMML3jTnkRsA== X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;31:L8w2mXZywPkr3ylBgWAu35s5f0fkGKDwylbaMzsi3w9w1Ix9Yv9QnNQYa7uCXSCB4UUgQv5nc8H36bJc7S39NJU4pgDMIzcNR4jaddO4NSfPDyWSakSka73YZHL5NabvkSLCU7WZEQyN9/tns9AWFNmbcOaNMg5oCzL0/xJ1E0gxTG7Aeb0U3UC9xFDKjGDKGLAa5o/iqSbCUX/QtIDl6Z/XS1oPcvpSl32UkB6mG9AHwqM0HWU5JDG25fu9WFJTQb8cz35NR+bp4TgCokMKXACUK3JT6qiCrcb9ziR7KDk= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:; X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041248)(2016111802025)(20161123558025)(20161123564025)(20161123555025)(20161123560025)(20161123562025)(6043046)(6072148);SRVR:MWHPR11MB1645;BCL:0;PCL:0;RULEID:;SRVR:MWHPR11MB1645; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;4:5fp0B7kxFHd3jx0ZkkVx9PaLiYWgXgiDvlz3LX/eBNfCnS4pU8Zyu6fFGKcIBXUWItB6kJcRs7HfL/g4cnkdKQ5c90EAApGpyRtJZQ4DqM7fzTjHrVEKUmagEcIG+XY+mDpHIyW8eVPybwq8PoSz6qfGOCUFgJuHWwfrJdGfY36CF6HvolKEArBj/ZAF0q8iuHWexxHKOvA9GEBg1tfGsWc/yNkFTjUk0L5Mnh1d16LriW4a1q8wikIBT2Ibu4DINFsfJAmUN67Vj8ZdFuZFr0CWBVzb3IWxQKvxatrBIJnZ7rzu2t0f2RFKFlopQtTVBXtfgv1x735Onp+PBLAcDCUntru709FkavEy322MEGgRRBaoVYcL3RKcxEqeWZWrMfNO6SRsXFZhYi60nPziRY7L0toZOmQ9He+ZxPKkFyKHwENwK2FzWxhQ3QdRVBg7Gg/hvGD5VdWLbSF4PaPjMZVETOB2e1i37E22FVgelBa9MZYchYvfttavou5sGovLMj0ZW/xvSXUMp5pJgd1rTlo3O0veqNj7HDLr7Z0jNP8QIMlU+1/Ffq3rMdkVbQaUTnM/A/j756wTECLixvmKuHHH6Xo9qfBCr0+dhRN2fSzqIxuI2J8gPWpg0V3mJk/g1aNNXbLvvi34a3SlXEh1r+14PPbxDADX14CsV/H6wXQ= X-Forefront-PRVS: 023495660C X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39450400003)(39830400002)(39410400002)(377454003)(24454002)(8676002)(6116002)(2950100002)(3846002)(6306002)(6486002)(189998001)(25786008)(33646002)(6506006)(47776003)(86362001)(36756003)(31696002)(229853002)(92566002)(76176999)(2906002)(50986999)(50466002)(81166006)(54356999)(966004)(53936002)(65956001)(65806001)(6246003)(305945005)(23676002)(6512007)(64126003)(53546006)(5660300001)(65826007)(230700001)(83506001)(38730400002)(42186005)(31686004)(7736002)(53386004)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:MWHPR11MB1645;H:decina.local;FPR:;SPF:None;MLV:sfv;LANG:en; X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtNV0hQUjExTUIxNjQ1OzIzOkpaUkVZSjRLNG4xRm1MZjNwcElpbUhHWXF0?= =?utf-8?B?RWphUzlwVW5md3BIUitnSTZNeXNsZ0loNTFvQUZmVzk3RUREUjVxS1RKaDdi?= =?utf-8?B?TjJTcklxMXNkSVVXNzFNbFQ4R3ZQR2tNeG5LamNQaFNRYXoxUkVPWDJ4NnVY?= =?utf-8?B?VnBXVmV6dWE4d2Y2WWlwNC95ckl3NVE2bUlMVWtNRWdNS1RsWlFJdHZYTVJr?= =?utf-8?B?MzI4WXdEV3FGRWQ1OVlmTXRpVnZSS0RReHJOckxIYXZzaFk1QXF0WE42bEcv?= =?utf-8?B?bmZxVHdVNkp2TU0zQ1lNWE1LL1NZTjN1TVE5YXNHdGNzVUYwWDljYkl0NUlx?= =?utf-8?B?Qk1Rc3cwNm5MZFNqUjAyMGU0cm1BYjZQZytZUHlUWEtCQjFGWGNOR25aTm83?= =?utf-8?B?VnE1WDNyRG5ueFB4WU8rYUJVc0RpYTZEUjBDSzNMT1JRT0x2eFFyeWpTRngv?= =?utf-8?B?Q2x1YWtQSHdKaWEvMnVOMHVoY2NWUFp3bWNqeFdEcWhaM29xNFJpWnNnUitz?= =?utf-8?B?M3VWK0E1ZGUwNXI2dnYyd20wV0pocVN4SStoQWxmU0doRndjWHM5SzB2UUFv?= =?utf-8?B?NUwrZXg2M1RIbEx1Sm1vMHY2VE1QOHByNE91T05pckpTZzVtYWtUYXB4NkRQ?= =?utf-8?B?SmhjT25jM1MrbExTck4wVWtyZDk5VXlTV29tV2F6U0xyWWZhRXBXSXRtWmxx?= =?utf-8?B?NVVDdGw4ZE5jeDAydzZXd1NMWXZBeGpmWVhMekxnVG50eGVtRWVvUk1hYXo4?= =?utf-8?B?VHhJV2FjdUJ2OTloaG1mUFJjRHRFcUJXM1FPeEpQQkFNN0s5STI4OTlRZXpt?= =?utf-8?B?aWpjR0xJN05CRVArbWZESkdpcytuZ2RMODVwcVkwcXZGekVzek5QZTN0NWlS?= =?utf-8?B?N2QyNnpvZ2d1N0cvRnJkOVZteHpXekhGOEcybXFPNUZtcjZnVmhEd242Zk8w?= =?utf-8?B?TUh0UGw2SmRnZnRHQ0tuV1N3bGhpaUp2dE91eHhhNWdwRE1LM1BDbE5HdE5j?= =?utf-8?B?b2hyWkxEMUhhcWhCcTFiZkJZRDBwWFhudkR0Q1hGcjFyNDk1d3FoRjJHUkp4?= =?utf-8?B?Wi8ybkpqYUMzQVNqV1ovNktYcWs4b3BHbDNsNGx5Z2UzRjZuV1F4MlhqT1Na?= =?utf-8?B?SjNvUXU1WjJVWFhjYnJxQmNjVTlJd3Eyb05nV3dSWUV1TE15S1EyVjVtRFJO?= =?utf-8?B?djBFYmxKT3lnQlVmdHlwN1VreVh2U0JXUFFkN3RxY1lqUDA0RGVmTldkRzdt?= =?utf-8?B?aWgyUzlDK1dNWjJIeFM2c3YrVVJJZkpMM2ZyRm41VjIzbnBtYkhuRTVXQWEx?= =?utf-8?B?eTIxaDQxRGJmM1p5N3BxMCtiRmRsMDhZV1o4QnE5Z25OWVVMR0FhQkU4aGoz?= =?utf-8?B?VVB6eEdmaHpac0JoOFF1MnBYZXRqNjFYT1c1RnVQMk40azBLSlB4YUZMN3Fp?= =?utf-8?B?TnFXS2drLzE4clA3M3VXZFR5U0lWTHZyYTBwMlBDQUNiWmRlL0srYk5temlW?= =?utf-8?B?UGk4d1R6TEsrL0ljc3BoMmJDVDZEV1p6TzE0VTZCSnBPVkdhSm5GQ0NFWEJ0?= =?utf-8?B?SkZVdXV6aXcyWFRxOVUreDRSV2pKTmRWekJyUndLWmpkbHkwbFVlQXdkZHNt?= =?utf-8?Q?Jy5O7G2QOg3xjENpiGhv?= X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;6:hB7WQ/xRLjRKlnFDAYKTdQQD611mZfS76hFLIBT8GgUn6t+fOufyOlJ85mbzggzmWqqqg7XV5lsjk+V2qejBSyWZuSPlE3GOllkPnNpWaQ4BtEa2+LfdcX5GaT4HZIOBvHu1BrsLeb5tz1DXhrMpW/lakDsWxKqkr5V5dqprHkSGYpbCLiIW/pv1GFlN0TPrXJz+6QbrKh0DYVRJUS6BDqUOvxWdJxTxE7JexplwhevnQ27duLbcD89TjAwlYm/MZrE4TJXAz2vaEm8XUyDGIqlCfeRvqpbVX7aqAgOewWqG0fx81bbNwKU20xOsxDZ+F/va8IquG5pKjktHs3ysn4h8K8kwrTAs+N3DAAEzTo/DUCcC9uuWI/+hEJsoID9mMcu1n23NDUWN6Bo1ee8amQ==;5:iftD5eZjFKasNJ6jVF1xnL2/0yJiEAzX0e0+yiryTsZts9ASB52QrJkS0tgNuen36wfrWnqEtpCR5lGQWgVEcuy1GkD931GOCKIWcVa9fHYpeFKMjSnW1g65wEMko4WHsf/TExtIUzHBDWFCN/TxFQ==;24:9sZ/nMtsogkUt0AtKrczVuOrXvT58XYjHWAyiB8AYhh5/dvJxqJF2eJAu5kgM+EkXcblmCUBEpuNK/s2fkNKihS1c+ANWBjPm+Pwh71oyNw= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1645;7:ZtHZrDEAIbiqTEQVkGz6WldX1a+n1FB6FjRqQYg6sfj31hQmW/zcpqpANdI74YyvKraIpb+VfloDToRIWoBnNCt8DlADBs590BStw9YVgrKzjKn7iDFcTpd3mbrvbBSdi8I26Gzp5PFGE3/eciaVVtXQL7i1bYrxPsoVBj/Aksd697mr48SwdA5u7BuKtUpNerCsvJSo71pYTzYUjtKrDQstPFSIjuRaoizGYApOoi5YgrJFhbOdX0+0AphD1wlbtuzHeAydbnOS7H97K65UjnkCVRL8ePIOmHvO9m1gFAqpsldXb1X9IcsnagGLNsn9pu/yVXOBPllPuMSW1A674g== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 02 Mar 2017 01:49:49.0713 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR11MB1645 X-Pg-Spam-Score: -0.3 (/) 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 On 2/27/17 6:25 PM, David Steele wrote: > The purpose of this patch is to make waiting for archive optional, with > the default being the current behavior, i.e., to wait for all WAL to be > archived. This functionality is already used internally by > pg_basebackup, so the only real change is to expose it through the > pg_stop_backup() function. Do the docs mention anywhere how to monitor WAL archiving to know if you've got all the necessary WAL? Perhaps a function to do that would be worth adding. -- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com 855-TREBLE2 (855-873-2532) -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers