On 2023-03-28 11:07:04 -0400, Jeremy Smith wrote: > On Tue, Mar 28, 2023 at 10:55 AM Peter J. Holzer <hjp-pg...@hjp.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.
|_|_) | |
| | | h...@hjp.at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
Description: PGP signature
