pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSyslog
9+ messages / 6 participants
[nested] [flat]
* Syslog
@ 2002-03-14 17:40 Jie Liang <jie@stbernard.com>
2002-03-14 18:48 ` Re: Syslog Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 9+ messages in thread
From: Jie Liang @ 2002-03-14 17:40 UTC (permalink / raw)
To: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Syslog
2002-03-14 17:40 Syslog Jie Liang <jie@stbernard.com>
@ 2002-03-14 18:48 ` Joe Conway <mail@joeconway.com>
2002-03-14 19:06 ` Re: [SQL] Syslog Dan Langille <dan@langille.org>
0 siblings, 1 reply; 9+ messages in thread
From: Joe Conway @ 2002-03-14 18:48 UTC (permalink / raw)
To: Jie Liang <jie@stbernard.com>; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] Syslog
2002-03-14 17:40 Syslog Jie Liang <jie@stbernard.com>
2002-03-14 18:48 ` Re: Syslog Joe Conway <mail@joeconway.com>
@ 2002-03-14 19:06 ` Dan Langille <dan@langille.org>
0 siblings, 0 replies; 9+ messages in thread
From: Dan Langille @ 2002-03-14 19:06 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Syslog
@ 2002-03-14 18:55 Jie Liang <jie@stbernard.com>
2002-03-14 19:27 ` Re: Syslog Joe Conway <mail@joeconway.com>
0 siblings, 1 reply; 9+ messages in thread
From: Jie Liang @ 2002-03-14 18:55 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; Jie Liang <jie@stbernard.com>; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Syslog
2002-03-14 18:55 Re: Syslog Jie Liang <jie@stbernard.com>
@ 2002-03-14 19:27 ` Joe Conway <mail@joeconway.com>
0 siblings, 0 replies; 9+ messages in thread
From: Joe Conway @ 2002-03-14 19:27 UTC (permalink / raw)
To: Jie Liang <jie@stbernard.com>; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Syslog
@ 2002-03-14 20:13 Jie Liang <jie@stbernard.com>
2002-03-14 21:17 ` Re: [SQL] Syslog Oliver Elphick <olly@lfix.co.uk>
0 siblings, 1 reply; 9+ messages in thread
From: Jie Liang @ 2002-03-14 20:13 UTC (permalink / raw)
To: Joe Conway <mail@joeconway.com>; Jie Liang <jie@stbernard.com>; +Cc: 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] Syslog
2002-03-14 20:13 Re: Syslog Jie Liang <jie@stbernard.com>
@ 2002-03-14 21:17 ` Oliver Elphick <olly@lfix.co.uk>
2002-03-14 23:35 ` Re: [SQL] Syslog Larry Rosenman <ler@lerctr.org>
0 siblings, 1 reply; 9+ messages in thread
From: Oliver Elphick @ 2002-03-14 21:17 UTC (permalink / raw)
To: Jie Liang <jie@stbernard.com>; +Cc: Joe Conway <mail@joeconway.com>; 'pgsql-admin@postgresql.org' <pgsql-admin@postgresql.org>; pgsql-sql
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] Syslog
2002-03-14 20:13 Re: Syslog Jie Liang <jie@stbernard.com>
2002-03-14 21:17 ` Re: [SQL] Syslog Oliver Elphick <olly@lfix.co.uk>
@ 2002-03-14 23:35 ` Larry Rosenman <ler@lerctr.org>
2002-03-15 00:03 ` Re: [SQL] Syslog Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 9+ messages in thread
From: Larry Rosenman @ 2002-03-14 23:35 UTC (permalink / raw)
To: Oliver Elphick <olly@lfix.co.uk>; +Cc: jie@stbernard.com; mail@joeconway.com; pgsql-admin@postgresql.org; pgsql-sql; pgsql-hackers@postgresql.org
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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [SQL] Syslog
2002-03-14 20:13 Re: Syslog Jie Liang <jie@stbernard.com>
2002-03-14 21:17 ` Re: [SQL] Syslog Oliver Elphick <olly@lfix.co.uk>
2002-03-14 23:35 ` Re: [SQL] Syslog Larry Rosenman <ler@lerctr.org>
@ 2002-03-15 00:03 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 9+ messages in thread
From: Tom Lane @ 2002-03-15 00:03 UTC (permalink / raw)
To: Larry Rosenman <ler@lerctr.org>; +Cc: Oliver Elphick <olly@lfix.co.uk>; jie@stbernard.com; mail@joeconway.com; pgsql-admin@postgresql.org; pgsql-sql; pgsql-hackers@postgresql.org
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
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2002-03-15 00:03 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-03-14 17:40 Syslog Jie Liang <jie@stbernard.com>
2002-03-14 18:48 ` Joe Conway <mail@joeconway.com>
2002-03-14 19:06 ` Dan Langille <dan@langille.org>
2002-03-14 18:55 Re: Syslog Jie Liang <jie@stbernard.com>
2002-03-14 19:27 ` Joe Conway <mail@joeconway.com>
2002-03-14 20:13 Re: Syslog Jie Liang <jie@stbernard.com>
2002-03-14 21:17 ` Oliver Elphick <olly@lfix.co.uk>
2002-03-14 23:35 ` Larry Rosenman <ler@lerctr.org>
2002-03-15 00:03 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox