diff options
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/catalogs.sgml | 24 |
1 files changed, 17 insertions, 7 deletions
diff --git a/doc/src/sgml/catalogs.sgml b/doc/src/sgml/catalogs.sgml index 5a66115df1e..49a881b2621 100644 --- a/doc/src/sgml/catalogs.sgml +++ b/doc/src/sgml/catalogs.sgml @@ -11239,19 +11239,29 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx Possible values are: <itemizedlist> <listitem> - <para><literal>normal</literal> means that the claimed files + <para><literal>reserved</literal> means that the claimed files are within <varname>max_wal_size</varname>.</para> </listitem> <listitem> - <para><literal>reserved</literal> means + <para><literal>extended</literal> means that <varname>max_wal_size</varname> is exceeded but the files are - still held, either by some replication slot or - by <varname>wal_keep_segments</varname>.</para> + still retained, either by the replication slot or + by <varname>wal_keep_segments</varname>. + </para> </listitem> <listitem> - <para><literal>lost</literal> means that some WAL files are - definitely lost and this slot cannot be used to resume replication - anymore.</para> + <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 + 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. + </para> </listitem> </itemizedlist> The last two states are seen only when |