Re: postgresql as windows 2000 service problem

To solve the problem of event id not found, you have to register a event for
PostgreSQL.
This work is done by pgevent.dll you will found in lib directory.

In practice,
Open a "Dos" shell
Go to lib directory (C:\msys\1.0\local\pgsql\lib for example)
enter the command: regsvr32 pgevent.dll

The error message will disappear. You need admin privilege to register the
DLL.

The regsvr32 /u pgevent.dll command will unregister the DLL and delete key
and data insert in registry database.
It works on NT4 too.



----- Original Message ----- 
From: <[email protected]>
To: <[email protected]>
Sent: Thursday, July 15, 2004 11:12 AM
Subject: [pgsql-hackers-win32] postgresql as windows 2000 service problem


>
> Ok the exact message in event log is (I will try
> to translate from greece to english assuming
> you dont know to read greek :))
>
> "It is not possible to find the description for the
> event id ( 0 ) to source (PostgreSQL) . The local computer
> may not have the necesary registry informations or
> the DLL message files for the display of messages from a
> remote compu Unable to find exe."
>
> My path is
>
>
C:\Inprise\vbroker\bin;C:\PROGRA~1\Borland\CBUILD~1\Bin;C:\PROGRA~1\Borland\
CBUILD~1\Projects\Bpl;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System
32\Wbem;C:\POSTGRES\BIN;C:\POSTGRES\LIB
>
> I set the path as follows:
> right click to my computer (as administrator)
> select properties
> going to the "for advanced" tab
> going to environment variables
> goind to second window titled "system variables"
> findind from the list variable PATH
> double click it
> and add bin and lib folders
>
> The same steps I have done for windows xp
>
> user postrges has full control over c:\postgres, subfolders and files...
>
> I also downloaded the source snapshot from 14/7/2004 compiled
> and installed. Exactly the same things. Initdb run fine
> but service gives me the same error message.
>
> I also have to say that I started with a fresh installation
> of windows 2000 (format and install). After I only applied the
> patches from microsoft.
>


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match