From: Ebubekir Büyüktosun <ebubekir.buyuktosun@primeit.com.tr>
To: Laurenz Albe <laurenz.albe@cybertec.at>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Cc: pg <pg@primeit.com.tr>
Subject: Re: Recovering standby from primary archived WAL segments
Date: Sat, 04 Nov 2023 17:06:54 +0300
Message-ID: <14351699106084@mail.yandex.com.tr> (raw)
In-Reply-To: <117cf700fc5db3085f9e294e76f545e3d9ee72f0.camel@cybertec.at>
References: <27541699100382@mail.yandex.com.tr>
<117cf700fc5db3085f9e294e76f545e3d9ee72f0.camel@cybertec.at>
<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" <laurenz.albe@cybertec.at>:</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>
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, laurenz.albe@cybertec.at, pgsql-admin@lists.postgresql.org, pg@primeit.com.tr
Subject: Re: Recovering standby from primary archived WAL segments
In-Reply-To: <14351699106084@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