-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello,
Here is a patch that documents the syslog log levels and their
correlation to the PostgreSQL log levels per:
http://archives.postgresql.org/pgsql-general/2007-09/msg00982.php
Joshua D. Drake
- --
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240
PostgreSQL solutions since 1997 http://www.commandprompt.com/
UNIQUE NOT NULL
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFG8xNiATb/zqfZUUQRAodGAKCUiMZf1TUlMF+ijFM9jmndIkxp9wCgp13L
6EyxUqI7ycMw3w8ZeOeexwQ=
=0KcO
-----END PGP SIGNATURE-----
*** config.sgml 2007-09-20 17:39:44.000000000 -0700
--- config.sgml.jd 2007-09-20 17:39:18.000000000 -0700
***************
*** 2625,2631 ****
<term><literal>DEBUG[1-5]</literal></term>
<listitem>
<para>
! Provides information for use by developers.
</para>
</listitem>
</varlistentry>
--- 2625,2631 ----
<term><literal>DEBUG[1-5]</literal></term>
<listitem>
<para>
! Provides information for use by developers. The syslog facility will log DEBUG[1-5] as LOG_DEBUG.
</para>
</listitem>
</varlistentry>
***************
*** 2635,2641 ****
<listitem>
<para>
Provides information implicitly requested by the user,
! e.g., during <command>VACUUM VERBOSE</>.
</para>
</listitem>
</varlistentry>
--- 2635,2641 ----
<listitem>
<para>
Provides information implicitly requested by the user,
! e.g., during <command>VACUUM VERBOSE</>. The syslog facility will log INFO as LOG_INFO.
</para>
</listitem>
</varlistentry>
***************
*** 2646,2652 ****
<para>
Provides information that might be helpful to users, e.g.,
truncation of long identifiers and the creation of indexes as part
! of primary keys.
</para>
</listitem>
</varlistentry>
--- 2646,2652 ----
<para>
Provides information that might be helpful to users, e.g.,
truncation of long identifiers and the creation of indexes as part
! of primary keys. The syslog facility will log NOTICE as LOG_NOTICE.
</para>
</listitem>
</varlistentry>
***************
*** 2656,2662 ****
<listitem>
<para>
Provides warnings to the user, e.g., <command>COMMIT</>
! outside a transaction block.
</para>
</listitem>
</varlistentry>
--- 2656,2662 ----
<listitem>
<para>
Provides warnings to the user, e.g., <command>COMMIT</>
! outside a transaction block. The syslog facility will log WARNING as LOG_NOTICE.
</para>
</listitem>
</varlistentry>
***************
*** 2665,2671 ****
<term><literal>ERROR</literal></term>
<listitem>
<para>
! Reports an error that caused the current command to abort.
</para>
</listitem>
</varlistentry>
--- 2665,2671 ----
<term><literal>ERROR</literal></term>
<listitem>
<para>
! Reports an error that caused the current command to abort. The syslog facility will log ERROR as LOG_WARNING.
</para>
</listitem>
</varlistentry>
***************
*** 2675,2681 ****
<listitem>
<para>
Reports information of interest to administrators, e.g.,
! checkpoint activity.
</para>
</listitem>
</varlistentry>
--- 2675,2681 ----
<listitem>
<para>
Reports information of interest to administrators, e.g.,
! checkpoint activity. The syslog facility will log LOG as LOG_INFO.
</para>
</listitem>
</varlistentry>
***************
*** 2684,2690 ****
<term><literal>FATAL</literal></term>
<listitem>
<para>
! Reports an error that caused the current session to abort.
</para>
</listitem>
</varlistentry>
--- 2684,2690 ----
<term><literal>FATAL</literal></term>
<listitem>
<para>
! Reports an error that caused the current session to abort. The syslog facility will log FATAL as LOG_ERR.
</para>
</listitem>
</varlistentry>
***************
*** 2693,2699 ****
<term><literal>PANIC</literal></term>
<listitem>
<para>
! Reports an error that caused all sessions to abort.
</para>
</listitem>
</varlistentry>
--- 2693,2699 ----
<term><literal>PANIC</literal></term>
<listitem>
<para>
! Reports an error that caused all sessions to abort. The syslog facility will log PANIC as LOG_CRIT.
</para>
</listitem>
</varlistentry>
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend