Re: using syslog to capture RAISE notices

Strange. I see this in 7.2 elog.c:

    #ifdef ENABLE_SYSLOG
        /* Write to syslog, if enabled */
        if (Use_syslog >= 1)
        {
            int         syslog_level;

            switch (lev)
            {
                case DEBUG:
                    syslog_level = LOG_DEBUG;
                    break;
                case NOTICE:
                    syslog_level

I assume you compiled with syslog enabled by configure?  Are you seeing
anything in syslog or are you just lacking the plpgsql RAISE?


---------------------------------------------------------------------------

Dan Langille wrote:
> Can syslog be configured to capture RAISE messages?
>
> Reading http://www.postgresql.org/idocs/index.php?plpgsql-
> description.html#PLPGSQL-DESCRIPTION-ABORTING-AND-MESSAGES, I know how to
> raise an exception, notice, or debug message.  But I've been unable to get
> those messages logged via syslog.
>
> I have this in syslog.conf:
>
> *.debug;*.notice;kern.debug;lpr.info;mail.crit;news.err /var/log/messages
>
> Here is the test routine I've used:
>
>   DROP FUNCTION test();
> CREATE FUNCTION test() returns int8 AS '
>     BEGIN
>     raise DEBUG \'this is dan raising a notice\';
>         RETURN 1;
>     END
> ' LANGUAGE 'plpgsql';
>
> And the test:
>
> fp2rifixed=# select test();
>  test
> ------
>     1
> (1 row)
>
> But nothing appears in /var/log/messages (yes, syslogd was HUP'd).
>
> FWIW, this is PostgreSQL 7.2 under FreeBSD 4.5.
> --
> Dan Langille
> The FreeBSD Diary - http://freebsddiary.org/ - practical examples
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026