Thread: 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%\System32\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.

> My path is
>
>
C:\Inprise\vbroker\bin;C:\PROGRA~1\Borland\CBUILD~1\Bin;C:\PROGRA~1\Borl
an
>
d\CBUILD~1\Projects\Bpl;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\
Sy
> stem32\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

Can you log in as the postgres user and check the same thing?  Check the
user path and make sure it's got %path% in it so it stacks with the
system path.

Or,
Use the runas command from the command window to open up a command shell
under the postgres user context.  In that window, try to invoke pg_ctl
to check the path (or example path).

Merlin

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: <kranas@freemail.gr>
To: <pgsql-hackers-win32@postgresql.org>
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.
>