Skip to content

Commit 37e37da

Browse files
committed
Add explanation of the various *_min_messages elog() values.
1 parent 0a4e357 commit 37e37da

File tree

1 file changed

+81
-5
lines changed

1 file changed

+81
-5
lines changed

doc/src/sgml/runtime.sgml

Lines changed: 81 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,5 +1,5 @@
11
<!--
2-
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.119 2002/06/16 00:09:11 momjian Exp $
2+
$Header: /cvsroot/pgsql/doc/src/sgml/runtime.sgml,v 1.120 2002/07/05 01:17:20 momjian Exp $
33
-->
44

55
<Chapter Id="runtime">
@@ -801,6 +801,81 @@ env PGOPTIONS='-c geqo=off' psql
801801
detail to the logs. <literal>LOG</> has a different precedence
802802
here than in <literal>CLIENT_MIN_MESSAGES</>.
803803
</para>
804+
<para>
805+
Here is a summary of the various message types:
806+
<variablelist>
807+
<varlistentry>
808+
<term><varname>DEBUG[1-5]</varname></term>
809+
<listitem>
810+
<para>
811+
This provides information for use by developers.
812+
</para>
813+
</listitem>
814+
</varlistentry>
815+
<varlistentry>
816+
<term><varname>INFO</varname></term>
817+
<listitem>
818+
<para>
819+
This provides information requested by the user, e.g.
820+
<command>SET</>.
821+
</para>
822+
</listitem>
823+
</varlistentry>
824+
<varlistentry>
825+
<term><varname>NOTICE</varname></term>
826+
<listitem>
827+
<para>
828+
This provides information that may be helpful to users, e.g.
829+
truncation of long identifiers, sequence creation as part of
830+
<command>SERIAL</>.
831+
</para>
832+
</listitem>
833+
</varlistentry>
834+
<varlistentry>
835+
<term><varname>WARNING</varname></term>
836+
<listitem>
837+
<para>
838+
This provides warnings to the user, e.g. <command>COMMIT</>
839+
outside a transaction.
840+
</para>
841+
</listitem>
842+
</varlistentry>
843+
<varlistentry>
844+
<term><varname>ERROR</varname></term>
845+
<listitem>
846+
<para>
847+
Reports the error that caused the transaction to abort.
848+
</para>
849+
</listitem>
850+
</varlistentry>
851+
852+
<varlistentry>
853+
<term><varname>LOG</varname></term>
854+
<listitem>
855+
<para>
856+
This reports information of interest to administrators, e.g.
857+
checkpoint activity.
858+
</para>
859+
</listitem>
860+
</varlistentry>
861+
<varlistentry>
862+
<term><varname>FATAL</varname></term>
863+
<listitem>
864+
<para>
865+
This reports why the backend session terminated.
866+
</para>
867+
</listitem>
868+
</varlistentry>
869+
<varlistentry>
870+
<term><varname>PANIC</varname></term>
871+
<listitem>
872+
<para>
873+
This reports why all backends restarted.
874+
</para>
875+
</listitem>
876+
</varlistentry>
877+
</variablelist>
878+
</para>
804879
</listitem>
805880
</varlistentry>
806881

@@ -812,10 +887,11 @@ env PGOPTIONS='-c geqo=off' psql
812887
default is <literal>NOTICE</>. Valid values are
813888
<literal>DEBUG5</>, <literal>DEBUG4</>, <literal>DEBUG3</>,
814889
<literal>DEBUG2</>, <literal>DEBUG1</>, <literal>LOG</>,
815-
<literal>NOTICE</>, <literal>WARNING</>, and <literal>ERROR</>.
816-
Later values send less information to the user. <literal>LOG</>
817-
has a different precedence here than in
818-
<literal>SERVER_MIN_MESSAGES</>.
890+
<literal>NOTICE</>, <literal>WARNING</>, and <literal>ERROR</>.
891+
Later values send less information to the user. <literal>LOG</>
892+
has a different precedence here than in
893+
<literal>SERVER_MIN_MESSAGES</>. Also see that section for an
894+
explanation of the various values.
819895
</para>
820896
</listitem>
821897
</varlistentry>

0 commit comments

Comments
 (0)