RE: pgAgent Jobs on replica

2021-04-26 Thread Greg Bryant
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

Re: pgAgent Jobs on replica

2021-04-26 Thread Dave Page
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

Re: pgAgent Jobs on replica

2021-04-26 Thread Dave Page
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. >

pgAgent Jobs on replica

2021-04-24 Thread Greg Bryant
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