Re: PgAgent does not works

>From: Dave Page <dpage(at)postgresql(dot)org>
>To: Vishal Arora <aroravishal22(at)hotmail(dot)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