Received: from joeconway.com (unknown [63.210.180.150])
	by postgresql.org (Postfix) with ESMTP
	id E722147593C; Thu, 14 Mar 2002 14:27:01 -0500 (EST)
Received: from [206.19.64.3] (account jconway HELO joeconway.com)
	by joeconway.com (CommuniGate Pro SMTP 3.5.6)
	with ESMTP-TLS id 273356; Thu, 14 Mar 2002 11:24:33 -0800
Message-ID: <3C90F994.3080605@joeconway.com>
Date: Thu, 14 Mar 2002 11:27:16 -0800
From: Joe Conway <mail@joeconway.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:0.9.8) Gecko/20020204
X-Accept-Language: en-us
MIME-Version: 1.0
To: Jie Liang <jie@stbernard.com>
Cc: "'pgsql-admin@postgresql.org'" <pgsql-admin@postgresql.org>,
	pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: Syslog
References: <7C760DAA511DC74B99E7D22189F786F1906DB0@MAIL01.stbernard.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200203/209
X-Sequence-Number: 3743

Jie Liang wrote:
> I did, it didn't work.
> 
> Jie Liang

Works for me. Did you change postgresql.conf? Here's what mine looks like.

#
#       Syslog
#
# requires ENABLE_SYSLOG
syslog = 1                      # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

 From the online docs:
SYSLOG (integer)

     PostgreSQL allows the use of syslog for logging. If this option is 
set to 1, messages go both to syslog and the standard output. A setting 
of 2 sends output only to syslog. (Some messages will still go to the 
standard output/error.) The default is 0, which means syslog is off. 
This option must be set at server start.

     To use syslog, the build of PostgreSQL must be configured with the 
--enable-syslog option.


See:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html

Joe