Re: BUG #6011: Some extra messages are output in the event log at PostgreSQL startup

From: "MauMau" <maumau307(at)gmail(dot)com>
To: "Magnus Hagander" <magnus(at)hagander(dot)net>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #6011: Some extra messages are output in the event log at PostgreSQL startup
Date: 2011-05-07 00:35:05
Message-ID: 659BD8622BB84D8684AEB57A1F8AA0C4@maumau
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Magnus Hagander <magnus(at)hagander(dot)net> writes:
>> Any events that happen before we have opened the regular logfile will
>> be written to the eventlog if the server is running as a Windows
>> service. There is no way to turn that off (other than removing the
>> code and recompiling, of course). If we didn't send those to the
>> eventlog, they would be completely lost since there is no stderr
>> available to a windows service.
>

From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> These particular messages appear to be coming from pg_ctl, not from the
> server at all, so the server logging configuration is irrelevant anyway.
>
> What I think *is* relevant is pg_ctl's -s (--silent) switch, which is
> defined as "only print errors, no informational messages". I would
> expect that to silence "waiting for ..." messages, and indeed it appears
> to do so in all the cases on the Unix side of the fence. However,
> someone chose to code these Windows-specific messages as direct
> write_eventlog calls instead of going through print_msg, which means
> that -s doesn't silence them. So possibly the OP is right that this is
> a bug and not just an unimplemented feature.

I think that those two messages in question are not very helpful, so I hope
those are omitted by default (i.e. even without pg_ctl's -s). If they are
useful and should be logged in the event log, why aren't they logged in
syslog on UNIX/Linux?

So, I wish that the direct calls to write_eventlog will be eliminated. If
those messages are useful for some reason, it may be okay that pg_ctl's -s
hides them at worst. However, it's better to remove the write_eventlog calls
in question, because those software dependent on PostgreSQL have to be
modified to add -s.

Can I expect this will be treated as a bug and fixed in 8.3.x too? BTW, how
can I check the bug treatment? I saw somewhere that you don't like issue
trackers such as JIRA or Bugzilla.

Regards,
MauMau

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Denilson Costa 2011-05-07 03:10:51 BUG #6013: PostgreSql Lento
Previous Message Kevin Grittner 2011-05-06 19:08:14 Re: BUG #6012: Automatically generated sequence number jumps.