Re: PgAgent does not works

>From: Dave Page <dpage@postgresql.org>
>To: Vishal Arora <aroravishal22@hotmail.com>
>Subject: Re: [pgadmin-support] PgAgent does not works
>Date: Mon, 25 Jun 2007 13:59:32 +0100
>
>Vishal Arora wrote:
>>
>>I have tried to install the dll using RegSvr32 - it says - "... 
>>pgaevent.dll was loaded, but the DllRegiseterServer entry point was not 
>>found" - The file can not be regisetered.
>>
>
>Sorry - my fault. That one is actually registered by pgAgent when it's 
>installed as a service - at least it should be. Assuming your pgAgent 
>service id is 'pgagent', you can manually install by creating the registry 
>key:
>
>HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\EventLog\Application\pgagent
>
>and then adding a string value called EventMessageFile, containing the full 
>path and filename of pgaevent.dll, and a dword value called TypesSupported 
>with a value of 7.
>
>Those entries should be created when you install pgagent as a service 
>though; and if it can't create them, you definitely should see an error.
>

These values are already in place.

>>>So you need to specify the password - see the bottom section of 
>>>http://www.pgadmin.org/docs/1.6/pgagent-install.html which discusses the 
>>>database password.
>>
>>I already have pgpass.conf file in place.
>
>For you, or the postgres user account that the service runs under? You need 
>the latter. Also, if you're using 127.0.0.1 as the address, try localhost 
>instead (or vice-versa). The value there should match the value used in the 
>pgAgent connection string of course.
>


I have tried using both of these values and also the hostname as well. But 
nothing worked.

>Regards, Dave.

_________________________________________________________________
Get a preview of Live Earth, the hottest event this summer - only on MSN 
http://liveearth.msn.com?source=msntaglineliveearthhm