Skip site navigation (1) Skip section navigation (2)

Re: BUG #6459: logging_collector=off but log_filename set inhibits logoutpu

From: calestyo(at)scientia(dot)net
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6459: logging_collector=off but log_filename set inhibitslogoutpu
Date: 2012-02-14 21:09:24
Message-ID: E1RxPcq-0002Fi-HQ@wrigleys.postgresql.org (view raw)
The following bug has been logged on the website:

Bug reference:      6459
Logged by:          Christoph Anton Mitterer
Email address:      calestyo(at)scientia(dot)net
PostgreSQL version: 9.1.1
Operating system:   All
Description:        

Hi.

http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
claims that log_filename is only used when logging_collector is enabled.

However it seems that if the later is off, but the former is set (to
anything), no log output goes to stderr as well.

Cheers,
Chris.


From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: calestyo(at)scientia(dot)net
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6459: logging_collector=off but log_filename set inhibits logoutpu
Date: 2012-02-14 23:45:29
Message-ID: 11968.1329263129@sss.pgh.pa.us (view raw)
calestyo(at)scientia(dot)net writes:
> http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
> claims that log_filename is only used when logging_collector is enabled.

That is a true statement, as can easily be proven by looking at the
source code: nothing except syslogger.c pays any attention to the
Log_filename variable.

> However it seems that if the later is off, but the former is set (to
> anything), no log output goes to stderr as well.

That would depend on other settings that you haven't mentioned,
particularly log_destination.  Keep in mind also that the active setting
of logging_collector can't be changed without a postmaster restart
(which is why it's a separate variable from log_destination).

			regards, tom lane

From: Christoph Anton Mitterer <calestyo(at)scientia(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6459: logging_collector=off but log_filename set inhibits logoutpu
Date: 2012-02-20 02:59:53
Message-ID: 1329706793.6199.79.camel@fermat.scientia.net (view raw)
Hi.

On Tue, 2012-02-14 at 18:45 -0500, Tom Lane wrote:
> calestyo(at)scientia(dot)net writes:
> > http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
> > claims that log_filename is only used when logging_collector is enabled.
> 
> That is a true statement, as can easily be proven by looking at the
> source code: nothing except syslogger.c pays any attention to the
> Log_filename variable.
Well nevertheless,... if set, I get no stderr output at all (which
Debian uses per default as log source).


> > However it seems that if the later is off, but the former is set (to
> > anything), no log output goes to stderr as well.
> 
> That would depend on other settings that you haven't mentioned,
> particularly log_destination.  Keep in mind also that the active setting
> of logging_collector can't be changed without a postmaster restart
> (which is why it's a separate variable from log_destination).

log_destination is commented, thus default stderr should apply.
And of course I've restarted.


Cheers,
Chris.

btw: I'll be on vacation till 1st of March, so don't expect any soon
answers.
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Christoph Anton Mitterer <calestyo(at)scientia(dot)net>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6459: logging_collector=off but log_filename set inhibits logoutpu
Date: 2012-02-20 05:26:37
Message-ID: 22832.1329715597@sss.pgh.pa.us (view raw)
Christoph Anton Mitterer <calestyo(at)scientia(dot)net> writes:
> On Tue, 2012-02-14 at 18:45 -0500, Tom Lane wrote:
>> calestyo(at)scientia(dot)net writes:
>>> http://www.postgresql.org/docs/9.1/static/runtime-config-logging.html
>>> claims that log_filename is only used when logging_collector is enabled.

>> That is a true statement, as can easily be proven by looking at the
>> source code: nothing except syslogger.c pays any attention to the
>> Log_filename variable.

> Well nevertheless,... if set, I get no stderr output at all (which
> Debian uses per default as log source).

I wonder whether Debian's startup script is doing something that affects
this?  Because it's pretty hard to explain otherwise.

			regards, tom lane

From: Christoph Anton Mitterer <calestyo(at)scientia(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6459: logging_collector=off but log_filename set inhibits logoutpu
Date: 2012-02-20 16:31:01
Message-ID: 1329755461.3383.55.camel@fermat.scientia.net (view raw)
On Mon, 2012-02-20 at 00:26 -0500, Tom Lane wrote:
> I wonder whether Debian's startup script is doing something that affects
> this?  Because it's pretty hard to explain otherwise.

You're probably right and I've reported this there:
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=660649

:)

Cheers,
Chris.

Privacy Policy | About PostgreSQL
Copyright © 1996-2013 The PostgreSQL Global Development Group