From: | Neal Clark <nclark(at)securescience(dot)net> |
---|---|
To: | Leticia Larrosa <leticia(at)tesla(dot)cujae(dot)edu(dot)cu> |
Cc: | <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Send all postgres messages to a specific folder |
Date: | 2007-01-18 22:43:37 |
Message-ID: | C92DA960-998F-4E4A-A9AD-8170509FD2B7@securescience.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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:
postgres.* /var/log/postgresql
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.error /var/log/postgresql/errors
postgres.fatal /var/log/postgresql/fatal
postgres.notice ... etc.
hope that helps,
Neal
On Jan 18, 2007, at 1:47 PM, Leticia Larrosa wrote:
> Hi
>
> 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.
> </L>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | John DeSoi | 2007-01-19 13:23:58 | Re: Select Into help |
Previous Message | Leticia Larrosa | 2007-01-18 21:47:57 | Send all postgres messages to a specific folder |