From: Ebubekir Büyüktosun <ebubekir.buyuktosun@primeit.com.tr>
To: Ron <ronljohnsonjr@gmail.com>
To: pgsql-admin@lists.postgresql.org <pgsql-admin@lists.postgresql.org>
Subject: Re: Recovering standby from primary archived WAL segments
Date: Sat, 04 Nov 2023 17:41:42 +0300
Message-ID: <387721699108418@mail.yandex.com.tr> (raw)
In-Reply-To: <8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com>
References: <27541699100382@mail.yandex.com.tr>
<117cf700fc5db3085f9e294e76f545e3d9ee72f0.camel@cybertec.at>
<8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com>
<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" <ronljohnsonjr@gmail.com>:</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>
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, ronljohnsonjr@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Recovering standby from primary archived WAL segments
In-Reply-To: <387721699108418@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