Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1expJC-0007cN-H2 for pgsql-admin@arkaria.postgresql.org; Mon, 19 Mar 2018 07:34:18 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1expJB-00014P-I6 for pgsql-admin@arkaria.postgresql.org; Mon, 19 Mar 2018 07:34:17 +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.89) (envelope-from ) id 1expJA-00014E-N5 for pgsql-admin@lists.postgresql.org; Mon, 19 Mar 2018 07:34:17 +0000 Received: from shopzeus.com ([87.229.70.149]) by makus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1expJ7-0007Ti-6Z for pgsql-admin@postgresql.org; Mon, 19 Mar 2018 07:34:14 +0000 Received: from [127.127.127.127] (localhost [127.127.127.127]) (Authenticated sender: gandalf) by shopzeus.com (Postfix) with ESMTPSA id 7F228889B83C for ; Mon, 19 Mar 2018 02:31:09 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=shopzeus.com; s=shopzeus_com; t=1521441069; bh=+rRQyaiPIARozXTVwB55+k5EpWR4qzjg52r6OqZvpPM=; h=To:From:Subject:Date:From; b=ItD3eO6O91T6wMuW32td74BmUbsI9qaEe19Qxo+JdtNThJ9DK7ryDucBvk2axWlyq kvFtcKRLv/2x4VrGwMAq6fwFj+arheu/jwxoVzgS/hi5Xc5G6Q+HKWHi5iVpEQjvW3 c/ofyLQcrud7COg+lxWioQ6HtBI4BPC8O2ksZVcbO4ZUx3OZbWF4XiwEYs70zSX/zO rgnNr7urx8rawZvenfIeXny3Ory/XVY7EAqYJ9safwQDb69bnuoXVw2+nM5ytMxLE7 L9gNce1WTfHJMmvahXbPDCtf/VjaokEo1MwEFWEp2MBOGQNyw23AmKv/TZHYPcULyx 1HC1UL1oiwPHA== To: pgsql-admin@postgresql.org From: =?UTF-8?Q?Nagy_L=c3=a1szl=c3=b3_Zsolt?= Subject: Will unused replication slots prevent the server from deleting WAL segments? Message-ID: <73cd3a8f-363f-c880-67c7-9bcf290ba2b7@shopzeus.com> Date: Mon, 19 Mar 2018 08:34:10 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-2 Content-Transfer-Encoding: base64 Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk SSBoYXZlIGFjY2lkZW50YWxseSBjcmVhdGVkIGFuIGV4dHJhIHJlcGxpY2F0aW9uIHNsb3Qg b24gYSBzZXJ2ZXIuIEl0CndhcyBhIGxvbmcgdGltZSBhZ28sIGFuZCBpdCBpcyBub3QgdXNl ZCAoYWN0aXZlPWZhbHNlKS4gSSdtIHBsYW5uaW5nIHRvCmFkZCBhbm90aGVyIHJlcGxpY2F0 aW9uIHNsYXZlLCBidXQgSSBjYW4gb25seSBkbyBpdCBsYXRlci4gSSB3b25kZXIgaWYKaXQg cHJldmVudHMgdGhlIHNlcnZlciB0byByZWN5Y2xlIG9sZCBXQUwgc2VnbWVudHM/CgoKdGVt cGxhdGUxPSMgc2VsZWN0ICogZnJvbSBwZ19yZXBsaWNhdGlvbl9zbG90czsKoHNsb3RfbmFt ZSB8IHBsdWdpbiB8IHNsb3RfdHlwZSB8IGRhdG9pZCB8IGRhdGFiYXNlIHwgdGVtcG9yYXJ5 IHwgYWN0aXZlCnwgYWN0aXZlX3BpZCB8IHhtaW4gfCBjYXRhbG9nX3htaW4gfCByZXN0YXJ0 X2xzbiB8IGNvbmZpcm1lZF9mbHVzaF9sc24KLS0tLS0tLS0tLS0rLS0tLS0tLS0rLS0tLS0t LS0tLS0rLS0tLS0tLS0rLS0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLSstLS0tLS0t LS0tLS0rLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0t LS0tLS0tLS0tCqBla2WgoKCgoKAgfKCgoKCgoKAgfCBwaHlzaWNhbKAgfKCgoKCgoKAgfKCg oKCgoKCgoCB8IGagoKCgoKCgoCB8IGagoKCgoAp8oKCgoKCgoKCgoKAgfKCgoKCgIHygoKCg oKCgoKCgoKCgIHygoKCgoKCgoKCgoKAgfAqgZG9ja2VyMDKgIHygoKCgoKCgIHwgcGh5c2lj YWygIHygoKCgoKCgIHygoKCgoKCgoKAgfCBmoKCgoKCgoKAgfCB0oKCgoKAKfKCgoKCgoKCg IDY2IHygoKCgoCB8oKCgoKCgoKCgoKCgoCB8IDAvNzAwMDAwMKCgIHwKKDIgcm93cykKCnRl bXBsYXRlMT0jCgpUaGVyZSBpcyBvbmx5IG9uZSByb3cgaW4gcGdfc3RhdF9yZXBsaWNhdGlv bjoKCnRlbXBsYXRlMT0jIHNlbGVjdCAqIGZyb20gcGdfc3RhdF9yZXBsaWNhdGlvbiA7CqBw aWQgfCB1c2VzeXNpZCB8oKCgoCB1c2VuYW1loKCgoCB8IGFwcGxpY2F0aW9uX25hbWUgfCBj bGllbnRfYWRkciB8CmNsaWVudF9ob3N0bmFtZSB8IGNsaWVudF9wb3J0IHygoKCgoKCgoCBi YWNrZW5kX3N0YXJ0oKCgoKCgoKAgfApiYWNrZW5kX3htaW4gfKCgIHN0YXRloKAgfCBzZW50 X2xzbqAgfCB3cml0ZV9sc24gfCBmbHVzaF9sc24gfApyZXBsYXlfbHNuIHwgd3JpdGVfbGFn IHwgZmx1c2hfbGFnIHwgcmVwbGF5X2xhZyB8IHN5bmNfcHJpb3JpdHkgfApzeW5jX3N0YXRl Ci0tLS0tKy0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0t Ky0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0t LS0tLSstLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0t LS0tLQqgIDY2IHygoKAgMTYzODYgfCBwaGJfcmVwbGljYXRpb24gfCB3YWxyZWNlaXZlcqCg oKCgIHwgMTAuMC4wLjg0oKAKfKCgoKCgoKCgoKCgoKCgoKAgfKCgoKCgoCA1ODMxOCB8IDIw MTgtMDMtMDEgMDg6Mjc6MDcuMDQ0NjI2KzAwCnygoKCgoKCgoKCgoKCgIHwgc3RyZWFtaW5n IHwgMC83MDAwMDAwIHwgMC83MDAwMDAwIHwgMC83MDAwMDAwIHwKMC83MDAwMDAwoCB8oKCg oKCgoKCgoCB8oKCgoKCgoKCgoCB8oKCgoKCgoKCgoKAgfKCgoKCgoKCgoKCgoCAwIHwgYXN5 bmMKKDEgcm93KQoKdGVtcGxhdGUxPSOgCgpTaG91bGQgSSBkZWxldGUgdGhpcyBzbG90IGFu ZCBhZGQgaXQgYWdhaW4gbGF0ZXIsIHdoZW4gdGhlIG5ldyBzbGF2ZQpiZWNvbWVzIGF2YWls YWJsZT8KClRoYW5rcywKCqCgIExhc3psbwoK