Thread: Syslog

Syslog

From
Jie Liang
Date:
In postgresql.conf:
#  Syslog
# requires ENABLE_SYSLOG
How to do it?
My OS is FreeBSD4.5
I installed Postgres-7.2


Urgent!!!!!!!!!


Thanks!




Jie Liang

Re: Syslog

From
Joe Conway
Date:
Jie Liang wrote:
> In postgresql.conf:
> #  Syslog
> # requires ENABLE_SYSLOG
> How to do it?
> My OS is FreeBSD4.5
> I installed Postgres-7.2
>
>
> Urgent!!!!!!!!!
>

I think you need to make sure that PostgreSQL was built with
--enable-syslog during configure.

Joe




Re: Syslog

From
Jie Liang
Date:
I did, it didn't work.

Jie Liang

-----Original Message-----
From: Joe Conway [mailto:mail@joeconway.com]
Sent: Thursday, March 14, 2002 10:49 AM
To: Jie Liang
Cc: 'pgsql-admin@postgresql.org'; pgsql-sql
Subject: Re: [ADMIN] Syslog


Jie Liang wrote:
> In postgresql.conf:
> #  Syslog
> # requires ENABLE_SYSLOG
> How to do it?
> My OS is FreeBSD4.5
> I installed Postgres-7.2
>
>
> Urgent!!!!!!!!!
>

I think you need to make sure that PostgreSQL was built with
--enable-syslog during configure.

Joe



Re: [SQL] Syslog

From
"Dan Langille"
Date:
On 14 Mar 2002 at 10:48, Joe Conway wrote:

> Jie Liang wrote:
> > In postgresql.conf:
> > #  Syslog
> > # requires ENABLE_SYSLOG
> > How to do it?
> > My OS is FreeBSD4.5
> > I installed Postgres-7.2
> >
> >
> > Urgent!!!!!!!!!

Try not to think that your message is more important than any other.  It's
not like we go through the messages and answer the "urgent" ones first.

> I think you need to make sure that PostgreSQL was built with
> --enable-syslog during configure.

You also need to ensure logging is enabled in postgre[sql].conf.  I know
only because I asked the same question a few days ago:

http://www2.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-
config.html
--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples


Re: Syslog

From
Joe Conway
Date:
Jie Liang wrote:
> I did, it didn't work.
>
> Jie Liang

Works for me. Did you change postgresql.conf? Here's what mine looks like.

#
#       Syslog
#
# requires ENABLE_SYSLOG
syslog = 1                      # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

 From the online docs:
SYSLOG (integer)

     PostgreSQL allows the use of syslog for logging. If this option is
set to 1, messages go both to syslog and the standard output. A setting
of 2 sends output only to syslog. (Some messages will still go to the
standard output/error.) The default is 0, which means syslog is off.
This option must be set at server start.

     To use syslog, the build of PostgreSQL must be configured with the
--enable-syslog option.


See:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.html

Joe



Re: Syslog

From
Jie Liang
Date:
I did everything as you did, however, when start the postmaster,
I got following:
FATAL 1:    'syslog' is not a valid option name.

Jie

-----Original Message-----
From: Joe Conway [mailto:mail@joeconway.com]
Sent: Thursday, March 14, 2002 11:27 AM
To: Jie Liang
Cc: 'pgsql-admin@postgresql.org'; pgsql-sql
Subject: Re: [ADMIN] Syslog


Jie Liang wrote:
> I did, it didn't work.
>
> Jie Liang

Works for me. Did you change postgresql.conf? Here's what mine looks like.

#
#       Syslog
#
# requires ENABLE_SYSLOG
syslog = 1                      # range 0-2
syslog_facility = 'LOCAL0'
syslog_ident = 'postgres'

 From the online docs:
SYSLOG (integer)

     PostgreSQL allows the use of syslog for logging. If this option is
set to 1, messages go both to syslog and the standard output. A setting
of 2 sends output only to syslog. (Some messages will still go to the
standard output/error.) The default is 0, which means syslog is off.
This option must be set at server start.

     To use syslog, the build of PostgreSQL must be configured with the
--enable-syslog option.


See:
http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/runtime-config.h
tml

Joe


Re: [SQL] Syslog

From
Oliver Elphick
Date:
On Thu, 2002-03-14 at 20:13, Jie Liang wrote:
> I did everything as you did, however, when start the postmaster,
> I got following:
> FATAL 1:    'syslog' is not a valid option name.

Then you haven't configured postgresql with --enable-syslog.  (That
message comes from src/backend/utils/misc/guc.c, if you want
confirmation.)

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C

     "Let your light so shine before men, that they may see
      your good works, and glorify your Father which is in
      heaven."         Matthew 5:16


Re: [SQL] Syslog

From
Larry Rosenman
Date:
On 14 Mar 2002 21:17:05 +0000
"Oliver Elphick" <olly@lfix.co.uk> wrote:

> On Thu, 2002-03-14 at 20:13, Jie Liang wrote:
> > I did everything as you did, however, when start the postmaster,
> > I got following:
> > FATAL 1:    'syslog' is not a valid option name.
>
> Then you haven't configured postgresql with --enable-syslog.  (That
> message comes from src/backend/utils/misc/guc.c, if you want
> confirmation.)
Hackers: Is there any reason to NOT make --enable-syslog the default
any more?

I.E. can we change the sense of it to be --disable-syslog and have
USE_SYSLOG defined by default?


>
> --
> Oliver Elphick                                Oliver.Elphick@lfix.co.uk
> Isle of Wight                              http://www.lfix.co.uk/oliver
> GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
>
>      "Let your light so shine before men, that they may see
>       your good works, and glorify your Father which is in
>       heaven."         Matthew 5:16
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>


--
Larry Rosenman                     http://www.lerctr.org/~ler
Phone: +1 972-414-9812                 E-Mail: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

Re: [SQL] Syslog

From
Tom Lane
Date:
Larry Rosenman <ler@lerctr.org> writes:
> Hackers: Is there any reason to NOT make --enable-syslog the default
> any more?
> I.E. can we change the sense of it to be --disable-syslog and have
> USE_SYSLOG defined by default?

I thought we'd agreed to do that already; at least Peter had indicated
he planned to do it.  I guess he didn't get around to it for 7.2.

            regards, tom lane