diff options
Diffstat (limited to 'doc/src/sgml/system-views.sgml')
| -rw-r--r-- | doc/src/sgml/system-views.sgml | 13 |
1 files changed, 5 insertions, 8 deletions
diff --git a/doc/src/sgml/system-views.sgml b/doc/src/sgml/system-views.sgml index b58c52ea50f..e1ac544ee40 100644 --- a/doc/src/sgml/system-views.sgml +++ b/doc/src/sgml/system-views.sgml @@ -2819,21 +2819,18 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <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 + the next checkpoint. This typically occurs when + <xref linkend="guc-max-slot-wal-keep-size"/> is set to + a non-negative value. 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. + <literal>lost</literal> means that this slot is no longer usable. </para> </listitem> </itemizedlist> - The last two states are seen only when - <xref linkend="guc-max-slot-wal-keep-size"/> is - non-negative. If <structfield>restart_lsn</structfield> is NULL, this - field is null. </para></entry> </row> @@ -3932,7 +3929,7 @@ SELECT * FROM pg_locks pl LEFT JOIN pg_prepared_xacts ppx <structfield>passwd</structfield> <type>text</type> </para> <para> - Password (possibly encrypted); null if none. See + Encrypted password; null if none. See <link linkend="catalog-pg-authid"><structname>pg_authid</structname></link> for details of how encrypted passwords are stored. </para></entry> |