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 1w3TQU-001FwY-2y for pgsql-novice@arkaria.postgresql.org; Fri, 20 Mar 2026 06:33:43 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w3TQS-004bDK-3B for pgsql-novice@arkaria.postgresql.org; Fri, 20 Mar 2026 06:33:41 +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 1w3TQS-004bDC-2C for pgsql-novice@lists.postgresql.org; Fri, 20 Mar 2026 06:33:41 +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 1w3TQQ-000000008Kx-00Ga for pgsql-novice@lists.postgresql.org; Fri, 20 Mar 2026 06:33:40 +0000 X-CSE-ConnectionGUID: WwwiJ138SX6tM+4EJYOacQ== X-CSE-MsgGUID: LGGoFVRyRxW6EX9P25xLHQ== From: "Subramanian,Ramachandran" To: "pgsql-novice@lists.postgresql.org" Subject: Replication Testing- How to introduce a Lag Thread-Topic: Replication Testing- How to introduce a Lag Thread-Index: Ady4MjqE+gxrXzJnQUWNOQXrsmaORw== Date: Fri, 20 Mar 2026 06:33:32 +0000 Message-ID: Accept-Language: de-DE, en-US Content-Language: de-DE X-MS-Has-Attach: X-MS-TNEF-Correlator: x-tmase-matchedrid: TS/yG7dSaeLA4CiDIW4gQLbW4WOZNAUnj5XD/cFEQwaQ+UeH24Dz4Lhu upHpXEmLU2VRnkEujdpjybcuQlsAB7ipA0mFNtPDyGyaQXOvRx4pihtGF1HQYaINgcEzNI9jZFU 1OAyYdMNZjJ97HVOvx69eyMYvo72fErK2OKtB0zk7dj0ET35/kX0gPMfY5ZSDCMUpDZuf68CnEQ vbaWWwjW3tEPeQ6Au1q7jcr+YBl/ERuXKtTCWzQkleHToHqLtMxn+edHpR6uw6xE4+OwCoLodzV vJMoj8Hzo0Sdks/2idB+8n+rEL8gyFILI1sM63uSx9mAhxKYj1aTFqtRqmPY4vXantxmoFYJlgi LSi2UCBUPL7a7MR7U4ceJPwgZdF1gcs/3nKzwYwhPK2mn+OsTOuLKunpGCmt+jcoJioe6KS651H nD16EE155qY0vyso/BPsCWqKv2JARYDYQZL1SIixzfTNmJhtoLHgsl9818kALe0w2tS+bea+eCS MeOiOkjTCyU1yJ9GT8XLwN2+AeMFYHXldrySG2qjbLZMihvv2jJT0vRvqKuRn4EfAqfSVtmb5Ih RdG6ZH7lxAiZxp6RQ== x-tm-as-user-approved-sender: No x-tm-as-user-blocked-sender: No x-tmase-result: 10--26.466400-8.000000 x-tm-snts-smtp: C290B033FE94BFDD992443432DB058FFAF2727326A0243DE2D4CEBD067E4C9532000:8 x-alsentwithgood: false Content-Type: multipart/alternative; boundary="_000_aadb9058660d4e10b5cee44b82458802alteleipzigerde_" MIME-Version: 1.0 X-GBS-PROC: HdXKzbHBUujujSc7GbdoHndlNiLV3PgPwIC97KhtlUCsJfQyqOkAJbIlMu26YbAi X-GBS-PROCJOB: =?utf-8?Q?H+QmgvTJ8Wg/r7pq6oCK6C042WaPg+zVCrM3n6N5b2SJQnBh56JN8mmoC+Ag?= =?utf-8?Q?kPkusxnIcTWMkcfFdsdlaBvg+/oTuuyfNWMd/mROycoBYJscmTL6kjSlaCjP?= =?utf-8?Q?5s2BiuOWzALGyLw8LarBwL0QXcZnj8ee/B0EkAtJrv7rf3aWOwo=3D?= List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_aadb9058660d4e10b5cee44b82458802alteleipzigerde_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello, I have set up streaming replication in a our test environment and it i= s working OK . 1. Is there a way to force a lag between the source and the stand-by = in an environment where there is NO load=3F 1. During the set up process as I was thrashing around from server to = server I received this message in the stand-by if I make the standby foll= ow a new server B after it had been following a server A. what seems to = work is, additionally clearing out the archive logs dir of the standby se= rver along with the data dir, before running the pg_basebackup from the s= tandby. I am extremely new to postgres and I want to make sure that wha= t I am doing is not a dangerous practice. FATAL: requested timeline 2 is not a child of this server=27s history LG Ram Freundliche Gr=FC=DFe i. A. Ramachandran Subramanian Zentralbereich Informationstechnologie Alte Leipziger Lebensversicherung a.G. Hallesche Krankenversicherung a.G. Alte Leipziger Lebensversicherung a.G., Alte Leipziger-Platz 1, 61440 Obe= rursel Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcs= ek Sitz Oberursel (Taunus) =B7 Rechtsform VVaG =B7 Amtsgericht Bad Homburg v= . d. H. HRB 1583 =B7 USt.-IdNr. DE 114106814 =20 Hallesche Krankenversicherung a.G., L=F6ffelstra=DFe 34-38, 70597 Stuttg= art Vors. des Aufsichtsrats: Dr. Walter Botermann =B7 Vorstand: Christoph Boh= n (Vors.), Dr. J=FCrgen Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Joche= n Kriegmeier, Alexander Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek Sitz Stuttgart =B7 Rechtsform VVaG =B7 Amtsgericht Stuttgart HRB 2686 = =B7 USt.-IdNr. DE 147802285 Beitr=E4ge zu privaten Kranken- und Pflegekrankenversicherungen unterlieg= en nicht der Versicherungsteuer (=A7 4 Nr. 5 VersStG) =B7 Versicherungsle= istungen sowie Ums=E4tze aus Versicherungsvertreter-/Maklert=E4tigkeiten = sind umsatzsteuerfrei =20 =20 Die Pflichtangaben der ALH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 Akt= G finden Sie hier: https://www.alte-leipziger.de/impressum=20 ______________________ ALH Gruppe Alte Leipziger-Platz 1, 61440 Oberursel Tel.: +49 (6171) 66-4882 Fax: +49 (6171) 66-800-4882 E-Mail: ramachandran.subramanian@alte-leipziger.de www.alte-leipziger.de www.hallesche.de --_000_aadb9058660d4e10b5cee44b82458802alteleipzigerde_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hello,

 

 

   I have set up streaming repl= ication in a our test environment and it is working OK .

 

 

 

  1. Is there a way to  force a lag between the so= urce and the stand-by in an environment where there is NO load=3F

 

  1. During the set up process as I was thrashing aroun= d from server to server I received this message in the stand-by if I make the standby follow a new server B after it had been following a s= erver A.  what seems to work is, additionally clearing out the archi= ve logs dir of the standby server along with the data dir, before running= the pg_basebackup from the standby.  I am extremely new to postgres and  I want to make sure that what I am d= oing is not a dangerous practice.

 

 

FATAL: requested timeline 2 is not a chil= d of this server=27s history

 

LG

 

Ram


Freundliche Gr=FC=DFe


i. A. Ramachandran Subrama= nian =20

Zentralbereich Informationst= echnologie

=20

Alte Leipziger Lebensversicherung a. G.<= /SPAN>

Hallesche Krankenversicherung a. G.

=20

______________________

ALH Gruppe
Alte Leipziger-Platz 1, 614= 40 Oberursel
Tel: +49 (6171) 66-4882
Fax: +49 (6171) 66-800-4882E-Mail: ramachandran.subramanian@alte-leipziger.de
www.alte-leipziger.de
www.hallesche.de

Alte Leipziger Lebensversich= erung a. G., Alte Leipziger-Platz 1, 61440 Oberursel

Vors. des Aufsichtsra= ts: Dr. Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrg= en Bierbaum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexand= er Mayer, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Oberursel (Taunus) =B7 = Rechtsform VVaG =B7 Amtsgericht Bad Homburg v. d. H. HRB 1583 =B7 USt.-Id= Nr. DE 114106814


Hallesche Krankenversicherun= g a. G., L=F6ffelstra=DFe 34-38, 70597 Stuttgart

Vors. des Aufsichtsrats: Dr.= Walter Botermann =B7 Vorstand: Christoph Bohn (Vors.), Dr. J=FCrgen Bier= baum (stv. Vors.), Frank Kettnaker, Dr. Jochen Kriegmeier, Alexander Maye= r, Christian Pape, Wiltrud Pekarek, Udo Wilcsek

Sitz Stuttgart =B7 Rechtsfor= m VVaG =B7 Amtsgericht Stuttgart HRB 2686 =B7 USt.-IdNr. DE 147802285

Beitr=E4ge zu privaten Krank= en- und Pflegekrankenversicherungen unterliegen nicht der Versicherungste= uer (=A7 4 (1) Nr. 5 b VersStG) =B7 Versicherungsleistungen sowie Ums=E4t= ze aus Versicherungsvertreter-/Maklert=E4tigkeiten sind umsatzsteuerfrei<= /SPAN>


= Pflichtangaben der A= LH Gruppe gem=E4=DF =A7 35a GmbHG bzw. =A7 80 AktG --_000_aadb9058660d4e10b5cee44b82458802alteleipzigerde_--