8000 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