Thread: Syslog
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
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
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
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
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
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
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
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
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