ailto:pgadmin-support@lists.postgresql.org>
Subject: Re: pgAgent Jobs on replica
Hi
On Sat, Apr 24, 2021 at 6:47 PM Greg Bryant
mailto:gregabry...@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’ connectio
t;
>
> *From: *Dave Page
> *Sent: *Monday, April 26, 2021 4:08 AM
> *To: *Greg Bryant
> *Cc: *pgadmin-support@lists.postgresql.org
> *Subject: *Re: pgAgent Jobs on replica
>
>
> Hi
>
> On Sat, Apr 24, 2021 at 6:47 PM Greg Bryant
> wrote:
>
>> I have several pgAge
Hi
On Sat, Apr 24, 2021 at 6:47 PM Greg Bryant 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.
>
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