>From: "Vishal Arora" <aroravishal22(at)hotmail(dot)com>
>Subject: Re: [pgadmin-support] PgAgent does not works
>Date: Tue, 26 Jun 2007 04:17:45 +0000
>>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
>>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
>>>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
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.
>Get a preview of Live Earth, the hottest event this summer - only on MSN
>---------------------------(end of broadcast)---------------------------
>TIP 7: You can help support the PostgreSQL project by donating at
Hotmail to go? Get your Hotmail, news, sports and much more!
In response to
pgadmin-support by date
|Next:||From: Marcin Zajączkowski||Date: 2007-06-26 06:56:38|
|Subject: Mouse cursor doesn't change|
|Previous:||From: Vishal Arora||Date: 2007-06-26 04:17:45|
|Subject: Re: PgAgent does not works|