Re: Log File Maintainance

From: Richard Huxton <dev(at)archonet(dot)com>
To: nrdb01(at)butterflystitches(dot)com(dot)au
Cc: List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Log File Maintainance
Date: 2005-04-13 07:42:39
Message-ID: 425CCD6F.2090404@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Neil Dugan wrote:
> On Tue, 2005-04-12 at 08:51 +0100, Richard Huxton wrote:
>
>>Inpreet Singh wrote:
>>
>>>syslog = 2 # range 0-2
>>>syslog_facility = 'LOCAL0'
>>>syslog_ident = 'postgres'
>>
>>You also need to update your syslog.conf and restart syslogd
>>
>>Add a line like:
>>local0.* /var/log/pgsql

> Saw this post and tried to setup the log info to be sent to a different
> file '/var/log/pgsql'. There was no trouble with this.
>
> I then thought I would use a more logical name than 'LOCAL0' for the
> facility name. However no matter what name I tried
> '/etc/init.d/postgresql' wouldn't restart the 'postmaster' program.

The local0/1/etc facilities are for "custom" applications logging to
syslog. You can see a list of valid facilities with "man syslog.conf"

HTH
--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Clifton Zama 2005-04-13 08:01:21 Connection closing
Previous Message Jinane Haddad 2005-04-13 05:21:30 Re: What are the consequences of a bad database design (never seen