Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commit0cd7fca

Browse files
committed
doc: Update outdated descriptions of wal_status in pg_replication_slots.
The documentation for pg_replication_slots previously mentioned onlymax_slot_wal_keep_size as a condition under which the wal_status columncould show unreserved or lost. However, since commitbe87200,replication slots can also be invalidated due to horizon or wal_level,and since commitac0e331, idle_replication_slot_timeout can alsotrigger this state.This commit updates the description of the wal_status column toreflect 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.comBackpatch-through: 16
1 parent8af310b commit0cd7fca

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
@@ -2819,20 +2819,18 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx
28192819
<para>
28202820
<literal>unreserved</literal> means that the slot no longer
28212821
retains the required WAL files and some of them are to be removed at
2822-
the next checkpoint. This state can return
2822+
the next checkpoint. This typically occurs when
2823+
<xref linkend="guc-max-slot-wal-keep-size"/> is set to
2824+
a non-negative value. This state can return
28232825
to <literal>reserved</literal> or <literal>extended</literal>.
28242826
</para>
28252827
</listitem>
28262828
<listitem>
28272829
<para>
2828-
<literal>lost</literal> means that some required WAL files have
2829-
been removed and this slot is no longer usable.
2830+
<literal>lost</literal> means that this slot is no longer usable.
28302831
</para>
28312832
</listitem>
28322833
</itemizedlist>
2833-
The last two states are seen only when
2834-
<xref linkend="guc-max-slot-wal-keep-size"/> is
2835-
non-negative.
28362834
</para></entry>
28372835
</row>
28382836

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp