From: Dave Page <[EMAIL PROTECTED]>
To: Vishal Arora <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
