Horton

Morph pg_replication_slots.min_safe_lsn to safe_wal_size

Alvaro Herrera <alvherre@alvh.no-ip.org>

View on postgr.es
Commit: a8aaa0c786b3a27706172cc7979684a122ebb706
Author: Alvaro Herrera <alvherre@alvh.no-ip.org>
Date: 2020-07-07T17:08:00Z
Releases: 14.0 
Morph pg_replication_slots.min_safe_lsn to safe_wal_size

The previous definition of the column was almost universally disliked,
so provide this updated definition which is more useful for monitoring
purposes: a large positive value is good, while zero or a negative value
means danger.  This should be operationally more convenient.

Backpatch to 13, where the new column to pg_replication_slots (and the
feature it represents) were added.

Author: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Author: Álvaro Herrera <alvherre@alvh.no-ip.org>
Reported-by: Fujii Masao <masao.fujii@oss.nttdata.com>
Discussion: https://postgr.es/m/9ddfbf8c-2f67-904d-44ed-cf8bc5916228@oss.nttdata.com

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +5 −2
src/backend/access/transam/xlog.c modified +2 −4
src/backend/catalog/system_views.sql modified +1 −1
src/backend/replication/slotfuncs.c modified +30 −10
src/include/access/xlog_internal.h modified +7 −0
src/include/catalog/catversion.h modified +1 −1
src/include/catalog/pg_proc.dat modified +2 −2
src/test/recovery/t/019_replslot_limit.pl modified +10 −12
src/test/regress/expected/rules.out modified +2 −2

Documentation touched

Discussion