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
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 |