Re: pgAgent Jobs on replica
| От | Dave Page |
|---|---|
| Тема | Re: pgAgent Jobs on replica |
| Дата | |
| Msg-id | CA+OCxoyihrG5TiucHCnOR-0zWCn-G+AUbB5aRLBVRzUCRjnauQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | pgAgent Jobs on replica (Greg Bryant <gregabryant@hotmail.com>) |
| Ответы |
RE: pgAgent Jobs on replica
|
| Список | pgadmin-support |
Hi
On Sat, Apr 24, 2021 at 6:47 PM Greg Bryant <gregabryant@hotmail.com> wrote:
I have several pgAgent jobs that run on the ‘master’ database. They fail on the replica since it’s a ‘read-only’ connection. I’m creating a couple jobs to run some bash scripts but I don’t want them to run on the replica server.
Is there a way to prevent pgAgent jobs from executing on the replica server? Wrap all the jobs in an ‘if’ statement to check if the server is in_recovery? Disable the daemon on the replica server?
I’m currently running PostgreSQL 11 with pgAgent 4.
You can use the Host Agent field to specify a particular node that a job should run on - see https://www.pgadmin.org/docs/pgadmin4/5.2/pgagent_jobs.html
В списке pgadmin-support по дате отправления: