Logging on Gentoo

From: "Thom Brown" <thombrown(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Logging on Gentoo
Date: 2009-01-14 12:09:46
Message-ID: bddc86150901140409u8461e11x152e742d3fb2ee32@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2009-01-14 12:26:05 Re: Logging on Gentoo
Previous Message Daniel Verite 2009-01-14 12:07:51 Re: inconsistency in aliasing