Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

PG levels vs. syslog levels


  • From: Steve Crawford <scrawford(at)pinpointresearch(dot)com>
  • To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
  • Subject: PG levels vs. syslog levels
  • Date: Thu, 20 Sep 2007 13:03:46 -0700
  • Message-id: <46F2D222.4030808@pinpointresearch.com> <text/plain>

What is the correlation between PostgreSQL log severity levels and
syslog levels?

Specifically, I have PG (8.1) configured to route messages to syslog and
want to configure syslog to give me a periodic report of all error/worse
events. I configured syslog (syslog-ng) to create hourly files of
error/worse from the PG log data (local2 for me) and generated some
client errors ("select 1 from nonexistent_table;")

As expected, my log shows:
...[23084]: [13-1] ERROR:  relation "nonexistent_table" does not exist
...[23084]: [13-2] STATEMENT:  select 1 from nonexistent_table;

But my special error log does not. After some testing I have determined
that syslog is seeing this as level "warning".

Thoughts/suggestions?

Cheers,
Steve



Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group