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 <hjp-pgsql(at)hjp(dot)at> 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(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"