Can we enable syslog support by default for 7.3?
--
Tatsuo Ishii

Fri, 19 Apr 2002 11:34:19 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
syslog support by default
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> Can we enable syslog support by default for 7.3?

AFAIR, we agreed to flip the default some time ago, we just didn't
want to do it late in the 7.2 cycle.  Go for it.

			regards, tom lane

Thu, 18 Apr 2002 22:53:38 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: syslog support by default 
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > Can we enable syslog support by default for 7.3?
> 
> AFAIR, we agreed to flip the default some time ago, we just didn't
> want to do it late in the 7.2 cycle.  Go for it.

Ok. I'll work on this.
--
Tatsuo Ishii

Fri, 19 Apr 2002 11:55:16 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: syslog support by default 
Tom Lane writes:

> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > Can we enable syslog support by default for 7.3?
>
> AFAIR, we agreed to flip the default some time ago, we just didn't
> want to do it late in the 7.2 cycle.  Go for it.

I think if no one complains about the lack of syslog on his machine we
should just remove the option in 7.3+1.

-- 
Peter Eisentraut   peter_e@gmx.net


Thu, 18 Apr 2002 23:28:48 -0400 (EDT)
Peter Eisentraut <peter_e@gmx.net>
Re: syslog support by default 
> > > > Can we enable syslog support by default for 7.3?
> > >
> > > AFAIR, we agreed to flip the default some time ago, we just didn't
> > > want to do it late in the 7.2 cycle.  Go for it.
> > 
> > I think if no one complains about the lack of syslog on his machine we
> > should just remove the option in 7.3+1.
> 
> My experience has been that logging to syslog makes postgres much
> slower.

What's the problem with this? Even if that's true, you could easily
turn off syslog logging by tweaking postgresql.conf.
--
Tatsuo Ishii


Fri, 19 Apr 2002 15:15:49 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: syslog support by default
> My experience has been that logging to syslog makes postgres much
> slower.
>
> Can anyone confirm or refute this ?
Do you use synchronous write with syslog? Try to add a dash in 
/etc/syslog.conf

e.g.
instead of 
local3.*                                         /var/log/syslog.postgres
use
local3.*                                         -/var/log/syslog.postgres



Fri, 19 Apr 2002 08:20:19 +0200
Mario Weilguni <mweilguni@sime.com>
Re: syslog support by default
> On Fri, 2002-04-19 at 08:15, Tatsuo Ishii wrote:
> > > > > > Can we enable syslog support by default for 7.3?
> > > > >
> > > > > AFAIR, we agreed to flip the default some time ago, we just didn't
> > > > > want to do it late in the 7.2 cycle.  Go for it.
> > > > 
> > > > I think if no one complains about the lack of syslog on his machine we
> > > > should just remove the option in 7.3+1.
> > > 
> > > My experience has been that logging to syslog makes postgres much
> > > slower.
> > 
> > What's the problem with this? Even if that's true, you could easily
> > turn off syslog logging by tweaking postgresql.conf.
> 
> I was worried about the comment of removing the other options. in 7.3+1.
> At least this is how i interpreted that comment.

In my understanding we are going to turn on the --enable-syslog
*configure* option by default (or remove the configuration option
completely), but not change the syslog option in postgresql.conf
(currently default to 0: that means not output to syslog).
--
Tatsuo Ishii


Fri, 19 Apr 2002 16:03:53 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: syslog support by default
On Fri, 2002-04-19 at 05:28, Peter Eisentraut wrote:
> Tom Lane writes:
> 
> > Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > > Can we enable syslog support by default for 7.3?
> >
> > AFAIR, we agreed to flip the default some time ago, we just didn't
> > want to do it late in the 7.2 cycle.  Go for it.
> 
> I think if no one complains about the lack of syslog on his machine we
> should just remove the option in 7.3+1.

My experience has been that logging to syslog makes postgres much
slower.

Can anyone confirm or refute this ?

--------------
Hannu



19 Apr 2002 09:08:18 +0200
Hannu Krosing <hannu@tm.ee>
Re: syslog support by default
On Fri, 2002-04-19 at 08:15, Tatsuo Ishii wrote:
> > > > > Can we enable syslog support by default for 7.3?
> > > >
> > > > AFAIR, we agreed to flip the default some time ago, we just didn't
> > > > want to do it late in the 7.2 cycle.  Go for it.
> > > 
> > > I think if no one complains about the lack of syslog on his machine we
> > > should just remove the option in 7.3+1.
> > 
> > My experience has been that logging to syslog makes postgres much
> > slower.
> 
> What's the problem with this? Even if that's true, you could easily
> turn off syslog logging by tweaking postgresql.conf.

I was worried about the comment of removing the other options. in 7.3+1.
At least this is how i interpreted that comment.

-------------
Hannu



19 Apr 2002 09:21:16 +0200
Hannu Krosing <hannu@tm.ee>
Re: syslog support by default
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> In my understanding we are going to turn on the --enable-syslog
> *configure* option by default (or remove the configuration option
> completely), but not change the syslog option in postgresql.conf
> (currently default to 0: that means not output to syslog).

Right.  We are only going to make the syslog support code be there
in the default build; we are not forcing anyone to use it.

			regards, tom lane

Fri, 19 Apr 2002 09:48:48 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: syslog support by default 
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > In my understanding we are going to turn on the --enable-syslog
> > *configure* option by default (or remove the configuration option
> > completely), but not change the syslog option in postgresql.conf
> > (currently default to 0: that means not output to syslog).
> 
> Right.  We are only going to make the syslog support code be there
> in the default build; we are not forcing anyone to use it.

I have removed the --enable-syslog option. Now as far as the system
has syslog(), the syslog support code is always in the build.
If this seems ok, I will update the doc.
--
Tatsuo Ishii

Sun, 21 Apr 2002 09:22:23 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: syslog support by default 
Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> I have removed the --enable-syslog option. Now as far as the system
> has syslog(), the syslog support code is always in the build.
> If this seems ok, I will update the doc.

Seems reasonable.  It might be a good idea for configure to verify
that the <syslog.h> header is present, as well as the syslog() library
routine, before enabling HAVE_SYSLOG.

			regards, tom lane

Sat, 20 Apr 2002 20:35:03 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: syslog support by default 
Tatsuo Ishii wrote:
> > Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > > In my understanding we are going to turn on the --enable-syslog
> > > *configure* option by default (or remove the configuration option
> > > completely), but not change the syslog option in postgresql.conf
> > > (currently default to 0: that means not output to syslog).
> > 
> > Right.  We are only going to make the syslog support code be there
> > in the default build; we are not forcing anyone to use it.
> 
> I have removed the --enable-syslog option. Now as far as the system
> has syslog(), the syslog support code is always in the build.
> If this seems ok, I will update the doc.

TODO updated:

	* -Compile in syslog functionaility by default (Tatsuo)

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

Tue, 23 Apr 2002 12:59:16 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: syslog support by default
> Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> > I have removed the --enable-syslog option. Now as far as the system
> > has syslog(), the syslog support code is always in the build.
> > If this seems ok, I will update the doc.
> 
> Seems reasonable.  It might be a good idea for configure to verify
> that the <syslog.h> header is present, as well as the syslog() library
> routine, before enabling HAVE_SYSLOG.

Done.
--
Tatsuo Ishii

Fri, 26 Apr 2002 22:56:21 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: syslog support by default 