Re: Recovering standby from primary archived WAL segments

From: Ebubekir Büyüktosun <ebubekir(dot)buyuktosun(at)primeit(dot)com(dot)tr>
To: Ron <ronljohnsonjr(at)gmail(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Recovering standby from primary archived WAL segments
Date: 2023-11-04 14:41:42
Message-ID: 387721699108418@mail.yandex.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<div>Hi Ron,</div><div> </div><div>I test it using repmgr. So, when i close the postgres and repmgr services at the standby site, as i understand, repmgr drops it's replication slot so there is no wal accumulation in pg_wal at primary site but archiving is working well because it is enabled.</div><div> </div><div>Thanks for response,</div><div> </div><div>04.11.2023, 17:16, "Ron" &lt;ronljohnsonjr(at)gmail(dot)com&gt;:</div><blockquote><p>On 11/4/23 08:42, Laurenz Albe wrote:</p><blockquote> On Sat, 2023-11-04 at 15:46 +0300, Ebubekir Büyüktosun wrote:<blockquote> I want to ask how we should configure primary and/or standby servers in case of need<br /> to recover the standby server from primary archived WAL segments.<br />   <br /> If it is possible, how primary and/or standby servers must be configured?</blockquote> Set "restore_command" on the standby.</blockquote><p><br />When using physical replication and a replication slot still exists in<br />pg_replication_slots, won't the WAL files "just" accumulate in pg_wal/ until<br />Pg on the replica is restarted?  (I just tested that, and it seems to work.)<br /> </p>--<br />Born in Arizona, moved to Babylonia.<br /><br /> </blockquote><div> </div><div> </div><div> </div><div><span style="color:#000000;font-size:14px;line-height:normal"><strong><span style="font-family:'courier new' , monospace"><span style="background-color:#ffffff">İyi çalışmalar </span></span></strong></span></div><div><span style="color:#000000;font-size:14px;line-height:normal"><strong><span style="font-family:'courier new' , monospace"><span style="background-color:#ffffff">Best Regards</span></span></strong></span></div><div> </div><div><img src="https://avatars.mds.yandex.net/get-mail-signature/200369/b5cfbc69fec7ba407ad439c916819b51/orig" /></div><div> </div>

Attachment Content-Type Size
unknown_filename text/html 1.8 KB

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-11-04 14:47:01 Re: Recovering standby from primary archived WAL segments
Previous Message Ron 2023-11-04 14:16:19 Re: Recovering standby from primary archived WAL segments