10000 doc: Update outdated descriptions of wal_status in pg_replication_slots. · postgres/postgres@db51bdf · GitHub
[go: up one dir, main page]

Skip to content

Commit db51bdf

Browse files
committed
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 ac0e331, 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
1 parent 4ef4b9b commit db51bdf

File tree

1 file changed

+4
-6
lines changed

1 file changed

+4
-6
lines changed

doc/src/sgml/system-views.sgml

Lines changed: 4 additions & 6 deletions
Original file line numberDiff line numberDiff line change
@@ -2478,20 +2478,18 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
24782478
<para>
24792479
<literal>unreserved</literal> means that the slot no longer
24802480
retains the required WAL files and some of them are to be removed at
2481-
the next checkpoint. This state can return
2481+
the next checkpoint. This typically occurs when
2482+
<xref linkend="guc-max-slot-wal-keep-size"/> is set to
2483+
a non-negative value. This state can return
24822484
to <literal>reserved</literal> or <literal>extended</literal>.
24832485
</para>
24842486
</listitem>
24852487
<listitem>
24862488
<para>
2487-
<literal>lost</literal> means that some required WAL files have
2488-
been removed and this slot is no longer usable.
2489+
<literal>lost</literal> means that this slot is no longer usable.
24892490
</para>
24902491
</listitem>
24912492
</itemizedlist>
2492-
The last two states are seen only when
2493-
<xref linkend="guc-max-slot-wal-keep-size"/> is
2494-
non-negative.
24952493
</para></entry>
24962494
</row>
24972495

0 commit comments

Comments
 (0)
0