[Babase] Log access
Karl O. Pinc
babase@www.eco.princeton.edu
Wed, 13 Oct 2004 13:05:47 -0500
I've tried setting syslog_faclity in the babase_test
database and don't have permissions. (now is LOCAL4.)
\u babase_test
select * from pg_settings where name = 'syslog_facility';
alter database babase_test set syslog_facility='LOCAL5';
You might be able to do it as superuser, or maybe this
is something that's not per-database.
There's also the question of logging application events,
and accessing these logs.
Which is tied to system events as I want a log of
system events too. @hen there's a bug in a trigger
and something does not run I want to know. These
events are sent to the front end but I want a
permanent record and not have to rely on the users
to inform me of odd events.
If nothing else we can put a filter in syslog.conf
that looks for "babase" in the message and sends
those elsewhere.
Does this sound reasonable?
Any thoughts?
Karl <kop@meme.com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein