[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