diff options
| author | Fujii Masao <fujii@postgresql.org> | 2025-07-03 23:07:23 +0900 |
|---|---|---|
| committer | Fujii Masao <fujii@postgresql.org> | 2025-07-03 23:07:23 +0900 |
| commit | ff3007c66dc6213fcdaea9a996865bbd943e3e82 (patch) | |
| tree | 561aaade08d2c2e124e33fc5f9b8e17797619975 | |
| parent | 647cffd2f3210818f3882a1ea40cfbe0a4ea8fd7 (diff) | |
| download | postgresql-ff3007c66dc6213fcdaea9a996865bbd943e3e82.tar.gz postgresql-ff3007c66dc6213fcdaea9a996865bbd943e3e82.zip | |
doc: Update outdated descriptions of wal_status in pg_replication_slots.
The documentation for pg_replication_slots previously mentioned only
max_slot_wal_keep_size as a condition under which the wal_status column
could show unreserved or lost. However, since commit be87200,
replication slots can also be invalidated due to horizon or wal_level,
and since commit ac0e33136ab, idle_replication_slot_timeout can also
trigger this state.
This commit updates the description of the wal_status column to
reflect that max_slot_wal_keep_size is not the only cause of the lost state.
Back-patched to v16, where the additional invalidation cases were introduced.
Author: Fujii Masao <masao.fujii@gmail.com>
Reviewed-by: Hayato Kuroda <kuroda.hayato@fujitsu.com>
Reviewed-by: Nisha Moond <nisha.moond412@gmail.com>
Discussion: https://postgr.es/m/78b34e84-2195-4f28-a151-5d204a382fdd@oss.nttdata.com
Backpatch-through: 16
| -rw-r--r-- | doc/src/sgml/system-views.sgml | 10 |
1 files changed, 4 insertions, 6 deletions
diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml index 82825db03bb..e1ac544ee40 100644 --- a/doc/src/sgml/system-views.sgml +++ b/doc/src/sgml/system-views.sgml @@ -2819,20 +2819,18 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <para> <literal>unreserved</literal> means that the slot no longer retains the required WAL files and some of them are to be removed at - the next checkpoint. This state can return + the next checkpoint. This typically occurs when + <xref linkend="guc-max-slot-wal-keep-size"/> is set to + a non-negative value. This state can return to <literal>reserved</literal> or <literal>extended</literal>. </para> </listitem> <listitem> <para> - <literal>lost</literal> means that some required WAL files have - been removed and this slot is no longer usable. + <literal>lost</literal> means that this slot is no longer usable. </para> </listitem> </itemizedlist> - The last two states are seen only when - <xref linkend="guc-max-slot-wal-keep-size"/> is - non-negative. </para></entry> </row> |