Recovering standby from primary archived WAL segments

From: Ebubekir Büyüktosun <ebubekir(dot)buyuktosun(at)primeit(dot)com(dot)tr>
To: "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org>
Cc: pg <pg(at)primeit(dot)com(dot)tr>
Subject: Recovering standby from primary archived WAL segments
Date: 2023-11-04 12:46:05
Message-ID: 27541699100382@mail.yandex.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<div>Hello community,</div><div> </div><div>I want to ask how we should configure primary and/or standby servers in case of need to recover the standby server from primary archived WAL segments.</div><div> </div><div>In the scenario<span style="background-color:transparent">, standby server has down because of some server issues for 3 days while primary server has been working well and generating WAL segments and archiving them as configured. (You can consider primary server is configured to archive WAL segments setting the parameters archive_mode, archive_command and even restore_command.)  After 3 days in this </span>scenario, the problem in the <span style="background-color:transparent">standby server has been solved and we want to recover the standby from primary archived wal segments and continue the streaming replication as well <strong>instead of reinitializing the standby</strong>. My expectation in this case, postgres must manage itself to restore and send the archived WAL segments in the primary site which is required from standby server for recovery itself without any manuel intervention by DBA. If it is possible, how primary and/or standby servers must be configured?</span></div><div> </div><div>Thanks for your kind investigations.</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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2023-11-04 13:42:56 Re: Recovering standby from primary archived WAL segments
Previous Message M Sarwar 2023-11-03 23:07:47 Re: In PGAdmin, view compilation is running for ever