Re: Patroni, slots, and expiring WALs

On 2023-03-28 11:07:04 -0400, Jeremy Smith wrote:
> On Tue, Mar 28, 2023 at 10:55 AM Peter J. Holzer  wrote:
> 
>     The configuration includes `use_slots: true` and I can see a slot in
>     pg_replication_slots on the leader.
> 
>     I was under the impression that this would be sufficient to prevent WALs
>     from being deleted on the leader before they are used on the replica.
> 
> 
> 
> Is max_slot_wal_keep_size set to something other than -1 on the leader? 

Nope, it's -1:

postgres=# show max_slot_wal_keep_size ;
╔════════════════════════╗
║ max_slot_wal_keep_size ║
╟────────────────────────╢
║ -1                     ║
╚════════════════════════╝
(1 row)

(Sorry, forgot to mention this)

        hp

-- 
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"