Re: Question about different behaviour in pg_wal when archive_mode is set on or off

2025-06-26 Thread David G. Johnston
On Thursday, June 26, 2025, Arpad Kiss A wrote: > Can someone explain why the difference in behavior? Does postgres only use > the seqno only to differentiate the wal files here? Why does postgres not > rotate out files in the former case? > Seems like it is being helpful not throwing away data

Question about different behaviour in pg_wal when archive_mode is set on or off

2025-06-26 Thread Arpad Kiss A
Hi, I'm trying to understand the relation between 'archive_mode', pg_wal directory, 'max_wal_size' and failover. I'm running the kubernetes example from patroni (patroni 4.0.6) When 'archive_mode: off', and I issue a couple of 'patronictl failover' commands I observe the following files pg_wal: