From: "Vishal Arora" <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
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 <[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.
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
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
