SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
04-17-2008, 08:02 PM
| ||||
| ||||
 Re: PgAgent does not works >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\Servi ces\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      |
|
04-17-2008, 08:02 PM
| ||||
| ||||
| Re: PgAgent does not works >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\Serv ices\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 majordomo@postgresql.org so that your message can get through to the mailing list cleanly |
Linear Mode
