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 1w3r5Y-001bhH-2p for pgsql-novice@arkaria.postgresql.org; Sat, 21 Mar 2026 07:49:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3r5X-009Z3A-0a for pgsql-novice@arkaria.postgresql.org; Sat, 21 Mar 2026 07:49:39 +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 1w3r5W-009Z32-30 for pgsql-novice@lists.postgresql.org; Sat, 21 Mar 2026 07:49:39 +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.98.2) (envelope-from ) id 1w3r5U-00000000JHq-1zvw for pgsql-novice@lists.postgresql.org; Sat, 21 Mar 2026 07:49:39 +0000 X-CSE-ConnectionGUID: +0dx6/8pTE+iAWgrCCzf9A== X-CSE-MsgGUID: 6J1rzny8RyqU7Om26r/Ygg== From: "Subramanian,Ramachandran" To: Laurenz Albe , "pgsql-novice@lists.postgresql.org" Subject: AW: AW: Replication Testing- How to introduce a Lag Thread-Topic: AW: Replication Testing- How to introduce a Lag Thread-Index: Ady4MjqE+gxrXzJnQUWNOQXrsmaORwAAj72AAAhinWAABBxegAAmzmJg Date: Sat, 21 Mar 2026 07:49:32 +0000 Message-ID: References: <8b38fa5141905f9ad6983b8d5ae944e812e3d28a.camel@cybertec.at> In-Reply-To: <8b38fa5141905f9ad6983b8d5ae944e812e3d28a.camel@cybertec.at> Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: 53GNlzVSQfRJC9HP7gEJMB8paS/kcIoKKQNhMboqZlrGZbX3v50Wr5Tp FYOhJjqcjhyWkMlRInCNOrKja3myFuRJdoquswRqGqSG/c50XgOlH6by0GLpki196sn93sBvWt1 9W/5IzWzOSgXj1Lh6hw5h8urPio1ecJb+cgUDbeIjRwcsjqWGAudjQ/G9Lk6QpJq3Yck2m7+jxY yRBa/qJUl4W8WVUOR/9xS3mVzWUuA4wHSyGpeEeloTs04oZl/C42IfPxHGjCYGJCXPIhFHJK6QP kbZRjFDVUN21kaVy/Q= x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--5.665200-8.000000 x-tm-snts-smtp: 523A93570136B5D0F10A5C967ECDA3A9C22E71BE8B576DF2A83AD77ACF7ADEF12000:8 x-alsentwithgood: false Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: base64 MIME-Version: 1.0 X-GBS-PROC: U4I20n4ULWTIC0V85elGeaezx9A6YaFLYHMsLhXBBFIjhySLeyWaj22GTLU7i8I8 X-GBS-PROCJOB: =?utf-8?Q?+vhoe2+0fv+oTRWf32rZ/jzxqDUxwMk7fKzfViG4ofnsB66A7V8I+vF3mSX4?= =?utf-8?Q?SX48lssKj5dZi2EqIN8ruwfdgwLCPrxT3TCbgcyW5vF2Wky16voY53Kazj2k?= =?utf-8?Q?Uf5Ge4uYRyrFUGMDjRHz67InH/6JODnAYY7jQFVT+xJCqumU8B8=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk PiBob3cgY2FuIHRoZSBsYXN0IHJlcGxheWVkIGJlIG1vcmUgdGhhbiB0aGUgbGFzdCByZWNl aXZlZD8NCg0KSXQgc2hvdWxkbid0IGJlIC0gYnV0IEkgZG9uJ3QgdW5kZXJzdGFuZCB5b3Vy IHNjcmlwdCwgaW4gcGFydGljdWxhciB3aGljaCBxdWVyeSBpcyBpc3N1c2VkIG9uIHdoaWNo IHNlcnZlci4NCg0KW1N1YnJhbWFuaWFuLFJhbWFjaGFuZHJhbiBJVC1tZC1kYl0gDQoxMDAl IHN1cmUgdGhhdCBJIGhhdmUgc2NyZXdlZCB1cCBzb21lIHZhcmlhYmxlcyBpbiBteSBzY3Jp cHQNCg0KTG9vayBhdCAicGdfc3RhdF9yZXBsaWNhdGlvbiIgb24gdGhlIHByaW1hcnkgc2Vy dmVyLg0KDQpbU3VicmFtYW5pYW4sUmFtYWNoYW5kcmFuIElULW1kLWRiXSANCg0KVGhhbmsg eW91IHNvIG11Y2ghISAgU28gSSBkbyBub3QgaGF2ZSB0byBnbyBhY3Jvc3MgbXVsdGlwbGUg dGFibGVzIHRvIGNvbGxlY3QgdGhlIGluZm9ybWF0aW9uLiANCg0KSXQgaXMgYWxsIHRoZXJl IGluIG9uZSB0YWJsZSBwZ19zdGF0X3JlcGxpY2F0aW9uIGF0IHRoZSBQcmltYXJ5IHNlcnZl ciBhbmQgd2UgY2FuIGxvb2sgYXQgaXQgZnJvbSBBKSBQcmltYXJ5IGFuZCBhbHNvIGZyb20g QikgU3RhbmQtYnkgISEgDQoNCklmIEkganVzdCBsb29rIGF0IHRoZSB3cml0ZV9sYWcgY29s dW1ucywgaXQgd291bGQgZ2l2ZSBtZSBhIGdvb2QgaWRlYSBvZiB0aGUgc2l0dWF0aW9uIC0t ICBJcyBteSB1bmRlcnN0YW5kaW5nIGNvcnJlY3QgPw0KDQpMRw0KDQpSYW0NCg0KDQpEZXRh aWxzIGZyb20gdGhlIFNvdXJjZSAoUmVtb3RlIFByaW1hcnkpDQotLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tDQoNCnBpZCAgIHwg dXNlc3lzaWQgfCAgdXNlbmFtZSAgIHwgYXBwbGljYXRpb25fbmFtZSB8IGNsaWVudF9hZGRy IHwgY2xpZW50X2hvc3RuYW1lIHwgY2xpZW50X3BvcnQgfCAgICAgICAgIGJhY2tlbmRfc3Rh cnQNCiAgfCBiYWNrZW5kX3htaW4gfCAgIHN0YXRlICAgfCAgc2VudF9sc24gIHwgd3JpdGVf bHNuICB8IGZsdXNoX2xzbiAgfCByZXBsYXlfbHNuIHwgICAgd3JpdGVfbGFnICAgIHwgICAg Zmx1c2hfbGFnICAgIHwgICByZXBsYXkNCl9sYWcgICAgfCBzeW5jX3ByaW9yaXR5IHwgc3lu Y19zdGF0ZSB8ICAgICAgICAgIHJlcGx5X3RpbWUNCi0tLS0tLS0tKy0tLS0tLS0tLS0rLS0t LS0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0t LS0tLS0tKy0tLS0tLS0tLS0tLS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0NCi0t Ky0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0r LS0tLS0tLS0tLS0tKy0tLS0tLS0tLS0tLSstLS0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0tLS0tLSstLS0tLS0tLS0NCi0tLS0tLS0tKy0tLS0tLS0tLS0tLS0tLSstLS0tLS0tLS0t LS0rLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDE4ODgzMyB8ICAgIDI1MjAw IHwgcmVwbGljYXRvciB8IHdhbHJlY2VpdmVyICAgICAgfCAxMC4xMC4xMC4xMCAgfCAgICAg ICAgICAgICAgICAgfCAgICAgICA0MzMzMCB8IDIwMjYtMDMtMjEgMDg6MTE6MzcuMDEwODk1 KzANCjEgfCAgICAgICAgICAgICAgfCBzdHJlYW1pbmcgfCAwLzQ5MDcyNTkwIHwgMC80OTA3 MjU5MCB8IDAvNDkwNzI1OTAgfCAwLzQ5MDQyRjk4IHwgMDA6MDA6MDAuMDAwNDYzIHwgMDA6 MDA6MDAuMDAxNjkzIHwgMDA6MDA6MjcNCi4wNDIyNjIgfCAgICAgICAgICAgICAwIHwgYXN5 bmMgICAgICB8IDIwMjYtMDMtMjEgMDg6MTI6MTkuMjM5NTM1KzAxDQooMSByb3cpDQoNClRo ZSBzYW1lIGRldGFpbHMgZnJvbSB0aGUgTG9jYWwgU3RhbmQtYnkgU2VydmVyIC0tIFRoZXkg bWF0Y2ggISEhIQ0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KDQpwZ19sYXN0X3dh bF9yZWNlaXZlX2xzbg0KLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLQ0KIDAvNDkwNzI1OTAN CigxIHJvdykNCg0KIHBnX2xhc3Rfd2FsX3JlcGxheV9sc24NCi0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLQ0KIDAvNDkwNDJGOTgNCigxIHJvdykNCg0KDQpGcmV1bmRsaWNoZSBHcsO8w59l DQoNCmkuIEEuIFJhbWFjaGFuZHJhbiBTdWJyYW1hbmlhbg0KWmVudHJhbGJlcmVpY2ggSW5m b3JtYXRpb25zdGVjaG5vbG9naWUNCg0KQWx0ZSBMZWlwemlnZXIgTGViZW5zdmVyc2ljaGVy dW5nIGEuRy4NCg0KDQpIYWxsZXNjaGUgS3JhbmtlbnZlcnNpY2hlcnVuZyBhLkcuDQoNCg0K DQoNCg0KQWx0ZSBMZWlwemlnZXIgTGViZW5zdmVyc2ljaGVydW5nIGEuRy4sIEFsdGUgTGVp cHppZ2VyLVBsYXR6IDEsIDYxNDQwIE9iZXJ1cnNlbA0KVm9ycy4gZGVzIEF1ZnNpY2h0c3Jh dHM6IERyLiBXYWx0ZXIgQm90ZXJtYW5uIMK3IFZvcnN0YW5kOiBDaHJpc3RvcGggQm9obiAo Vm9ycy4pLCBEci4gSsO8cmdlbiBCaWVyYmF1bSAoc3R2LiBWb3JzLiksIEZyYW5rIEtldHRu YWtlciwgRHIuIEpvY2hlbiBLcmllZ21laWVyLCBBbGV4YW5kZXIgTWF5ZXIsIENocmlzdGlh biBQYXBlLCBXaWx0cnVkIFBla2FyZWssIFVkbyBXaWxjc2VrDQpTaXR6IE9iZXJ1cnNlbCAo VGF1bnVzKSDCtyBSZWNodHNmb3JtIFZWYUcgwrcgQW10c2dlcmljaHQgQmFkIEhvbWJ1cmcg di4gZC4gSC4gSFJCIDE1ODMgwrcgVVN0Li1JZE5yLiBERSAxMTQxMDY4MTQNCg0KDQoNCg0K DQogDQpIYWxsZXNjaGUgS3JhbmtlbnZlcnNpY2hlcnVuZyBhLkcuLCAgTMO2ZmZlbHN0cmHD n2UgMzQtMzgsIDcwNTk3IFN0dXR0Z2FydA0KVm9ycy4gZGVzIEF1ZnNpY2h0c3JhdHM6IERy LiBXYWx0ZXIgQm90ZXJtYW5uIMK3IFZvcnN0YW5kOiBDaHJpc3RvcGggQm9obiAoVm9ycy4p LCBEci4gSsO8cmdlbiBCaWVyYmF1bSAoc3R2LiBWb3JzLiksIEZyYW5rIEtldHRuYWtlciwg RHIuIEpvY2hlbiBLcmllZ21laWVyLCBBbGV4YW5kZXIgTWF5ZXIsIENocmlzdGlhbiBQYXBl LA0KV2lsdHJ1ZCBQZWthcmVrLCBVZG8gV2lsY3Nlaw0KU2l0eiBTdHV0dGdhcnQgwrcgUmVj aHRzZm9ybSBWVmFHIMK3IEFtdHNnZXJpY2h0IFN0dXR0Z2FydCBIUkIgMjY4NiDCtyBVU3Qu LUlkTnIuIERFIDE0NzgwMjI4NQ0KQmVpdHLDpGdlIHp1IHByaXZhdGVuIEtyYW5rZW4tIHVu ZCBQZmxlZ2VrcmFua2VudmVyc2ljaGVydW5nZW4gdW50ZXJsaWVnZW4gbmljaHQgZGVyIFZl cnNpY2hlcnVuZ3N0ZXVlciAowqcgNCBOci4gNSBWZXJzU3RHKSDCtyBWZXJzaWNoZXJ1bmdz bGVpc3R1bmdlbiBzb3dpZSBVbXPDpHR6ZSBhdXMgVmVyc2ljaGVydW5nc3ZlcnRyZXRlci0v TWFrbGVydMOkdGlna2VpdGVuIHNpbmQgdW1zYXR6c3RldWVyZnJlaQ0KIA0KDQoNCg0KIA0K RGllIFBmbGljaHRhbmdhYmVuIGRlciBBTEggR3J1cHBlIGdlbcOkw58gwqcgMzVhIEdtYkhH IGJ6dy4gwqcgODAgQWt0RyBmaW5kZW4gU2llIGhpZXI6IGh0dHBzOi8vd3d3LmFsdGUtbGVp cHppZ2VyLmRlL2ltcHJlc3N1bSANCg0KDQoNCg0KDQpfX19fX19fX19fX19fX19fX19fX19f DQoNCkFMSCBHcnVwcGUNCkFsdGUgTGVpcHppZ2VyLVBsYXR6IDEsIDYxNDQwIE9iZXJ1cnNl bA0KVGVsLjogKzQ5ICg2MTcxKSA2Ni00ODgyDQpGYXg6ICs0OSAoNjE3MSkgNjYtODAwLTQ4 ODINCkUtTWFpbDogcmFtYWNoYW5kcmFuLnN1YnJhbWFuaWFuQGFsdGUtbGVpcHppZ2VyLmRl DQp3d3cuYWx0ZS1sZWlwemlnZXIuZGUNCnd3dy5oYWxsZXNjaGUuZGUNCg0K