Thread: using syslog to capture RAISE notices

using syslog to capture RAISE notices

From

"Dan Langille"

Date:

11 March 2002, 16:54:02

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

Re: using syslog to capture RAISE notices

From

Bruce Momjian

Date:

11 March 2002, 18:49:06

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

Re: using syslog to capture RAISE notices

From

"Dan Langille"

Date:

11 March 2002, 19:11:27

I compiled with the default FreeBSD install:

CONFIGURE_ARGS= --enable-locale --enable-syslog --with-CXX \
                --docdir=${PREFIX}/share/doc --with-
libdir=${LOCALBASE}/lib \
                --with-includes=${LOCALBASE}/include

What's this Use_syslog?  Is that a user configurable item?
I am seeing nothing in syslog.  The raise is working:

test=# CREATE FUNCTION test() returns int8 AS '
test'#     BEGIN
test'# raise DEBUG \'this is dan raising a notice\';
test'#         RETURN 1;
test'#     END
test'# ' LANGUAGE 'plpgsql';
CREATE
test=# select test();
 test
------
    1
(1 row)

test=#

On 11 Mar 2002 at 15:46, Bruce Momjian wrote:

>
> 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
>


--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples

Re: using syslog to capture RAISE notices

From

Bruce Momjian

Date:

11 March 2002, 19:33:57

Yes, use postgresql.conf:

    #syslog = 0                     # range 0-2
    #syslog_facility = 'LOCAL0'
    #syslog_ident = 'postgres'

Set syslog to 1 or 2.  Remove # comment character.

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

Dan Langille wrote:
> I compiled with the default FreeBSD install:
>
> CONFIGURE_ARGS= --enable-locale --enable-syslog --with-CXX \
>                 --docdir=${PREFIX}/share/doc --with-
> libdir=${LOCALBASE}/lib \
>                 --with-includes=${LOCALBASE}/include
>
> What's this Use_syslog?  Is that a user configurable item?
> I am seeing nothing in syslog.  The raise is working:
>
> test=# CREATE FUNCTION test() returns int8 AS '
> test'#     BEGIN
> test'# raise DEBUG \'this is dan raising a notice\';
> test'#         RETURN 1;
> test'#     END
> test'# ' LANGUAGE 'plpgsql';
> CREATE
> test=# select test();
>  test
> ------
>     1
> (1 row)
>
> test=#
>
> On 11 Mar 2002 at 15:46, Bruce Momjian wrote:
>
> >
> > 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
> >
>
>
> --
> Dan Langille
> The FreeBSD Diary - http://freebsddiary.org/ - practical examples
>
>

--
  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

Re: using syslog to capture RAISE notices

From

"Dan Langille"

Date:

11 March 2002, 20:08:25

That was it.  Thank you.

syslog = 2 # range 0-2

For those using FreeBSD, the configuration file is:
/usr/local/pgsql/data/postgresql.conf

and HUP the running postmaster after your change.

Thanks Bruce.

On 11 Mar 2002 at 16:33, Bruce Momjian wrote:

>
> Yes, use postgresql.conf:
>
>  #syslog = 0                     # range 0-2
>  #syslog_facility = 'LOCAL0'
>  #syslog_ident = 'postgres'
>
> Set syslog to 1 or 2.  Remove # comment character.
>
> ---------------------------------------------------------------------------
>
> Dan Langille wrote:
> > I compiled with the default FreeBSD install:
> >
> > CONFIGURE_ARGS= --enable-locale --enable-syslog --with-CXX \
> >                 --docdir=${PREFIX}/share/doc --with-
> > libdir=${LOCALBASE}/lib \
> >                 --with-includes=${LOCALBASE}/include
> >
> > What's this Use_syslog?  Is that a user configurable item?
> > I am seeing nothing in syslog.  The raise is working:
> >
> > test=# CREATE FUNCTION test() returns int8 AS '
> > test'#     BEGIN
> > test'# raise DEBUG \'this is dan raising a notice\';
> > test'#         RETURN 1;
> > test'#     END
> > test'# ' LANGUAGE 'plpgsql';
> > CREATE
> > test=# select test();
> >  test
> > ------
> >     1
> > (1 row)
> >
> > test=#
> >
> > On 11 Mar 2002 at 15:46, Bruce Momjian wrote:
> >
> > >
> > > 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