Ignore my previous mail..
(After Discussion with Dave Page, I found that)
We can have multiple pgAgent Daemon running for the same database too.
Each pgagent daemon lock the job, before running it. So that, it will not run multiple times by different pgagent daemons.
If you specify the "Host Agent" for the job, that particular job will run only on that host only.
--
Ashesh Vashi
On Tue, Jan 12, 2010 at 11:04 AM, Ashesh Vashi
<ashesh.vashi@enterprisedb.com> wrote:
That's right..On Tue, Jan 12, 2010 at 8:31 AM, Sebastian P. Luque
<spluque@gmail.com> wrote:
Thanks for the pointer.
If I understand well, there can only be one pgagent daemon per database?
--