Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3GzD-00034P-W3 for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Jul 2021 11:54:04 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m3Gyh-0007V8-H6 for pgsql-bugs@arkaria.postgresql.org; Tue, 13 Jul 2021 11:53:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3EWQ-0004ve-5I for pgsql-bugs@lists.postgresql.org; Tue, 13 Jul 2021 09:16:10 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3EWM-00045P-OD for pgsql-bugs@lists.postgresql.org; Tue, 13 Jul 2021 09:16:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=e4pWTIiugElpkCApUfirBg1RrmEnCcG5ex8EJKYMzGI=; b=nlGDvQdxxSaU6Gw9lWo6f6THN6 o0CfGb6AOFy/VvpGHcBEZsiN4iNLrG9oU/UPnbO8dcgi574ViTwSmB15KLNToGJGZFqoGZV1M1v7k LFo4YSXzC42X2XH8iMtW16UHMdJ334HHJzFS5nzWRl5D/wIua7hFHOmFEi5unXEjSWgw5srCi8Ys3 omrOJihGDU1VjZ2D0c6ppXBb58iSxpJdAoJDSvvKkIs+T6TLeMnWr9+lM7nLOVLTx8bXr3UYuv2Zc RqCCT3MEKhK+dEgBqsYGBIvCZIjyUoxG80j/aJRvsQzEXBcy9mxsaX/GkXSB93PJbQDNLi4N94U7C orqz7Vog==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m3EWK-0003uH-UC for pgsql-bugs@lists.postgresql.org; Tue, 13 Jul 2021 09:16:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m3EWI-0007wv-HL for pgsql-bugs@lists.postgresql.org; Tue, 13 Jul 2021 09:16:02 +0000 Content-Type: multipart/mixed; boundary="===============2040784342731046105==" MIME-Version: 1.0 Subject: BUG #17103: WAL segments are not removed after exceeding max_slot_wal_keep_size To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: mk@071.ovh Reply-To: mk@071.ovh, pgsql-bugs@lists.postgresql.org Date: Tue, 13 Jul 2021 09:15:17 +0000 Message-ID: <17103-004130e8f27782c9@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============2040784342731046105== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxNzEwMwpMb2dnZWQgYnk6ICAgICAgICAgIE1hcmNpbiBLcnVwb3dpY3oK RW1haWwgYWRkcmVzczogICAgICBta0AwNzEub3ZoClBvc3RncmVTUUwgdmVyc2lvbjogMTMuMwpP cGVyYXRpbmcgc3lzdGVtOiAgIENlbnRPUyA3LjYKRGVzY3JpcHRpb246ICAgICAgICAKCkhpLA0K DQpBZnRlciB0aGUgcmVwbGljYXRpb24gZmVsbCBiZWhpbmQgYW5kIHRoZSBsYWcgZXhjZWVkZWQK bWF4X3Nsb3Rfd2FsX2tlZXBfc2l6ZSwgV0FMIG9uIG1hc3RlciB3ZXJlIG5vdCByZW1vdmVkLiBJ dCBzZWVtcyB0aGF0ClBvc3RncmVzIHRyaWVkIHRvIG1haW50YWluIG1heF9zbG90X3dhbF9rZWVw X3NpemUgd29ydGggb2Ygc2VnbWVudHMuIFBsZWFzZQpmaW5kIHRoZSBkZXRhaWxzIGJlbG93IChz bGlndGhseSByZWRhY3RlZCB2ZXJzaW9uIG9mIHdoYXQgSSB3cm90ZSBoZXJlOgpodHRwczovL3N0 YWNrb3ZlcmZsb3cuY29tL3F1ZXN0aW9ucy82ODMxNDIyMi9yZXBsaWNhdGlvbi1sYWctZXhjZWVk aW5nLW1heC1zbG90LXdhbC1rZWVwLXNpemUtd2FsLXNlZ21lbnRzLW5vdC1yZW1vdmVkKS4NCg0K DQotLSBTdW1tYXJ5IC0tDQpXZSBhcmUgdXNpbmcgbWF4X3Nsb3Rfd2FsX2tlZXBfc2l6ZSBmcm9t IFBvc3RncmVzcWwgMTMgdG8gcHJldmVudCBtYXN0ZXIKZnJvbSBiZWluZyBraWxsZWQgYnkgYSBs YWdnaW5nIHJlcGxpY2F0aW9uLiBJdCBzZWVtcywgdGhhdCBpbiBvdXIgY2FzZSwgV0FMCnN0b3Jh Z2Ugd2Fzbid0IGZyZWVkIHVwIGFmdGVyIGV4Y2VlZGluZyB0aGlzIHBhcmFtZXRlciB3aGljaCBy ZXN1bHRlZCBpbiBhCnJlcGxpY2F0aW9uIGZhaWx1cmUuIFdBTCB3aGljaCwgYXMgSSBiZWxpZXZl LCBzaG91bGQgaGF2ZSBiZWVuIGZyZWVkIHVwIGRpZApub3Qgc2VlbSB0byBiZSBuZWVkZWQgYnkg YW55IG90aGVyIHRyYW5zYWN0aW9uIGF0IGEgdGltZS4NCg0KLS0gQ29uZmlndXJhdGlvbiAtLQ0K bWFzdGVyICYgb25lIHJlcGxpY2EgLSBzdHJlYW1pbmcgcmVwbGljYXRpb24gdXNpbmcgYSBzbG90 DQp+NzAwR0IgYXZhaWxhYmxlIGZvciBwZ193YWwNCm1heF9zbG90X3dhbF9rZWVwX3NpemUgPSA2 MDBHQg0KbWluX3dhbF9zaXplID0gMjBHQg0KbWF4X3dhbF9zaXplID0gNDBHQg0KZGVmYXVsdCBj aGVja3BvaW50X3RpbWVvdXQgPSA1IG1pbnV0ZXMgKG5vIHByb2JsZW0gd2l0aCBjaGVja3BvaW50 cykNCmFyY2hpdmluZyBpcyBvbiBhbmQgaXMgY2F0Y2hpbmcgdXAgd2VsbA0KDQotLSBXaGF0IGhh cHBlbmVkIC0tDQpVbmRlciBoZWF2eSBsb2FkIChsYXJnZSBDT1BZL0lOU0VSVCB0cmFuc2FjdGlv bnMsIGxvYWRpbmcgaHVuZHJlZHMgb2YgR0Igb2YKZGF0YSksIHRoZSByZXBsaWNhdGlvbiBzdGFy dGVkIGZhbGxpbmcgYmVoaW5kLiBBdmFpbGFibGUgc3BhY2Ugb24gcGdfd2FsIHdhcwpiZWluZyBy ZWR1Y2VkIGluIHRoZSBzYW1lIHJhdGUgYXMgc2FmZV9zbG90CnBnX3JlcGxpY2F0aW9uX3Nsb3Qu c2FmZV93YWxfc2l6ZSAtIGFzIGV4cGVjdGVkLiBBdCBzb21lIHBvaW50IHNhZmVfd2FsX3NpemUK d2VudCBuZWdhdGl2ZSBhbmQgc3RyZWFtaW5nIHN0b3BwZWQgd29ya2luZy4gSXQgd2Fzbid0IGEg cHJvYmxlbSwgYmVjYXVzZQpyZXBsaWNhIHN0YXJ0ZWQgcmVjb3ZlcnkgZnJvbSBXQUwgYXJjaGl2 ZS4gSSBleHBlY3RlZCB0aGF0IG9uY2UgdGhlIHNsb3QgaXMKbG9zdCwgV0FMcyB3aWxsIGJlIHJl bW92ZWQgdXAgdG8gbWF4X3dhbF9zaXplLiBUaGlzIGRpZCBub3QgaGFwcGVuIHRob3VnaC4KSXQg c2VlbXMgdGhhdCBQb3N0Z3JlcyB0cmllZCB0byBtYWludGFpbiBzb21ldGhpbmcgY2xvc2UgdG8K bWF4X3Nsb3Rfd2FsX2tlZXBfc2l6ZSAoNjAwR0IpIGF2YWlsYWJsZSwgaW4gY2FzZSByZXBsaWNh IHN0YXJ0cyBjYXRjaGluZyB1cAphZ2Fpbi4gT3ZlciB0aGUgdGltZSwgdGhlcmUgd2FzIG5vIHNp bmdsZSB0cmFuc2FjdGlvbiB3aGljaCB3b3VsZCByZXF1aXJlCnRoaXMgbXVjaCBXQUwgdG8gYmUg a2VwdC4gYXJjaGl2aW5nIHdhc24ndCBiZWhpbmQgZWl0aGVyLg0KDQpBbW91bnQgb2YgZnJlZSBz cGFjZSBvbiBwZ193YWwgd2FzIG1vcmUgb3IgbGVzcyA3MEdCIGZvciBtb3N0IG9mIHRoZSB0aW1l LApob3dldmVyIGF0IHNvbWUgcG9pbnQsIGR1cmluZyBoZWF2eSBhdXRvdmFjdXVtaW5nLCBpdCBk aXBwZWQgdG8gMCA6KCBUaGlzIGlzCndoZW4gUEcgY3Jhc2hlZCBhbmQgKGF1dG8tcmVjb3ZlcmVk IHNvb24gYWZ0ZXIpLiBBZnRlciBnZXR0aW5nIGJhY2sgdXAsCnRoZXJlIHdhcyAxMUdCIGxlZnQg b24gcGdfd2FsIGFuZCBubyB0cmFuc2FjdGlvbiBydW5uaW5nLCBubyBsb2FkaW5nLiBUaGlzCmxh c3RlZCBmb3IgaG91cnMuIER1cmluZyB0aGlzIHRpbWUgcmVwbGljYSBmaW5hbGx5IGNhdWdodCB1 cCBmcm9tIHRoZQphcmNoaXZlIGFuZCByZXN0b3JlZCB0aGUgcmVwbGljYXRpb24gd2l0aCBubyBk ZWxheS4gTm9uZSBvZiB0aGUgV0FMcyB3ZXJlCnJlbW92ZWQuIEkgbWFudWFsbHkgcnVuIGNoZWNr cG9pbnQgYnV0IGl0IGRpZCBub3QgY2xlYXIgYW55IFdBTHMuIEkgZmluYWxseQpyZXN0YXJ0ZWQg UG9zdGdyZXNxbCBhbmQgZHVyaW5nIHRoZSByZXN0YXJ0aW5nIHBnX3dhbCB3ZXJlIGZpbmFsbHkK Y2xlYXJlZC4NCg0KQWdhaW4gLSB3aHkgUEcgZGlkIG5vdCBjbGVhciBXQUw/IFdBTHMsIGV2ZW4g bW9yZSBjbGVhcmx5LCB3ZXJlIG5vdCBuZWVkZWQKYnkgYW55IHByb2Nlc3MuDQoNCk1hbnkgdGhh bmtzLA0KLS0gTWFyY2luCgo= --===============2040784342731046105==--