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 1w4wYc-002iwy-1N for pgsql-novice@arkaria.postgresql.org; Tue, 24 Mar 2026 07:52:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w4wYY-005DUx-2f for pgsql-novice@arkaria.postgresql.org; Tue, 24 Mar 2026 07:52:07 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1w4wYY-005DUm-1o for pgsql-novice@lists.postgresql.org; Tue, 24 Mar 2026 07:52:06 +0000 Received: from mx2.alte-leipziger.de ([91.217.145.232]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1w4wYW-00000000l0e-0pBC for pgsql-novice@lists.postgresql.org; Tue, 24 Mar 2026 07:52:06 +0000 X-CSE-ConnectionGUID: gENt1ozeRQm/IxeVBBCCAw== X-CSE-MsgGUID: mAjK4ftPT8mnBuxy9/grQA== From: "Subramanian,Ramachandran" To: Laurenz Albe , "pgsql-novice@lists.postgresql.org" Subject: AW: Replication Testing- How to introduce a Lag Thread-Topic: Replication Testing- How to introduce a Lag Thread-Index: AQHcu1zRpQOar20AWUu9/Lg4xmJdwbW9Tpqg Date: Tue, 24 Mar 2026 07:51:57 +0000 Message-ID: <39ec6185a893473aa9217520e5a92be7@alte-leipziger.de> References: <8b38fa5141905f9ad6983b8d5ae944e812e3d28a.camel@cybertec.at> <0e00fcc0062b59b88f98dba4900ce49d5a9a3fea.camel@cybertec.at> <477369bf897b44feb2d2368f6fca93fc@alte-leipziger.de> <89d63402747edb3bf80ff668fdd63cc77334f446.camel@cybertec.at> <013104103e016e84d59c1e2accb0b1b1f99d9870.camel@cybertec.at> In-Reply-To: <013104103e016e84d59c1e2accb0b1b1f99d9870.camel@cybertec.at> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: EefIVvJ/ke3MAADY0A2wmWHJwQ8hSotRN0X64jGy2dZJTOxleK2tZgOe +RYG/aOVPTRIw+7pX28i/cynICT254aCIAWYxgFqGwz+ElW8loaEx+FyVcWRiqDraVnReS0bdh4 JXqUGEf1uGQIBoAeMFogryuQEGaYO0eSww0gzzTsF7eh/bG4q+NC1AaEFzvKwuBf5Gz+EOuqkoO CJL88gzOMMe0OGSaCi/UafUDuaeVXM++KBJYTUQXFYI3RAf2P4p54G9fttJ02OGg51f50anxPLV /fziAzBXLKBtD/V+ht3Oh2rlE+6unoVJaRaJRL/ES46qCSbf/X5gNZJP+k/L6JYuGaIjh0/IOKW WMbJYW2zZHhGBmyWLtGoy3yh3xFhyoNiGVYj0qn2xUMXpEVQs750nixr6sysyqAZcdwutfC5zPb TVwYGZjYl+8dA3M6D+Ca7r5y6Gi9jPC40nnbdU+E+yaSOuZIYjxd+UmKvHKoDEsYAQfVhCM8ksj sTeCaRLYIUW60D6qY= x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--1.092200-8.000000 x-tm-snts-smtp: 8A276FBF34DB980F097FEFB61CFC2D87CB2658638A5D946C28D733E2790B248A2000:8 x-alsentwithgood: false Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-GBS-PROC: 4CJLfqUnsgHWfeqPKbZTdTjaRvRZD57oauVeZG0UhQsHofaMzwc5AcyZSQusE/qp X-GBS-PROCJOB: =?utf-8?Q?YDE5/i68qrLxucrvhTs0fMtXnUio2i4bKeyo7iV4JIubQB8g40KY8TbkM9Ll?= =?utf-8?Q?aPMk2yd86PA98cHpeM2NtErjzFSU+zghBzagTsiTn1DRGmxFv7uNirEu8OCK?= =?utf-8?Q?X99jNsQ+1MIqCPWl/GiAGSS3DuJbNgPcwt6/TgDn9hCGOQ4a2tM=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk VGhhbmsgeW91IGZvciB5b3VyIHJlcGx5LiBJIGFtIGdyYXRlZnVsIGZvciB5b3VyIGtub3ds ZWRnZS4gDQoNCk15IGFpbSBpcyB0byBiZSBhYmxlIHRvIHNlZSANCg0KMS4gSXMgcmVwbGlj YXRpb24gY2F1Z2h0IHVwICAtLT4gIE5vIHByb2JsZW1zIGhlcmUNCjIuIElmIG5vdCBjYXVn aHQgdXAgLCB3aGF0IGlzIHRoZSBMU04gZGlmZmVyZW5jZSAtLT4gTm8gcHJvYmxlbXMgaGVy ZSAsIHlvdSBoYXZlIGFscmVhZHkgaGVscGVkIG1lIA0KMy4gSWYgbm90IGNhdWdodCB1cCwg aG93IG1hbnkgYnl0ZXMgLyBLQiB3b3J0aCBvZiBkYXRhIG5lZWRzIHRvIGJlIHJlcGxpY2F0 ZWQgDQoNClNvIGZhciBteSByZXBsaWNhdGlvbiBydW5zIGxpa2UgYSBkcmVhbSwgSSBhbSBq dXN0IHByZXBhcmluZyBmb3Igd2hlbiB3ZSB0cmFuc2ZlciBvdXIgbWFpbmZyYW1lIHRhYmxl cyB0byBQb3N0Z3JlcyBhbmQgSSBzaG91bGQgYmUgYWJsZSB0byBhbnN3ZXIgc3VjaCBxdWVz dGlvbnMuIA0KDQpJIGFtIGp1c3QgcHJlcGFyaW5nIG15c2VsZi4NCg0KTEcNCg0KUmFtIA0K DQoNCg0KDQpGcmV1bmRsaWNoZSBHcsO8w59lDQoNCmkuIEEuIFJhbWFjaGFuZHJhbiBTdWJy YW1hbmlhbg0KWmVudHJhbGJlcmVpY2ggSW5mb3JtYXRpb25zdGVjaG5vbG9naWUNCg0KQWx0 ZSBMZWlwemlnZXIgTGViZW5zdmVyc2ljaGVydW5nIGEuRy4NCg0KDQpIYWxsZXNjaGUgS3Jh bmtlbnZlcnNpY2hlcnVuZyBhLkcuDQoNCg0KDQoNCg0KDQoNCkFsdGUgTGVpcHppZ2VyIExl YmVuc3ZlcnNpY2hlcnVuZyBhLkcuLCBBbHRlIExlaXB6aWdlci1QbGF0eiAxLCA2MTQ0MCBP YmVydXJzZWwNClZvcnMuIGRlcyBBdWZzaWNodHNyYXRzOiBEci4gV2FsdGVyIEJvdGVybWFu biDCtyBWb3JzdGFuZDogQ2hyaXN0b3BoIEJvaG4gKFZvcnMuKSwgRHIuIErDvHJnZW4gQmll cmJhdW0gKHN0di4gVm9ycy4pLCBGcmFuayBLZXR0bmFrZXIsIERyLiBKb2NoZW4gS3JpZWdt ZWllciwgQWxleGFuZGVyIE1heWVyLCBDaHJpc3RpYW4gUGFwZSwgV2lsdHJ1ZCBQZWthcmVr LCBVZG8gV2lsY3Nlaw0KU2l0eiBPYmVydXJzZWwgKFRhdW51cykgwrcgUmVjaHRzZm9ybSBW VmFHIMK3IEFtdHNnZXJpY2h0IEJhZCBIb21idXJnIHYuIGQuIEguIEhSQiAxNTgzIMK3IFVT dC4tSWROci4gREUgMTE0MTA2ODE0DQoNCg0KDQoNCg0KIA0KSGFsbGVzY2hlIEtyYW5rZW52 ZXJzaWNoZXJ1bmcgYS5HLiwgIEzDtmZmZWxzdHJhw59lIDM0LTM4LCA3MDU5NyBTdHV0dGdh cnQNClZvcnMuIGRlcyBBdWZzaWNodHNyYXRzOiBEci4gV2FsdGVyIEJvdGVybWFubiDCtyBW b3JzdGFuZDogQ2hyaXN0b3BoIEJvaG4gKFZvcnMuKSwgRHIuIErDvHJnZW4gQmllcmJhdW0g KHN0di4gVm9ycy4pLCBGcmFuayBLZXR0bmFrZXIsIERyLiBKb2NoZW4gS3JpZWdtZWllciwg QWxleGFuZGVyIE1heWVyLCBDaHJpc3RpYW4gUGFwZSwNCldpbHRydWQgUGVrYXJlaywgVWRv IFdpbGNzZWsNClNpdHogU3R1dHRnYXJ0IMK3IFJlY2h0c2Zvcm0gVlZhRyDCtyBBbXRzZ2Vy aWNodCBTdHV0dGdhcnQgSFJCIDI2ODYgwrcgVVN0Li1JZE5yLiBERSAxNDc4MDIyODUNCkJl aXRyw6RnZSB6dSBwcml2YXRlbiBLcmFua2VuLSB1bmQgUGZsZWdla3JhbmtlbnZlcnNpY2hl cnVuZ2VuIHVudGVybGllZ2VuIG5pY2h0IGRlciBWZXJzaWNoZXJ1bmdzdGV1ZXIgKMKnIDQg TnIuIDUgVmVyc1N0RykgwrcgVmVyc2ljaGVydW5nc2xlaXN0dW5nZW4gc293aWUgVW1zw6R0 emUgYXVzIFZlcnNpY2hlcnVuZ3N2ZXJ0cmV0ZXItL01ha2xlcnTDpHRpZ2tlaXRlbiBzaW5k IHVtc2F0enN0ZXVlcmZyZWkNCiANCg0KDQoNCiANCkRpZSBQZmxpY2h0YW5nYWJlbiBkZXIg QUxIIEdydXBwZSBnZW3DpMOfIMKnIDM1YSBHbWJIRyBiencuIMKnIDgwIEFrdEcgZmluZGVu IFNpZSBoaWVyOiBodHRwczovL3d3dy5hbHRlLWxlaXB6aWdlci5kZS9pbXByZXNzdW0gDQoN Cg0KDQoNCg0KX19fX19fX19fX19fX19fX19fX19fXw0KDQpBTEggR3J1cHBlDQpBbHRlIExl aXB6aWdlci1QbGF0eiAxLCA2MTQ0MCBPYmVydXJzZWwNClRlbC46ICs0OSAoNjE3MSkgNjYt NDg4Mg0KRmF4OiArNDkgKDYxNzEpIDY2LTgwMC00ODgyDQpFLU1haWw6IHJhbWFjaGFuZHJh bi5zdWJyYW1hbmlhbkBhbHRlLWxlaXB6aWdlci5kZQ0Kd3d3LmFsdGUtbGVpcHppZ2VyLmRl DQp3d3cuaGFsbGVzY2hlLmRlDQoNCg0KDQotLS0tLVVyc3Byw7xuZ2xpY2hlIE5hY2hyaWNo dC0tLS0tDQpWb246IExhdXJlbnogQWxiZSA8bGF1cmVuei5hbGJlQGN5YmVydGVjLmF0PiAN Ckdlc2VuZGV0OiBEaWVuc3RhZywgMjQuIE3DpHJ6IDIwMjYgMDg6MDcNCkFuOiBTdWJyYW1h bmlhbixSYW1hY2hhbmRyYW4gSVQtbWQtZGIgPHJhbWFjaGFuZHJhbi5zdWJyYW1hbmlhbkBh bHRlLWxlaXB6aWdlci5kZT47IHBnc3FsLW5vdmljZUBsaXN0cy5wb3N0Z3Jlc3FsLm9yZw0K QmV0cmVmZjogUmU6IFJlcGxpY2F0aW9uIFRlc3RpbmctIEhvdyB0byBpbnRyb2R1Y2UgYSBM YWcNCg0KT24gVHVlLCAyMDI2LTAzLTI0IGF0IDA2OjE0ICswMDAwLCBTdWJyYW1hbmlhbixS YW1hY2hhbmRyYW4gd3JvdGU6DQo+IEkgbm90aWNlZCB0aGF0IGlmIEkgaW5zZXJ0IG9uZSBy b3cgaW4gYSB0YWJsZSBhdCB0aGUgc291cmNlLCB0aGUgDQo+IGRpZmZlcmVuY2UgaW4gTFNO cyBpcyBub3QgMSAuwqAgKCB3aXRoIGEgZGVsaWJyYXRlbHkgaW50cm9kdWNlZCBkZWxheSAN Cj4gb24gdGhlIGFwcGx5IHNpZGUgKSwNCj4gDQo+IEl0IGlzIHNvbWV0aW1lcyA5Niwgc29t ZXRpbWVzIDI5NiAoIGZvciB0aGUgc2FtZSB0YWJsZSB0d28gaW5zZXJ0c8KgICkgLg0KDQpS aWdodCwgYmVjYXVzZSB0aGUgTFNOIGlzIG5vdCBhIGNvdW50ZXIgdGhhdCBpbmNyZWFzZXMg d2l0aCBlYWNoIG5ldyBXQUwgcmVjb3JkLiAgSXQgaXMgYSBwb3NpdGlvbiBpbiB0aGUgV0FM IHN0cmVhbS4gIFRoZSBkaWZmZXJlbmNlIGJldHdlZW4gdGhlIExTTnMgb2YgdHdvIGFkamFj ZW50IFdBTCByZWNvcmRzIGlzIG5vdCAxLCBidXQgdGhlIGJ5dGUgY291bnQgb2YgdGhlIGZp cnN0IFdBTCByZWNvcmQuDQoNCkZvciBleGFtcGxlOiBpZiB5b3UgaW5zZXJ0IGEgbGFyZ2Vy IHJvdywgdGhlIExTTiB3aWxsIGFkdmFuY2UgbW9yZS4NCk5vdGUgYWxzbyB0aGF0IG5vdCBh bGwgaW5zZXJ0cyB3aWxsIHByb2R1Y2UgdGhlIHNhbWUga2luZCBvZiBXQUw6DQpvbmUgaW5z ZXJ0IG1pZ2h0IHdyaXRlIGEgZnVsbCBwYWdlIGltYWdlIHRvIHRoZSBXQUwsIHdoaWxlIHRo ZSBuZXh0IGEgbm9ybWFsIGluc2VydCByZWNvcmQuDQoNCj4gSXMgdGhlcmUgYSBtZXRob2Qg dG8gY2FsY3VsYXRlIHRoZSBBUFBST1hJTUFURSBhbW91bnQgb2YgZGF0YSBpbiAoIA0KPiBC eXRlcyApIHRoYXQgYXJlIHlldCB0byBiZSB0cmFuc2ZlcmVkIGZyb20gU291cmNlIHRvIFN0 YW5kYnkgPw0KDQpUaGF0J3MgZXhhY3RseSB3aGF0IHBnX3dhbF9sc25fZGlmZigpIGRvZXMu DQoNCldoYXQgaXMgeW91ciB3b3JyeT8gIFdoYXQgaXMgeW91ciB1bHRpbWF0ZSBnb2FsPw0K DQpZb3VycywNCkxhdXJlbnogQWxiZQ0K