doc: Update outdated descriptions of wal_status in pg_replication_slots. · postgres/postgres@ff3007c · GitHub | Latest TMZ Celebrity News & Gossip | Watch TMZ Live
Skip to content

Commit ff3007c

Browse files
MasaoFujiiMasaoFujii
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 647cffd commit ff3007c

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)

TMZ Celebrity News – Breaking Stories, Videos & Gossip

Looking for the latest TMZ celebrity news? You've come to the right place. From shocking Hollywood scandals to exclusive videos, TMZ delivers it all in real time.

Whether it’s a red carpet slip-up, a viral paparazzi moment, or a legal drama involving your favorite stars, TMZ news is always first to break the story. Stay in the loop with daily updates, insider tips, and jaw-dropping photos.

🎥 Watch TMZ Live

TMZ Live brings you daily celebrity news and interviews straight from the TMZ newsroom. Don’t miss a beat—watch now and see what’s trending in Hollywood.