From: | Sandeep Saxena <sandeep(dot)lko(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pgAgent for multiple databases in same instance |
Date: | 2021-03-10 18:56:57 |
Message-ID: | CAA3fARGLBVwNHRG6H=jiXb_fwHk3KtFvbhpCKPMyarJ-zHKZ2w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi,
We are using EDB postgres 12 ,and using pgAgent to schedule db jobs , now
we have two databases in the instance but job run only on one of the
databases.
I created a pgAgent extension on both db's , I can submit a job on both
db's too , just it doesnt run on one db until i change dbname in
edb-pgagent.conf.
I tried giving dbname as * but then it stopped working on both the
databases.
I check pgagent.pga_joblog to see if job is running or not , so it gives me
clear idea of jobs running.
We are using EDB EPAS 12.
Do we need multiple instances of pgAgent daemon for multiple db as we tried
running a separate instance of pgAgen by passing 2nd db credentials and
then jobs were running on both db so is that the way to go ?
Regards,
Sandeep
From | Date | Subject | |
---|---|---|---|
Next Message | David Gauthier | 2021-03-10 19:41:59 | How to get CASE statement to recognize null ? |
Previous Message | Ron | 2021-03-10 18:03:36 | Re: Logical Replication, CPU load and Locking contention |