Re: Recovering standby from primary archived WAL segments - Mailing list pgsql-admin

From Ron
Subject Re: Recovering standby from primary archived WAL segments
Date
Msg-id 8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com
Whole thread Raw
In response to Re: Recovering standby from primary archived WAL segments  (Laurenz Albe <laurenz.albe@cybertec.at>)
List 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.



pgsql-admin by date:

Previous
From: Rajesh Kumar
Date:
Subject: Failover
Next
From: Ron
Date:
Subject: Re: Recovering standby from primary archived WAL segments