I'm not sure how it looks on your system, but on mine (FreeBSD 6.1,
PG 8.1 from ports), the default in postgresql.conf is to send
everything to a number of syslog facilities with the ident 'postgres'.
Anyway, I haven't messed with any of these settings, and I get
everything in messages, but you should be able to do this by adding a
line like this to syslog.conf:
I think that will send everything from postgre to that one file. As
for splitting it up into multiple files, you'd have to do stuff like
postgres.notice ... etc.
hope that helps,
On Jan 18, 2007, at 1:47 PM, Leticia Larrosa wrote:
> In my ubuntu server I have two places where are logged the messages
> from postgreSql. Some kind of messages are logged in /var/log/
> postgresql/postgresql-8.1-main.log and others messages are loggued
> in "/var/log/messages".
> I want send all my messages to an specific folder (/var/log/
> postgresql/) and none of them to "/var/log/messages"
> How can I do that?
> Thanks in advanced.
In response to
pgsql-novice by date
|Next:||From: John DeSoi||Date: 2007-01-19 13:23:58|
|Subject: Re: Select Into help|
|Previous:||From: Leticia Larrosa||Date: 2007-01-18 21:47:57|
|Subject: Send all postgres messages to a specific folder|