Re: 1) Error event produced during 8.0.3 shutdown. 2) Likely rong interruption time reported in log files (8.0.0 and 8.0.3).

[Knut P Lehre]

>> 1) During postgresql 8.0.3 shutdown (net stop postgresql)
>> Error events appear in WinXP Pro and Win Server 2003. I
>> didn't see this before upgrading to
>> 8.0.3 from 8.0.0.
>> Error Category: None, Event 0, User N/A.
>
>This is true for all postgresql events, as they are not categorised. You
>need to look at the text in the comment field of the event to get what
>actually happened.
>
>//Magnus

OK. Event description is:

"The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found.
The local computer may not have the necessary registry information or message
DLL files to display messages from a remote computer. You may be able to
use the /AUXSOURCE= flag to retrieve this description; see Help and Support
for details. The following information is part of the event: 2005-07-21
09:47:39  LOG:  logger shutting down."

So this does not indicate an error, just an ordinary shutdown? Isn't it
a bit misleading that the event is listed as an "Error"? There are also
"Warning" and "Information" event types.

(It looks like the second part of my post ("2) Likely wrong interruption
time reported in log files (8.0.0 and 8.0.3).") was split up into several
parts, and some of it is missing. I will therefore resubmit it in a separate
message.)

KP



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Magnus Hagander]

> >> 1) During postgresql 8.0.3 shutdown (net stop postgresql) Error
> >> events appear in WinXP Pro and Win Server 2003. I didn't see this
> >> before upgrading to
> >> 8.0.3 from 8.0.0.
> >> Error Category: None, Event 0, User N/A.
> >
> >This is true for all postgresql events, as they are not categorised.
> >You need to look at the text in the comment field of the
> event to get
> >what actually happened.
> >
> >//Magnus
>
> OK. Event description is:
>
> "The description for Event ID ( 0 ) in Source ( PostgreSQL )
> cannot be found.
> The local computer may not have the necessary registry
> information or message DLL files to display messages from a
> remote computer. You may be able to use the /AUXSOURCE= flag
> to retrieve this description; see Help and Support for
> details. The following information is part of the event: 2005-07-21
> 09:47:39  LOG:  logger shutting down."
>
> So this does not indicate an error, just an ordinary
> shutdown?

Yes.
Is this an installer-installed version? It looks like pgevent.dll is not
properly registered, which really should've been taken care of by thei
nstaller..


> Isn't it a bit misleading that the event is listed
> as an "Error"? There are also "Warning" and "Information" event types.

Yeah, that's not good :-(
From what I can tell, this is logged by the capture-output-to-stderr
code.

I've lost track of parts of the logger code, but this appears to be
because anything at all that is logged by the logger process itself will
go out as an error:

if ((!Redirect_stderr || am_syslogger) && pgwin32_is_service())
 ... write to eventlog ...


That code needs to be completed with eventlog-level-matching logic that
exists elsewhere. I'll take a look at doing this fairly soon.

//Magnus

>
> (It looks like the second part of my post ("2) Likely wrong
> interruption time reported in log files (8.0.0 and 8.0.3).")
> was split up into several parts, and some of it is missing. I
> will therefore resubmit it in a separate
> message.)
>
> KP
>
>
>

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org

[Knut P Lehre]

>OK. Event description is:
>>
>> "The description for Event ID ( 0 ) in Source ( PostgreSQL )
>> cannot be found.
>> The local computer may not have the necessary registry
>> information or message DLL files to display messages from a
>> remote computer. You may be able to use the /AUXSOURCE= flag
>> to retrieve this description; see Help and Support for
>> details. The following information is part of the event: 2005-07-21
>> 09:47:39  LOG:  logger shutting down."
>>
>> So this does not indicate an error, just an ordinary
>> shutdown?
>Yes.
>Is this an installer-installed version? It looks like pgevent.dll is not
>properly registered, which really should've been taken care of by the
>installer..

All files are from an installer-installed version, but pgsql was not installed
by the installer on this computer. It was only registered as a service by
pg_ctl.

>That code needs to be completed with eventlog-level-matching logic that
>exists elsewhere. I'll take a look at doing this fairly soon.

I guess this is only a minor cosmetic thing, as long as people know that
everything is OK.

Thanks.
KP



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

[Magnus Hagander]

> >OK. Event description is:
> >>
> >> "The description for Event ID ( 0 ) in Source ( PostgreSQL
> ) cannot
> >> be found.
> >> The local computer may not have the necessary registry
> information or
> >> message DLL files to display messages from a remote
> computer. You may
> >> be able to use the /AUXSOURCE= flag to retrieve this
> description; see
> >> Help and Support for details. The following information is part of
> >> the event: 2005-07-21
> >> 09:47:39  LOG:  logger shutting down."
> >>
> >> So this does not indicate an error, just an ordinary shutdown?
> >Yes.
> >Is this an installer-installed version? It looks like pgevent.dll is
> >not properly registered, which really should've been taken
> care of by
> >the installer..
>
> All files are from an installer-installed version, but pgsql
> was not installed by the installer on this computer. It was
> only registered as a service by pg_ctl.

Ok. That explains that part. If you run "regsvr32 pgevent.dll" (in the
dir where it is), you will get much nicer looking messages.


> >That code needs to be completed with eventlog-level-matching
> logic that
> >exists elsewhere. I'll take a look at doing this fairly soon.
>
> I guess this is only a minor cosmetic thing, as long as
> people know that everything is OK.

Yeah.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings