Re: PgAgent does not works

["Vishal Arora" <aroravishal22(at)hotmail(dot)com>]

> 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