Re: PgAgent does not works - Mailing list pgadmin-support

>From: "Vishal Arora" <aroravishal22@hotmail.com>
>To: dpage@postgresql.org
>CC: pgadmin-support@postgresql.org
>Subject: Re: [pgadmin-support] PgAgent does not works
>Date: Tue, 26 Jun 2007 04:17:45 +0000
>
>
>
>
>>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.

Thanks for all your time and support. I have managed to run the pgAgent 
working fine. The service was running under postgres account but pgpass.conf 
file was missing in the same. I created one and it worked.

Thanks for your suggestions.

- Vishal

>
>>Regards, Dave.
>
>_________________________________________________________________
>Get a preview of Live Earth, the hottest event this summer - only on MSN 
>http://liveearth.msn.com?source=msntaglineliveearthhm
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: You can help support the PostgreSQL project by donating at
>
>                http://www.postgresql.org/about/donate

_________________________________________________________________
Hotmail to go? Get your Hotmail, news, sports and much more! 
http://mobile.msn.com