Re: Syslog

From: Joe Conway <mail(at)joeconway(dot)com>
To: Jie Liang <jie(at)stbernard(dot)com>
Cc: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>, pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Syslog
Date: 2002-03-14 19:27:16
Message-ID: 3C90F994.3080605@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

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

In response to

  • Re: Syslog at 2002-03-14 18:55:38 from Jie Liang

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jie Liang 2002-03-14 20:13:49 Re: Syslog
Previous Message Dan Langille 2002-03-14 19:06:37 Re: [SQL] Syslog

Browse pgsql-sql by date

  From Date Subject
Next Message Jie Liang 2002-03-14 20:13:49 Re: Syslog
Previous Message Dan Langille 2002-03-14 19:06:37 Re: [SQL] Syslog