Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOqNK-009Ha5-0S for pgsql-novice@arkaria.postgresql.org; Fri, 28 Nov 2025 04:46:30 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOqNI-0098Ej-2d for pgsql-novice@arkaria.postgresql.org; Fri, 28 Nov 2025 04:46:29 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOqNI-0098Ea-1f for pgsql-novice@lists.postgresql.org; Fri, 28 Nov 2025 04:46:28 +0000 Received: from mx1.alte-leipziger.de ([91.217.145.231]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOqNG-001tq7-1d for pgsql-novice@lists.postgresql.org; Fri, 28 Nov 2025 04:46:28 +0000 X-CSE-ConnectionGUID: AExDTOc3QqytPGbSS8amYg== X-CSE-MsgGUID: ISj8xoP+RT6pVIUlyPU3Gw== From: "Subramanian,Ramachandran" To: Laurenz Albe , "pgsql-novice@lists.postgresql.org" Subject: AW: how long should Archive logs be retained Thread-Topic: how long should Archive logs be retained Thread-Index: AdxfhJ+2q9JL8lOaTSmvl/OAQnUaGgAGRDKAAAXrLYAABcOjAAAUrsZw Date: Fri, 28 Nov 2025 04:46:18 +0000 Message-ID: <070dbb3e6b4f41c39e41f5f2979ee4a9@alte-leipziger.de> References: <1f12660d233efc644edb6a23c7bd4bcc84b503af.camel@cybertec.at> <329482d836f34a548d071aab63961f11@alte-leipziger.de> In-Reply-To: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: IWY1H69iwzrMAADY0A2wmVY9XYa1m8xA1gfGMJv7tZLMYQeeE5qP99vd jZ1tR/4hM99bewYT+o1d9X1gulGHuqcHRhp40Uz15enkh7Jrzn4614dUZQxn4EkU8FyBiYUiYvW eEQS6bOsJPi6l2j7WLXTTUThHqKaMqXznQZPTNTgL6av7YvHcfFcZWcaHu3QW9DsGwORGxbOynJ VLHUue/4WDRBq0nZN4lm7txcxBIoSfA/gLfg6ffW0ZWzHyRJUF7t3gSihZegHS6SRXwHYnkVFTE qnjOv84QAj6tBX9oJVKuKeWEbdLiS/L5hKzu21TDDgMha/WNJVtT5dsVizXEsKwHmsNfrUsna4n ZPsj8J+ZlqCQ5FwWsopVBMAFRVX2rYACb0KmxtZbLHSUK6sTGo6Y3KWHZUQHMGsIOvUd+v5q3sE nmbiwhsJjw7TzSd/d1c04BDYxKLbte+FQihQ5cTnxJqun3snzF+p38MndnJrusRtB/Z90Tgb9wc Bd7K6H x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--19.505900-8.000000 x-tm-snts-smtp: 3C607CD099C89331F743FD65BF06395DA6891A37073D5E4ECB7F4BAB102297F02000:8 x-alsentwithgood: false Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-GBS-PROC: 4CJLfqUnsgHWfeqPKbZTdacUffyi4GYlx8f1PvlYBTmuuyPZ9fuDQrzJ2ZtN1pDk X-GBS-PROCJOB: =?utf-8?Q?Bx14skVEkaLMErZhGXZAEPuyumeRZnS2qIdbPfq5YAkKnl7iAuTQs+9QGNW1?= =?utf-8?Q?gXr4S/9BYHPDYzmTFYoouqlj/IIIyHcmjXLV+On2lOCj18gfJTazj6eHENlw?= =?utf-8?Q?VkRkWXfsqHWZKgpyUc52eQFhX+PnZNNlKDZOqZ14BNXMkX774oI=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmsgeW91Li4gWW91IGFuc3dlcmVkIG15IHF1ZXN0aW9uICB3aXRoIHRoZSBiZWxvdyBj b21tZW50Lg0KDQotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLQ0KDQpZb3UgbmVlZCBhIFdBTCBhcmNoaXZlIHdoZW5ldmVyIHlvdSB3 YW50IHRvIHVuZG8gKmFueXRoaW5nKi4gIEZvciB0aGF0LCB5b3UgaGF2ZSB0byByZXN0b3Jl IGEgYmFzZSBiYWNrdXAgdGhhdCAqZmluaXNoZWQqIGJlZm9yZSB0aGUgcG9pbnQgaW4gdGlt ZSB0aGF0IHlvdSB3YW50IHRvIHJlY292ZXIgdG8uICBBbHNvLCB5b3UgbmVlZCBhbGwgV0FM IGZyb20gdGhlIHN0YXJ0IG9mIHRoZSBiYXNlIGJhY2t1cCB1bnRpbCB0aGUgcG9pbnQgaW4g dGltZSB0byB3aGljaCB5b3Ugd2FudCB0byByZWNvdmVyLg0KDQoNClJlZ2FyZGluZyB5b3Vy IGJlbG93IGNvbW1lbnQNCi0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KQXMgSSBzYWlkLCBQb3N0Z3JlU1FMIHdpbGwgaGFwcGlseSByZW1vdmUgV0FM IHNlZ21lbnRzIHRoYXQgY29udGFpbiB1bmNvbW1pdHRlZCB0cmFuc2FjdGlvbnMuICBQb3N0 Z3JlU1FMIHdpbGwgbmV2ZXIgdW5kbyBhbnkgd29yay4gIElmIGEgdHJhbnNhY3Rpb24gaXMg cm9sbGVkIGJhY2ssIGFsbCB0aGUgdW5jb21taXR0ZWQgZGF0YSBhcmUgc3RpbGwgdGhlcmUs IHRoZXkgYXJlIG9ubHkgaW52aXNpYmxlLg0KTGF0ZXIsIHRoZSBhdXRvdmFjdXVtIGRhZW1v biAoYSBraW5kIG9mIGdhcmJhZ2UgY29sbGVjdGlvbikgd2lsbCByZW1vdmUgdGhlc2UgZGF0 YSwgYnV0IHRoYXQncyBhIHNlcGFyYXRlIGFjdGl2aXR5ICh0aGF0IGlzIGFnYWluIGxvZ2dl ZCB0byBXQUwpLg0KDQpRdWVzdGlvbiA+Pj4gIFdvdyAhISAgVGhhdCBpcyBzbyBuZXcgdG8g bWUuICBTbw0KMS4gaWYgbG9nIHdyYXAgYXJvdW5kIGhhcHBlbnMgIGFuZCBzb21lIFdhbC1G aWxlcyBjb250YWluaW5nIHVuY29taXR0ZWQgbG9nIHJlY29yZHMgYXJlIGJlaW5nIG92ZXJ3 cml0dGVuLCAgIA0KMi4gQU5EICBpaW4gdGhlIG1lYW4gdGltZSBzb21lIGRhdGEgdXBkYXRl cyBwZXJ0YWluaW5nIHRvIHRoZXNlIHVuY29taXR0ZWQgdHJhbnNhY3Rpb25zIGhhdmUgYmVl biBmbHVzaGVkIGZyb20gdGhlIGRhdGEgYnVmZmVycyB0byBkaXNrDQozLiBBTkQgYWZ0ZXIg dGhlIGRhdGEgYnVmZmVycyBoYXZlIGJlZW4gZmx1c2hlZCB0aGUgdHJhbnNhY3Rpb24gZmFp bHMgKCBhbmQgSSBhc3N1bWUgcmVsZWFzZXMgYWxsIHRoZSBsb2NrcyApIA0KDQogaG93IGRv ZXMgcG9zdGdyZXMga25vdyB0aGF0ICBhIHBhcnRpY3VsYXIgdW5sb2NrZWQgcm93IGl0IGZp bmRzIGluIHRoZSBkaXNrICggb3IgZXZlbiB0aGUgYnVmZmVycG9vbCBmb3IgdGhhdCBtYXR0 ZXIgKSBpcyBub3QgaW4gYSB2YWxpZCBzdGF0ZSAgZXZlbiB0aG91Z2ggaXQgcGh5c2ljYWxs eSBleGlzdHMgaW4gdGhlIHRhYmxlPyAgSG93IGNhbiBpdCBkZWNvZGUgdGhpcyBpbmZvcm1h dGlvbj8NCg0KDQpMRw0KDQpSYW0gDQoNCg0KDQoNCg0KDQpGcmV1bmRsaWNoZSBHcsO8w59l DQoNCmkuIEEuIFJhbWFjaGFuZHJhbiBTdWJyYW1hbmlhbg0KWmVudHJhbGJlcmVpY2ggSW5m b3JtYXRpb25zdGVjaG5vbG9naWUNCg0KQWx0ZSBMZWlwemlnZXIgTGViZW5zdmVyc2ljaGVy dW5nIGEuRy4NCg0KDQpIYWxsZXNjaGUgS3JhbmtlbnZlcnNpY2hlcnVuZyBhLkcuDQoNCg0K DQoNCg0KDQoNCkFsdGUgTGVpcHppZ2VyIExlYmVuc3ZlcnNpY2hlcnVuZyBhLkcuLCBBbHRl IExlaXB6aWdlci1QbGF0eiAxLCA2MTQ0MCBPYmVydXJzZWwNClZvcnMuIGRlcyBBdWZzaWNo dHNyYXRzOiBEci4gV2FsdGVyIEJvdGVybWFubiDCtyBWb3JzdGFuZDogQ2hyaXN0b3BoIEJv aG4gKFZvcnMuKSwgRHIuIErDvHJnZW4gQmllcmJhdW0gKHN0di4gVm9ycy4pLCBGcmFuayBL ZXR0bmFrZXIsIERyLiBKb2NoZW4gS3JpZWdtZWllciwgQWxleGFuZGVyIE1heWVyLCBDaHJp c3RpYW4gUGFwZSwgV2lsdHJ1ZCBQZWthcmVrLCBVZG8gV2lsY3Nlaw0KU2l0eiBPYmVydXJz ZWwgKFRhdW51cykgwrcgUmVjaHRzZm9ybSBWVmFHIMK3IEFtdHNnZXJpY2h0IEJhZCBIb21i dXJnIHYuIGQuIEguIEhSQiAxNTgzIMK3IFVTdC4tSWROci4gREUgMTE0MTA2ODE0DQoNCg0K DQoNCg0KIA0KSGFsbGVzY2hlIEtyYW5rZW52ZXJzaWNoZXJ1bmcgYS5HLiwgIEzDtmZmZWxz dHJhw59lIDM0LTM4LCA3MDU5NyBTdHV0dGdhcnQNClZvcnMuIGRlcyBBdWZzaWNodHNyYXRz OiBEci4gV2FsdGVyIEJvdGVybWFubiDCtyBWb3JzdGFuZDogQ2hyaXN0b3BoIEJvaG4gKFZv cnMuKSwgRHIuIErDvHJnZW4gQmllcmJhdW0gKHN0di4gVm9ycy4pLCBGcmFuayBLZXR0bmFr ZXIsIERyLiBKb2NoZW4gS3JpZWdtZWllciwgQWxleGFuZGVyIE1heWVyLCBDaHJpc3RpYW4g UGFwZSwNCldpbHRydWQgUGVrYXJlaywgVWRvIFdpbGNzZWsNClNpdHogU3R1dHRnYXJ0IMK3 IFJlY2h0c2Zvcm0gVlZhRyDCtyBBbXRzZ2VyaWNodCBTdHV0dGdhcnQgSFJCIDI2ODYgwrcg VVN0Li1JZE5yLiBERSAxNDc4MDIyODUNCkJlaXRyw6RnZSB6dSBwcml2YXRlbiBLcmFua2Vu LSB1bmQgUGZsZWdla3JhbmtlbnZlcnNpY2hlcnVuZ2VuIHVudGVybGllZ2VuIG5pY2h0IGRl ciBWZXJzaWNoZXJ1bmdzdGV1ZXIgKMKnIDQgTnIuIDUgVmVyc1N0RykgwrcgVmVyc2ljaGVy dW5nc2xlaXN0dW5nZW4gc293aWUgVW1zw6R0emUgYXVzIFZlcnNpY2hlcnVuZ3N2ZXJ0cmV0 ZXItL01ha2xlcnTDpHRpZ2tlaXRlbiBzaW5kIHVtc2F0enN0ZXVlcmZyZWkNCiANCg0KDQoN CiANCkRpZSBQZmxpY2h0YW5nYWJlbiBkZXIgQUxIIEdydXBwZSBnZW3DpMOfIMKnIDM1YSBH bWJIRyBiencuIMKnIDgwIEFrdEcgZmluZGVuIFNpZSBoaWVyOiBodHRwczovL3d3dy5hbHRl LWxlaXB6aWdlci5kZS9pbXByZXNzdW0gDQoNCg0KDQoNCg0KX19fX19fX19fX19fX19fX19f X19fXw0KDQpBTEggR3J1cHBlDQpBbHRlIExlaXB6aWdlci1QbGF0eiAxLCA2MTQ0MCBPYmVy dXJzZWwNClRlbC46ICs0OSAoNjE3MSkgNjYtNDg4Mg0KRmF4OiArNDkgKDYxNzEpIDY2LTgw MC00ODgyDQpFLU1haWw6IHJhbWFjaGFuZHJhbi5zdWJyYW1hbmlhbkBhbHRlLWxlaXB6aWdl ci5kZQ0Kd3d3LmFsdGUtbGVpcHppZ2VyLmRlDQp3d3cuaGFsbGVzY2hlLmRlDQoNCg0KDQot LS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNodC0tLS0tDQpWb246IExhdXJlbnogQWxiZSA8 bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0PiANCkdlc2VuZGV0OiBEb25uZXJzdGFnLCAyNy4g Tm92ZW1iZXIgMjAyNSAyMDozNA0KQW46IFN1YnJhbWFuaWFuLFJhbWFjaGFuZHJhbiBJVC1t ZC1kYiA8cmFtYWNoYW5kcmFuLnN1YnJhbWFuaWFuQGFsdGUtbGVpcHppZ2VyLmRlPjsgcGdz cWwtbm92aWNlQGxpc3RzLnBvc3RncmVzcWwub3JnDQpCZXRyZWZmOiBSZTogaG93IGxvbmcg c2hvdWxkIEFyY2hpdmUgbG9ncyBiZSByZXRhaW5lZA0KDQpPbiBUaHUsIDIwMjUtMTEtMjcg YXQgMTU6NDkgKzAwMDAsIFN1YnJhbWFuaWFuLFJhbWFjaGFuZHJhbiB3cm90ZToNCj4gQXJj aGl2ZSBsb2dnaW5nIGlzIE5PVCBlbmFibGVkwqAgYW5kIGEgdHJhbnNhY3Rpb24ga2VlcHMg ZmlsbGluZyB1cCB0aGUgDQo+IGxvZ3Mgb25lIGJ5IG9uZSB0aWxsIGFsbCB0aGUgbG9ncyBh cmUgZnVsbCBXSVRIT1VUIEFueSBDT01NSVQuIFRoZW4gDQo+IHdoYXQgaGFwcGVucz/CoCBE b2VzIFBvc3RncmVzIGhhbmcgb3IgZG9lcyBQb3N0Z3JlcyB0ZXJtaW5hdGUgdGhpcyB0aHJl YWQgPw0KDQpOZWl0aGVyLg0KQXMgSSBzYWlkLCBQb3N0Z3JlU1FMIHdpbGwgaGFwcGlseSBy ZW1vdmUgV0FMIHNlZ21lbnRzIHRoYXQgY29udGFpbiB1bmNvbW1pdHRlZCB0cmFuc2FjdGlv bnMuICBQb3N0Z3JlU1FMIHdpbGwgbmV2ZXIgdW5kbyBhbnkgd29yay4gIElmIGEgdHJhbnNh Y3Rpb24gaXMgcm9sbGVkIGJhY2ssIGFsbCB0aGUgdW5jb21taXR0ZWQgZGF0YSBhcmUgc3Rp bGwgdGhlcmUsIHRoZXkgYXJlIG9ubHkgaW52aXNpYmxlLg0KTGF0ZXIsIHRoZSBhdXRvdmFj dXVtIGRhZW1vbiAoYSBraW5kIG9mIGdhcmJhZ2UgY29sbGVjdGlvbikgd2lsbCByZW1vdmUg dGhlc2UgZGF0YSwgYnV0IHRoYXQncyBhIHNlcGFyYXRlIGFjdGl2aXR5ICh0aGF0IGlzIGFn YWluIGxvZ2dlZCB0byBXQUwpLg0KDQo+IEFmdGVyIHJlYWRpbmcgeW91ciBhbnN3ZXJzLCBJ IHVuZGVyc3RhbmQgdGhhdCBBcmNoaXZlIGxvZ3MgYXJlIG5lZWRlZCANCj4gT05MWSBpZiB3 ZSB3YW50IHRvIGdvIGJhY2sgaW4gdGltZSB0byBhIHBhc3QgcG9pbnQgb2YgY29uc2lzdGVu Y3kgKCBleGFtcGxlwqAgQ3VycmVudCBkYXRlIG1pbnVzIDUgZGF5cyApIC4NCg0KTm8sIGFy Y2hpdmUgbG9ncyBhcmUgbmVlZGVkIHdoZW5ldmVyIHlvdSB5b3UgbmVlZCB0byBnbyBiYWNr IGluIHRpbWUgYXQgYWxsLg0KV2l0aCB0aGUgV0FMIGluIHBnX3dhbCwgYWxsIHlvdSBjYW4g ZG8gaXMgcmVjb3ZlciBhZnRlciBhIGNyYXNoLCB3aGljaCB3aWxsIHJlY292ZXIgYWxsIGNv bW1pdHRlZCB0cmFuc2FjdGlvbnMuDQoNCj4gT2Zjb3Vyc2UgYSBiZWdpbmluZyBiYWNrdXAg aXMgbmVlZGVkIG9uIHRoaXMgZGF5IGFzIHdlbGwgKCBhIGJhY2t1cCANCj4gdGFrZW4gb24g Y3VycmVudCBkYXkgLSA1IGRheXMgKSAuIFRoZW4gdXNpbmcgdGhlIGJhY2t1cCBhbmQgdGhl IExvZ3MgDQo+IHRoYXQgd2VyZSBhcmNoaXZlZCBvbiB0aGlzIGRheSAsIHdlIGNhbiByb2xs Zm9yd2FyZCB0byBhIFBvaW50IGluIHRpbWUgb24gdGhpcyBkYXkuwqDCoCAxLiBEaWQgSSB1 bmRlcnN0YW5kIGNvcnJlY3RseSA/wqAgMi4NCj4gSXMgdGhlcmUgYW55IG90aGVyIHNjZW5h cmVvIHdoZXJlIEFyY2hpdmUgbG9ncyB3aWxsIGJlIHVzZWQ/DQoNCkkgYW0gbm90IHN1cmUg SSBjYW4gZm9sbG93Lg0KDQpZb3UgbmVlZCBhIFdBTCBhcmNoaXZlIHdoZW5ldmVyIHlvdSB3 YW50IHRvIHVuZG8gKmFueXRoaW5nKi4gIEZvciB0aGF0LCB5b3UgaGF2ZSB0byByZXN0b3Jl IGEgYmFzZSBiYWNrdXAgdGhhdCAqZmluaXNoZWQqIGJlZm9yZSB0aGUgcG9pbnQgaW4gdGlt ZSB0aGF0IHlvdSB3YW50IHRvIHJlY292ZXIgdG8uICBBbHNvLCB5b3UgbmVlZCBhbGwgV0FM IGZyb20gdGhlIHN0YXJ0IG9mIHRoZSBiYXNlIGJhY2t1cCB1bnRpbCB0aGUgcG9pbnQgaW4g dGltZSB0byB3aGljaCB5b3Ugd2FudCB0byByZWNvdmVyLg0KDQpZb3VycywNCkxhdXJlbnog QWxiZQ0K