Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTQ5c-0007ob-NX for pgsql-admin@arkaria.postgresql.org; Thu, 14 Jun 2018 11:06:53 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fTQ5b-000461-BA for pgsql-admin@arkaria.postgresql.org; Thu, 14 Jun 2018 11:06:51 +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.89) (envelope-from ) id 1fTQ5a-00045s-LU for pgsql-admin@lists.postgresql.org; Thu, 14 Jun 2018 11:06:51 +0000 Received: from mail-he1eur01on0106.outbound.protection.outlook.com ([104.47.0.106] helo=EUR01-HE1-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fTQ5V-0002wa-R1 for pgsql-admin@lists.postgresql.org; Thu, 14 Jun 2018 11:06:49 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sibvisions.onmicrosoft.com; s=selector1-sibvisions-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=3E6caWLNXD+R5OSYhbgN/Bo1+vmxRMyYdb80e7fy4dY=; b=Mb0wecO4uoWzxKNzIpVx6PRvcxMg55A9he5GhCCLxjf23Q2tscDzijwfolAKJola3Sm0wlHQQ3LRIKpyYNnXApl5r8fOp9z9wPhh/3X07okMvuBdtu88FLRJe4cPius1OfelOlR6GR7Y9pFh6RmNBkhyyU+c/8vhsNU7ZDsdmLc= Received: from HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM (10.168.129.138) by HE1PR1001MB1001.EURPRD10.PROD.OUTLOOK.COM (10.168.129.141) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.863.17; Thu, 14 Jun 2018 11:06:42 +0000 Received: from HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM ([fe80::c523:204f:6aa4:17bb]) by HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM ([fe80::c523:204f:6aa4:17bb%9]) with mapi id 15.20.0841.019; Thu, 14 Jun 2018 11:06:42 +0000 From: Robert Zenz To: "pgsql-admin@lists.postgresql.org" Subject: Re: Stopping writes in master Thread-Topic: Stopping writes in master Thread-Index: AQHUA80W6yR7a7uS1UGp4NryPdKT9aRfl/IA Date: Thu, 14 Jun 2018 11:06:41 +0000 Message-ID: <5B224C42.6060107@sibvisions.com> References: In-Reply-To: Accept-Language: de-AT, en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: authentication-results: spf=none (sender IP is ) smtp.mailfrom=robert.zenz@sibvisions.com; x-originating-ip: [213.164.18.106] x-ms-publictraffictype: Email x-microsoft-exchange-diagnostics: 1;HE1PR1001MB1001;7:XyWw8U7/091ZLqTli4MmWt8OBV575X8hw6vuefWbwvfJXwXRe2CbHIM7jScZrquQ/U9oJ7khUQePTjmysEXpVJKYsOtsyARCDTvSCmBGPFMHGHf63yJ4+vZqYvqEv7/04nqniVbZioFov4ev3gw6HuRd14+G3YcClB/LimQyo4817pEQbn3LLkG44aMPik+Lu8y9AzBFCkqbZb1bBvC57yqWcWXv4h1ls5H0oRHLORhw5ZKU4aDBj1KnXInI27aa x-ms-exchange-antispam-srfa-diagnostics: SOS; x-ms-office365-filtering-correlation-id: 2a4d0189-0462-46a7-f217-08d5d1e6e8df x-microsoft-antispam: UriScan:;BCL:0;PCL:0;RULEID:(7020095)(4652020)(7021125)(4534165)(7022125)(4603075)(7168020)(4627221)(201702281549075)(7048125)(7024125)(7027125)(7028125)(7023125)(5600026)(711020)(2017052603328)(7153060)(7193020);SRVR:HE1PR1001MB1001; x-ms-traffictypediagnostic: HE1PR1001MB1001: x-microsoft-antispam-prvs: x-exchange-antispam-report-test: UriScan:; x-ms-exchange-senderadcheck: 1 x-exchange-antispam-report-cfa-test: BCL:0;PCL:0;RULEID:(6040522)(2401047)(8121501046)(5005006)(10201501046)(3231254)(944501410)(52105095)(3002001)(93006095)(93001095)(149027)(150027)(6041310)(20161123560045)(20161123562045)(20161123558120)(2016111802025)(20161123564045)(6072148)(6043046)(201708071742011)(7699016);SRVR:HE1PR1001MB1001;BCL:0;PCL:0;RULEID:;SRVR:HE1PR1001MB1001; x-forefront-prvs: 0703B549E4 x-forefront-antispam-report: SFV:NSPM;SFS:(10019020)(376002)(39850400004)(396003)(346002)(39380400002)(366004)(57704003)(199004)(189003)(44832011)(76176011)(2351001)(446003)(99286004)(65816011)(2900100001)(86362001)(53936002)(5660300001)(80316001)(6246003)(186003)(26005)(316002)(6506007)(476003)(53546011)(11346002)(97736004)(2501003)(2616005)(102836004)(55236004)(486006)(87266011)(5250100002)(6116002)(3846002)(8676002)(3660700001)(81166006)(33656002)(81156014)(6512007)(5640700003)(2906002)(6436002)(6486002)(6916009)(3480700004)(66066001)(8936002)(229853002)(59896002)(478600001)(36756003)(68736007)(3280700002)(105586002)(7736002)(14454004)(25786009)(106356001)(305945005);DIR:OUT;SFP:1102;SCL:1;SRVR:HE1PR1001MB1001;H:HE1PR1001MB0986.EURPRD10.PROD.OUTLOOK.COM;FPR:;SPF:None;LANG:en;PTR:InfoNoRecords;A:1;MX:1; received-spf: None (protection.outlook.com: sibvisions.com does not designate permitted sender hosts) x-microsoft-antispam-message-info: QS5hi4UecXkUOJ1v/24aCOfYme6nlMMMYU7kmxWKvqk4TM5jDQUPTX4s8tkYp81llXR9lH/NBOX49Pv68gtzu1uVpQcUYSjQu16ajp4fiX0pVEIaQqKLxgup74skgIqE0RIMbrKyW65MRoHYyPQ6Wr3k9orHGvdU/VNC5IhnuyW8TKjbviYIc+KUTt/TgLlX spamdiagnosticoutput: 1:99 spamdiagnosticmetadata: NSPM Content-Type: text/plain; charset="utf-8" Content-ID: Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-OriginatorOrg: sibvisions.com X-MS-Exchange-CrossTenant-Network-Message-Id: 2a4d0189-0462-46a7-f217-08d5d1e6e8df X-MS-Exchange-CrossTenant-originalarrivaltime: 14 Jun 2018 11:06:42.0123 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: beb1b6aa-9998-4674-9056-cbc4fe8c7cad X-MS-Exchange-Transport-CrossTenantHeadersStamped: HE1PR1001MB1001 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Q2FuIGV4aXN0aW5nIGNvbm5lY3Rpb25zIGJlIGRyb3BwZWQgb3IgZG8gdGhleSBuZWVkIHRvIHN0 YXkgZXN0YWJsaXNoZWQ/IEFsc28sDQphcmUgeW91IHRyeWluZyB0byBzd2l0Y2ggdGhlIGRhdGFi YXNlIHRvIGEgcmVhZC1vbmx5IG1vZGUgZm9yIGJhY2t1cCBwdXJwb3NlcyBvcg0Kc29tZXRoaW5n IGRpZmZlcmVudD8NCg0KDQpPbiAxNC4wNi4yMDE4IDEyOjQ2LCBEZWJyYWogTWFubmEgd3JvdGU6 DQo+IEhpDQo+IA0KPiBJbiBhIDMgbm9kZSBjbHVzdGVyIHdpdGggMSBtYXN0ZXIgYW5kIDIgc2xh dmVzIHdpdGggcG9zdGdyZXMgMTAuNCBpcyB0aGVyZQ0KPiBhbnkgIGNvbmZpZ3VyYXRpb24gc2V0 dGluZyB0aGF0IHdpbGwgc3RvcCBhbGwgd3JpdGVzIHRvIHRoZSBtYXN0ZXIgZnJvbSB0aGUNCj4g Y2xpZW50LiBCdXQgdGhlIGNsaWVudHMgY2FuIHJlYWQgZGF0YSBmcm9tIG1hc3RlciBhbmQgb3Ro ZXIgc2xhdmVzID8NCj4gDQo+IFRoYW5rcywNCj4g