syslog support by default

Started by Tatsuo Ishiiover 23 years ago14 messages
#1Tatsuo Ishii
t-ishii@sra.co.jp

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tatsuo Ishii (#1)
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.

regards, tom lane

#3Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Tom Lane (#2)
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

#4Peter Eisentraut
peter_e@gmx.net
In reply to: Tom Lane (#2)
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

#5Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Peter Eisentraut (#4)
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

#6Mario Weilguni
mweilguni@sime.com
In reply to: Peter Eisentraut (#4)
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

#7Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Tatsuo Ishii (#5)
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

#8Hannu Krosing
hannu@tm.ee
In reply to: Peter Eisentraut (#4)
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

#9Hannu Krosing
hannu@tm.ee
In reply to: Tatsuo Ishii (#5)
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

#10Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tatsuo Ishii (#7)
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

#11Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Tom Lane (#10)
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

#12Tom Lane
tgl@sss.pgh.pa.us
In reply to: Tatsuo Ishii (#11)
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

#13Bruce Momjian
pgman@candle.pha.pa.us
In reply to: Tatsuo Ishii (#11)
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
#14Tatsuo Ishii
t-ishii@sra.co.jp
In reply to: Tom Lane (#12)
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