Postgres Pro
Downloads
Home   >   mailing lists

Re: pgAgent Jobs on replica - Mailing list pgadmin-support

From Dave Page
Subject Re: pgAgent Jobs on replica
Date
Msg-id CA+OCxoyihrG5TiucHCnOR-0zWCn-G+AUbB5aRLBVRzUCRjnauQ@mail.gmail.com
Whole thread Raw
In response to pgAgent Jobs on replica  (Greg Bryant <gregabryant@hotmail.com>)
Responses RE: pgAgent Jobs on replica  (Greg Bryant <gregabryant@hotmail.com>)
List pgadmin-support
Tree view
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 by date:

Previous
From: Fahar Abbas
Date:
Subject: Re: The pgAdmin 4 server could not be contacted:
Next
From: Greg Bryant
Date:
Subject: RE: pgAgent Jobs on replica