Re: [NOVICE] Postgres Syslog

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: "Delao, Darryl W" <ddelao(at)ou(dot)edu>, "'Steve Crawford'" <scrawford(at)pinpointresearch(dot)com>, "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>, "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Re: [NOVICE] Postgres Syslog
Date: 2003-04-03 19:30:00
Message-ID: 200304031430.00992.lamar.owen@wgcr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

On Monday 31 March 2003 09:02, Delao, Darryl W wrote:
> How about sending log messages to a single file. I see a file under
> var/log called pgsql, but it has nothing in it. What do I need to enable
> in the postgreql.conf to start logging to a local file?

You do this in the _syslog_ configuration, not in the PostgreSQL
configuration. That is just the way syslog works: PostgreSQL contacts the
local syslogd, and logs its message using the syslog facility you define in
postgresql.conf. What syslog does with that message is determined by
/etc/syslog.conf. That could be any one of all sorts of things, including,
but not limited to, logging to a single file, logging to a remote syslog
server, logging to the system console, logging to a printer, etc.....and it's
all controlled in /etc/syslog.conf. So 'man syslog.conf' and see what you
need to do.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-04-03 19:30:29 Re: triggers using row values
Previous Message Tamir Halperin 2003-04-03 19:21:56 Re: Rules, Triggers something more challenging

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-04-03 22:05:46 Re: question about auto increment like
Previous Message Tom Lane 2003-04-03 19:14:59 Re: Translating Oracle CREATE TRIGGER statement