Re: Recovering standby from primary archived WAL segments

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Recovering standby from primary archived WAL segments
Date: 2023-11-04 14:16:19
Message-ID: 8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 11/4/23 08:42, Laurenz Albe wrote:
> On Sat, 2023-11-04 at 15:46 +0300, Ebubekir Büyüktosun wrote:
>> 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.
>>
>> If it is possible, how primary and/or standby servers must be configured?
> Set "restore_command" on the standby.

When using physical replication and a replication slot still exists in
pg_replication_slots, won't the WAL files "just" accumulate in pg_wal/ until
Pg on the replica is restarted?  (I just tested that, and it seems to work.)

--
Born in Arizona, moved to Babylonia.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ebubekir Büyüktosun 2023-11-04 14:41:42 Re: Recovering standby from primary archived WAL segments
Previous Message Ebubekir Büyüktosun 2023-11-04 14:06:54 Re: Recovering standby from primary archived WAL segments