Re: Recovering standby from primary archived WAL segments

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Ron,
 
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.
 
Thanks for response,
 
04.11.2023, 17:16, "Ron" <ronljohnsonjr@xxxxxxxxx>:

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.

 
 
 
 
İyi çalışmalar
Best Regards
 
 

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux