Re: Log File Maintainance - Mailing list pgsql-general

From Richard Huxton
Subject Re: Log File Maintainance
Date
Msg-id 425CCD6F.2090404@archonet.com
Whole thread Raw
In response to Log File Maintainance  (Inpreet Singh <Singh.Inpreet@netsity.com>)
List 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

pgsql-general by date:

Previous
From: "Jinane Haddad"
Date:
Subject: Re: What are the consequences of a bad database design (never seen
Next
From: Dawid Kuroczko
Date:
Subject: Re: psql vs perl prepared inserts