[GENERAL] syslog facilites and postgres ?

[Day, David]

Hi,

Should I be able to run two syslog facilities simultaneously ( postgres local0, 
and a  trigger function to  local3 ) successfully ?

I have postgresql 9.3.1exit running on freebsd and sending errors  to 
"syslog_facility= local0".
That works fine.

I have created an insert  trigger on one of my datatables using plperlu that 
opens syslog to facility local3 which directs
portions of that newly inserted record to local3. ( see below).  This works 
with the the following issue.

I find occasional notifications in my local3 log file that should I believe be 
in the local0 log file.  E.g. I will see some of
my RAISE LOG output in the local3 output log file rather than in the local0 
output log file.   I suspect this is happening
during the window in which local3 is open and closed in the trigger function.   
I note that the errant notification I find in local3 is not also found
in local0.


Any suggestions on this concept ?


Thanks


Dave Day


CREATE OR REPLACE FUNCTION log.connection_history_post_insert()
  RETURNS trigger AS
$BODY$
  use Sys::Syslog;
  openlog('smdr', 'ndelay,pid', 'local3');
  my $tmp = $_TD->{new} {orig_addr} .'->' . $_TD->{new} {term_addr} . '~' . 
$_TD->{new} {answer_datetime}
  syslog ("info", "data %s ", $tmp);
  closelog();
  return;
$BODY$
  LANGUAGE plperlu VOLATILE