Re: Recovering standby from primary archived WAL segments

From: Ebubekir Büyüktosun <ebubekir(dot)buyuktosun(at)primeit(dot)com(dot)tr>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>, "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: Re: Recovering standby from primary archived WAL segments
Date: 2023-11-04 14:06:54
Message-ID: 14351699106084@mail.yandex.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

<div>Hi Laurenz,</div><div> </div><div>Thanks for your response.</div><div> </div><div>I have already set it on standby site but i do not want to use any remote file copy utility such as "scp" in this command to restore archived wal in primary site. Instead, I expect postgres to send it whenever standby requires it if it is possible.</div><div> </div><div>But i will reconsider the parameter in detail for standby site.</div><div> </div><div>04.11.2023, 16:43, "Laurenz Albe" &lt;laurenz(dot)albe(at)cybertec(dot)at&gt;:</div><blockquote><p>On Sat, 2023-11-04 at 15:46 +0300, Ebubekir Büyüktosun wrote:</p><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><p><br />Set "restore_command" on the standby.<br /><br />Yours,<br />Laurenz Albe</p></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.6 KB

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ron 2023-11-04 14:16:19 Re: Recovering standby from primary archived WAL segments
Previous Message Rajesh Kumar 2023-11-04 13:55:58 Failover