max_slot_wal_keep_size - trading-fr.com
Documentation: 17: 26.2. Log-Shipping Standby Servers
Rename configuration parameter wal_keep_segments to wal_keep_size (Fujii Masao) ... Allow WAL storage for replication slots to be limited by max_slot_wal_keep_size (Kyotaro Horiguchi).
Working with read replicas for Amazon RDS for PostgreSQL
The last two states are seen only when max_slot_wal_keep_size is non-negative. If restart_lsn is NULL, this field is null.
Amazon Aurora PostgreSQL parameters
The max_slot_wal_keep_size parameter controls the quantity of WAL data that the RDS for PostgreSQL DB instance retains in the pg_wal directory to serve slots.
PostgreSQL® Extensions to the JDBC API | pgJDBC
postgres-config update --config max_slot_wal_keep_size=2GB. ... max_replication_slots: Defines the number of replication slots for data streaming.
PostgreSQL: Documentation: 17: 19.6. Replication
postgres-config update --config max_slot_wal_keep_size=2GB.
Supabase CLI config
To illustrate, assume max_wal_size is 1GB and max_slot_wal_keep_size is 5GB. As long as a slot’s WAL file requirement is within 1GB, it’s wal_status remains reserved.
Giới thiệu về chức năng Replication(đồng bộ dữ liệu) của ...
If max_slot_wal_keep_size is -1 (the default), replication slots may retain an unlimited amount of WAL files. Otherwise, if restart_lsn of a replication slot ...
UGREEN NVMe Adapter, M.2 SSD M and M+B Key to NVMe PCIe 4.0 X4 ...
If the database parameter max_slot_wal_keep_size is set to a non default value, and the restart_lsn of a replication slot falls behind the current LSN by more than this size, the DMS task fails due to removal of required WAL files.
PostgreSQL 13: Don't let slots kill your primary
If max_slot_wal_keep_size is zero, which is the default value, then there’s no limit. I don’t recommend this, because it leads to failures when slots fill the disk.
Best of Vietnam 13 Day North to South Tour
Summary We are using max_slot_wal_keep_size from Postgresql 13 to prevent master from being killed by a lagging replication.