Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cepoZ-0006b9-FP for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Feb 2017 21:11:39 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cepoZ-0007OG-2Q for pgsql-hackers@arkaria.postgresql.org; Fri, 17 Feb 2017 21:11:39 +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 1cepn9-0004t7-7M for pgsql-hackers@postgresql.org; Fri, 17 Feb 2017 21:10:11 +0000 Received: from mail-co1nam03on0046.outbound.protection.outlook.com ([104.47.40.46] helo=NAM03-CO1-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 1cepn5-0006mM-JX for pgsql-hackers@postgresql.org; Fri, 17 Feb 2017 21:10:09 +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=vbZ757uYg0wmBsT6QY1mkmyyDfns751CzKGy3I1jpiQ=; b=MTolAffw2Ny/0xGs9kmPNgxcqqeHQ7gQvwvwpMKVuZQGB4ho9o/uDKdONOkd9LzwLHF348kvdlltRND4k8HZ0JIaV2ld98MrBDpG8FvpI7lqk46zvW5iCT6+OVC3xroMukAD2kJ5K7XAK0qJ/9gR53qc+kO6lXhYZnzQnal9OtU= Authentication-Results: spf=none (sender IP is ) smtp.mailfrom=Jim.Nasby@bluetreble.com; Received: from decina.local (70.113.18.142) by MWHPR11MB1647.namprd11.prod.outlook.com (10.172.55.12) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_CBC_SHA384_P384) id 15.1.888.16; Fri, 17 Feb 2017 21:10:00 +0000 Subject: Re: gitlab post-mortem: pg_basebackup waiting for checkpoint To: Robert Haas , Alvaro Herrera References: <20170214210651.ldwzk6frxxclbomw@alvherre.pgsql> CC: Magnus Hagander , Michael Banck , Pg Hackers From: Jim Nasby Message-ID: Date: Fri, 17 Feb 2017 13:17:02 -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: Content-Type: text/plain; charset="utf-8"; format=flowed Content-Transfer-Encoding: 7bit X-Originating-IP: [70.113.18.142] X-ClientProxiedBy: DM5PR15CA0013.namprd15.prod.outlook.com (10.173.207.151) To MWHPR11MB1647.namprd11.prod.outlook.com (10.172.55.12) X-MS-Office365-Filtering-Correlation-Id: 93fcd8db-14e7-44a5-f729-08d4577957d9 X-Microsoft-Antispam: UriScan:;BCL:0;PCL:0;RULEID:(22001);SRVR:MWHPR11MB1647; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1647;3:YDrJxgQgUMZuXD5GsdX+qzNh46/oP8fe3vtSS2a7t+kvHAwDoxTr/hq4zxUDdk/z4WySqzzLy7ZjFV28Y/CtL/JKn4kjmjNyPbttDAnz4c2jNY+RfhfCv9aIjlZrkq5axuWJ9ergwBRgyGKCpE1R9Rwby13TVMqngJ8evRDsqXoAfqS4TQiz82LWYlbGhla09vdHspSfFp9mdsiTN6T0PUx/kdomBem5HN1zux95wzwbL/ivylGfO1RSZysFqZAvXRrZrn0d6v5eN83klFDzCw==;25:XKmO30r8C1o8E8Ae8yZH+vLNQfX/M95ul/r5d2b12qTAPxUSJe18xAKVC7yst5A0TQ/TusLkAdy/SSd5dqsGu8jjCfmYz73CVXR/K+t3UeNMm2xP3MbbRyQUqMvOjSs2/0FHvd2osQMndDD19iAShZugR7pXsCdWygYRfcmNgtvQVqeKu5PIfZEHkW/D0kK2zfoUWajsw+dQUEz8/AbP/bYV0ae3eMiR/zGza/a655Js81ZkfG2Hm1dbcKZqEf2Vm8Vb5x/si/HvNts2/R39zImOsNhuD6CQ1w3pQF+wJAdYqG0qyzOuy6Q+P+kQGm/lqGMtL1Q4l+UQHCV/yjp2KRH4I/5MCVWg0Gc0SuU3HQCEJbF+AEpijs9PnVErbKSfdSW0auvZO4xA9n/e0IFMOJPfd5grnmdfEHjSPhVB+Yw2wVCvCdlSX7uMJwuVQbpNO0CW+Wxyo948Ixsx6xHCwQ== X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1647;31:2OQCeFjGNRlL1M7Tr/ucwsKrEe+oqS5yRHlFRr58GVIU89wTN1G+E2PyrkwFaAfUJkuAOFcGJWRucK8qG7hgSkuBiMuy+9k+M0IyXTr51DoxIN1eEjwcYEqGyU13efh72ZS5ogERPaWM5eMDG07kn7wet8A0d91hXK/Ujnj+ITxwhzCkZw5D+wFCGKOUOC1V7plYyX0cLKk1wUYA5Zq+iQMvm39mDiDrNb6a84ZM67erycoTJZAdwDqVUYAug5iW9HfYtTz+UwFAAt77sXH03/F7NzFUJ6sUSIGVBSsdzj4= X-Microsoft-Antispam-PRVS: X-Exchange-Antispam-Report-Test: UriScan:(158342451672863); X-Exchange-Antispam-Report-CFA-Test: BCL:0;PCL:0;RULEID:(6040375)(601004)(2401047)(8121501046)(5005006)(3002001)(10201501046)(6041248)(20161123560025)(20161123555025)(20161123562025)(2016111802025)(20161123558025)(20161123564025)(6072148)(6043046);SRVR:MWHPR11MB1647;BCL:0;PCL:0;RULEID:;SRVR:MWHPR11MB1647; X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1647;4:tpn0IUlVlDEDS4lLnWyybRy1mM79rqn1sz0CbkhRCTexYLBOxuWak/Dvnq5xUh/WZfmi4HvRck4tGGK0gm+CLsPll1y3SG6WGXiOUOQmIShmBfqAMe9d7GjB5MbXJNyvoK+N2H9dJMdqZ3GOCDfZJIKYzB8Wtf/RLObRUKxUquTb77vRbEqCOSH899kHqzYIyT1oOHDwgGNloj6dSNnQQLiJPOdIuoyf4nR1naVbu2LZP0J/ul3a/t/gdIxzaYQ3uN4+ep3AgcEo6HGUhJkdKxNC+gsLsVITASJ4t95UcyR65kSV7MTUxHfL3CeJtOwag9HAD1PWl294R4C06BCaSrX/tHli29MRsjxUOVTv3LH0OlaqkkybrZSqLcWFBMDuoq2YhPaK9WwNjFXv5BYwMVIvgGoVtgsCgEYwNfLwzbOKKudZRv2vYqTFj5Di4iWpegCQ7Grgo6dGd/vsDZw/idJcV6MGhpsMzGNqtspjXzyT9cdrKGYY42+S+eZCmMbi2c7xSCQUKfjC3UTVSAZ2lPmZGXn6ZG47neIOXZ3zrP7wnQ//ODT+FYo4Q5a5lFmzvMfJR0b/629WC0lSvbJ0zjYm+mcRM3/CDMulJbKPAacLyT33TixlsrRszlIYxyRGu0QJkmErA8dobIzM228Ln2s9F5l3MbNu7rYXEBx/9ka2RB69m/04Y1Ko1TL5C4NICstuo56U2f3+pFHdSs9IVA== X-Forefront-PRVS: 02213C82F8 X-Forefront-Antispam-Report: SFV:NSPM;SFS:(10009020)(4630300001)(6009001)(7916002)(39450400003)(39830400002)(39410400002)(199003)(24454002)(189002)(377454003)(5660300001)(33646002)(3846002)(229853002)(2906002)(92566002)(6246003)(4001350100001)(6116002)(68736007)(64126003)(101416001)(189998001)(81166006)(53386004)(38730400002)(97736004)(36756003)(76176999)(50986999)(81156014)(54356999)(8676002)(53546006)(83506001)(106356001)(86362001)(50466002)(54906002)(65806001)(65956001)(6306002)(6512007)(66066001)(53936002)(31686004)(4326007)(6486002)(25786008)(31696002)(6506006)(230700001)(966004)(305945005)(47776003)(105586002)(23676002)(42186005)(2950100002)(65826007)(7736002)(85282002);DIR:OUT;SFP:1101;SCL:1;SRVR:MWHPR11MB1647;H:decina.local;FPR:;SPF:None;PTR:InfoNoRecords;A:1;MX:1;LANG:en; Received-SPF: None (protection.outlook.com: bluetreble.com does not designate permitted sender hosts) X-Microsoft-Exchange-Diagnostics: =?utf-8?B?MTtNV0hQUjExTUIxNjQ3OzIzOndhUzMxclVyQ2pIVFJ4YU9vcVdpaXRYRDRs?= =?utf-8?B?cVJxVkJpTjVmNnpGbnJFT05TaFBVMUMrcnp1N2o5SE5TcW8yeGhqUDZoRFJx?= =?utf-8?B?dEh2UEV5bG1LRjFKUlJhclE4YmhSUVRCdFgyaytQMDI3UHNONGJNcGRuWkxT?= =?utf-8?B?VWFmM1IrNVhTK0UxZ0toeS9XR1J5WnBOa1ZrU0x4bzVZT3JzWGU3dlNZcWRT?= =?utf-8?B?WU8xQzBpUmtzWWlrQWF5Q09MS0Qxd2xhTXJUaHo0U2xwZXIzcHlTUk5YdHh3?= =?utf-8?B?VDlpK0dYSWFCWFhwWHB0VzVMQmFqMVpvS3BsbXNrcS9RMmNVM2hTak1EekV5?= =?utf-8?B?b3NvVTFSUjdXQmtsMGU4RWpDMDFVVUthbkhqcDhTeEZlWCt1UFY0NGZNaS8y?= =?utf-8?B?SG5KdmU3eExvdU9GYk8zbHFSdXhyd1lsVXZCUm90Y2hobmVEcEJMYU5lY2hC?= =?utf-8?B?aWZPaDVtUTJoSGROd1RVby83TkprNSsyYmlIK2tVelV2aDNObmduc2JkTVRk?= =?utf-8?B?L0NUMGk1VXcwL3dLZkVoTXhPU1RUUG8rRXprNURLeTBkdkdlZ0kzWFVUajF3?= =?utf-8?B?RmFLd3lERE41NG42Snk5VWNqdk1Mbnc1K1RCZmF5bE9MSmlza3dpQ3ZkelFY?= =?utf-8?B?d0hNWlJESS9LdXdyYXljYm9POTZybkJmR1ZSY3NhRnJFRmZHbDlJZEJnY3c5?= =?utf-8?B?SFN2OERUajh5K1VhY1owSkZyMnJ3NSs2MUFubVd1NnRGb3hNU0IrWE9FQlR1?= =?utf-8?B?VGtKOVVFR2l1Zld1TDhzQlhXMmxyOThtNVZUU1ZYYzN0WEdNeEkrWENLTXRG?= =?utf-8?B?MDdkOERxYlVJQTBwSmpGMjdUNWMzUlhHSzV1OEQzWUI5Nk00QlF1ak8xdFE4?= =?utf-8?B?UEQ1d043S0NKRTdVSkhBT01UalhWamZJQmNqOE1kTXNkdHRYek9zb0ZOMDBq?= =?utf-8?B?U0VtUkN2T3VVOVc3bkV1MDM3R3h3OFhqci92VmdabWR0MVEzcFkwS24xc1hR?= =?utf-8?B?aG8vM3V4eU45VytJcCtmaVNMNFBBYTVJYjNncEtRaXhVcGZtQkQ3dE14cTBC?= =?utf-8?B?Wk0xeHZJM05QendKb2VCRXlROW1waUU5NHhXeUJQYjJ1bE9EV0lKaFVJekxt?= =?utf-8?B?clBsZVFvSUIwc0thZlZ4VkpDVW95U3dxeSt0bHBubUYvTm1zUWxTMjZQSTlB?= =?utf-8?B?SllnSXNCZ1RnamRzcFV1NEN4V1JTSG56eTFvODR2TXBBR3NiMlJybFIvdHFJ?= =?utf-8?B?NGhOWDhzblUvbFA1UnBjbDZ3b25WUnQwWDFFbS9qZnNmOFVCRTI3M2YwSlJW?= =?utf-8?B?Qlh0MFQvdmFLdG85a2wrUGMralNFMnR1QmhsakZMQ2MydFJNMlJ1QStFVEdk?= =?utf-8?B?eFJRNnMvSStpemRYTllKUm1qSkhkZFptT0ZxdVpKOG0vWGhoSnVDaE5zZUdq?= =?utf-8?B?MjRWNVlPZTEvWUh4MnNZR3oyRG40aWpHSkRQQ3RXRjJQdXVUOEppbVNLMDhI?= =?utf-8?B?bFpWS3c5aWNnN1VMbnFmZSt4TENDaVVQNkJOakg4WThuYlhkUFhzNWFWcDlo?= =?utf-8?B?WFlodmhmVWJZdm8xTzdSRWNtRSs2dzF4NDdNSjRRZU9XdVovY1VOK3dCTnJB?= =?utf-8?B?VWRTSUx0SmxYaE9MdWx1WVE4cCtLcm1TS0QvUmNWekx1U1dRTzRoWEZ3K3Zu?= =?utf-8?B?YlNqQkRLeTBTMGRBcUpxNEpzL3paOG80L0pDbnhwbDRRcGVKSDkrTWVVSGJ6?= =?utf-8?B?ZVVDa0hLZ2NDMWZxRlNxNGFRRGxQcHlLRDRsQUE2RFFDTlk0ZEZmTm5YT3RZ?= =?utf-8?B?MC9mejdZZWdmOWJBdDdCR3dJNUFRMlJOQTdTaWUvVUo1a2liMHlxY0tnUm9h?= =?utf-8?B?KzZQeE5zS3F2VkdGZmIraER2WW1JZDRJVXE2UnhVYmI0L0l0bkJuZkJiMm4z?= =?utf-8?B?NDQvMGRPNkVIVDNZUS9OTTkyVW1Tam1GRjZ0aTVJMWhacHhSZkFNNWxES1NO?= =?utf-8?Q?vcUX7L?= X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1647;6:MWuGo0zjoYNlV4KeUqAMGFNxUmtbOIOfzDGq83aaVWWCrn2FY0aKBI3kPqLOm7LricRCLEp3oB79jf4m5zI7jdwyiIyfB5AqtQ08BOMw1LCsa0d+SjwMT+YJiUXcRlbdUGAeK6Y5/FtUHE/4YQYa9UnDAFcp1yOXRaQorFh/xcoT3p8jg381JNV/k/dtVC90WfLTOnYxHX638b3GlD8a7SYwmPnIrp2PzPHKhVwQ335g9C3Dg1b5v1I85tpu2EtLueoR3HKb+r5hv1xfSUJaOzY7h1ytJ5h49t2y+zOA3BkhGwsITLIcHA8DF2I+R61rg5KkKTLWRQHwCYtDrgFwr5Fd2ix/RzJq8B2/oo5hYUK1Cb5z6i1Z012uStvo/CYC+s1JDn4H0jjuA1ukOSJ/kg==;5:sTX/eZdrn8qNpRD4sei1ZdqV11Zt53WWUrKSmXZ/M8KIsBdM9f4nE/tImUlzpTdrghkXhJUzBB3BFDhGscT5FUP6Ps4en75eQdiM2/+9K0qYzDN2IdHv3T0hdQ+eES4kN3w7C08JZGc15Ulyg7t7Yg==;24:6vqgSe2an2vGKz7vS9aKxjh4khIgzbAucSCETKtdY+0NP9SMw1LI4tcucnJnYY1epX3632ZhqXZK9A4st4F/ncyIENg5oS6pWHpIKdNB0N4= SpamDiagnosticOutput: 1:99 SpamDiagnosticMetadata: NSPM X-Microsoft-Exchange-Diagnostics: 1;MWHPR11MB1647;7:xh7gC/VRgHHRFcf9GtIxOhoZZkhsY+0jysnUoP4+mmW/m9Pz6bvq4QFbkhl/e79wghj1baO98Sype7mSS6swnQaUyicbvRFrs1dGg1uy8m1BJ4wop/snPjkEVvSClcHCi2Js9/QYjzrWLGI6QRz8DO5LVAJFSyi8mn/YtV9z+hAVADHyGo3Gh9YugaySY1djlNdO7GgAGRqnHhBpIoSGujclEtf5JDYvLt8r+oZiQ09caDYgQOPrlS63JMHP9qqi6rwYUXZDvi99x+N5Ml9x9mABJGH9tZUkexA36Rcg0MXGcUiPZPgDQC12DYq6cReXCZZ+myLzo6ChP7bRFgsh0A== X-OriginatorOrg: bluetreble.com X-MS-Exchange-CrossTenant-OriginalArrivalTime: 17 Feb 2017 21:10:00.3901 (UTC) X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted X-MS-Exchange-Transport-CrossTenantHeadersStamped: MWHPR11MB1647 X-Pg-Spam-Score: -5.2 (-----) 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/14/17 5:18 PM, Robert Haas wrote: > On Tue, Feb 14, 2017 at 4:06 PM, Alvaro Herrera > wrote: >> I'd rather have a --quiet mode instead. If you're running it by hand, >> you're likely to omit the switch, whereas when writing the cron job >> you're going to notice lack of switch even before you let the job run >> once. > > Well, that might've been a better way to design it, but changing it > now would break backward compatibility and I'm not really sure that's Meh... it's really only going to affect cronjobs or scripts, which are easy enough to fix, and you're not going to have that many of them (or if you do you certainly have an automated way to push the update). > a good idea. Even if it is, it's a separate concern from whether or > not in the less-quiet mode we should point out that we're waiting for > a checkpoint on the server side. Well, --quite was suggested because of confusion from pg_basebackup twiddling it's thumbs... -- 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