From: Ebubekir Büyüktosun <ebubekir.buyuktosun@primeit.com.tr>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: pg <pg@primeit.com.tr>
Subject: Recovering standby from primary archived WAL segments
Date: Sat, 04 Nov 2023 15:46:05 +0300
Message-ID: <27541699100382@mail.yandex.com.tr> (raw)
<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>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ebubekir.buyuktosun@primeit.com.tr, pgsql-admin@lists.postgresql.org, pg@primeit.com.tr
Subject: Re: Recovering standby from primary archived WAL segments
In-Reply-To: <27541699100382@mail.yandex.com.tr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox