Logging on Gentoo - Mailing list pgsql-general

From Thom Brown
Subject Logging on Gentoo
Date
Msg-id bddc86150901140409u8461e11x152e742d3fb2ee32@mail.gmail.com
Whole thread Raw
Responses Re: Logging on Gentoo  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi,

I've configured Postgres to log to stderr and defined my log directory correctly with permissions to postgres on both user and group.  I've restarted postgres (not reloaded) but nothinig is coming out.  Upon reading the documentation for using stderr, it mentions the need to change the system's syslog daemon.

It says it should look something like "local0.*    /var/log/postgresql"

I can't find this syslog configuration.  I have a file in /etc/syslog-ng called syslog-ng.conf which contains the following:

##########################################################################
# $Header: /var/cvsroot/gentoo-x86/app-admin/syslog-ng/files/syslog-ng.conf.gentoo,v 1.7 2007/08/02 04:52:18 mr_bones_ Exp $
#
# Syslog-ng default configuration file for Gentoo Linux
# contributed by Michael Sterrett

options {
        chain_hostnames(off);
        sync(0);

        # The default action of syslog-ng 1.6.0 is to log a STATS line
        # to the file every 10 minutes.  That's pretty ugly after a while.
        # Change it to every 12 hours so you get a nice daily update of
        # how many messages syslog-ng missed (0).
        stats(43200);
};

source src {
    unix-stream("/dev/log" max-connections(256));
    internal();
    file("/proc/kmsg");
};

destination messages { file("/var/log/messages"); };

# By default messages are logged to tty12...
destination console_all { file("/dev/tty12"); };
# ...if you intend to use /dev/console for programs like xconsole
# you can comment out the destination line above that references /dev/tty12
# and uncomment the line below.
#destination console_all { file("/dev/console"); };

log { source(src); destination(messages); };
log { source(src); destination(console_all); };
######################################################################

I can't see how I would change this as per the documentation's recommendations.  Am I looking at the right configuration file?

I'm using PostgreSQL 8.3.5 on an up-to-date Gentoo.  I had a look at this problem about 6 months ago and had the same problem, but now I want to get it working.

Thanks

Thom

pgsql-general by date:

Previous
From: "Daniel Verite"
Date:
Subject: Re: inconsistency in aliasing
Next
From: Richard Huxton
Date:
Subject: Re: Logging on Gentoo