Re: Logging - Mailing list pgsql-admin

From Lamar Owen
Subject Re: Logging
Date
Msg-id 3A198235.AE3DF04E@wgcr.org
Whole thread Raw
In response to Logging  ("Anders R. Sveen" <anderssv@stud.ntnu.no>)
Responses Postgres 7 pgdump problems
List pgsql-admin
"Anders R. Sveen" wrote:
> I've set my pg_options file to write log messages, but it only logs to
> /var/log/messages instead of /var/log/postgresql wich remains empty.

> Why is that and how can i change it? Maybe it's a sylog question, but
> beeing new to it and all i can't really figure things out.

You need to edit /etc/syslog.conf to direct the output of PostgreSQL to
the file you wish to hold the log.  The facility used by default in
7.0.3 is local0, so a line:
local0.*                /var/log/postgresql
will do what you expect.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

pgsql-admin by date:

Previous
From: "Anders R. Sveen"
Date:
Subject: Logging
Next
From: "Rainer Mager"
Date:
Subject: Postgres 7 pgdump problems