Re: Eventlog

Tom Lane wrote:

> 
> 
> Okay, that's CVS tip from my perspective too.  Anyone have comments
> about why the eventlog log is so noisy?  It's outside my competence...


This looks like an installation problem; I don't see that on my machine.

The eventlog will receive an eventID (postgresql uses only 0), which is 
an index into a message table provided by the service (it's a binary 
resource). If that message is not present, or if the message provider 
isn't registered for the server, the text mentioned is displayed.
For pgsql, this message is just "%s", to use it generically.

To check if the dll is registered correctly:

You should have

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Eventlog\Application\PostgreSQL] 
"EventMessageFile"="C:\\Program Files\\ PostgreSQL\\7.5\\lib\\pgevent.dll"

or another valid pgevent.dll path. Adding this might need a machine 
restart (yes, it's win...)

I noticed a trailing '.' on a single line in every eventlog entry, the 
attached patch will remove this.

Regards,
Andreas


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

Index: pgmsgevent.mc
===================================================================
RCS file: /projects/cvsroot/pgsql-server/src/bin/pgevent/pgmsgevent.mc,v
retrieving revision 1.1
diff -u -r1.1 pgmsgevent.mc
--- pgmsgevent.mc	20 Jun 2004 01:32:49 -0000	1.1
+++ pgmsgevent.mc	7 Aug 2004 08:44:06 -0000
@@ -1,5 +1,5 @@
 MessageId=0
 SymbolicName=PGWIN32_EVENTLOG_MSG
 Language=English
-%1.
+%1
 .