Re: Recovering standby from primary archived WAL segments

Поиск
Список
Период
Сортировка
От Ron
Тема Re: Recovering standby from primary archived WAL segments
Дата
Msg-id 8357c11f-388f-436a-bd51-4c4dcbc0ea7a@gmail.com
обсуждение исходный текст
Ответ на Re: Recovering standby from primary archived WAL segments  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список 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 по дате отправления:

Предыдущее
От: Rajesh Kumar
Дата:
Сообщение: Failover
Следующее
От: Ron
Дата:
Сообщение: Re: Recovering standby from primary archived WAL segments