RE: pgAgent Jobs on replica

2021-04-26 Thread Greg Bryant
Thanks for the reply. I saw that as an option but I don’t really want to have to go modify every pgAgent job after a switch-over to the replica (not that I have that many jobs or that PostgreSQL hardly ever fails). I’m more concerned that another administrator doesn’t know that all the jobs

Re: pgAgent Jobs on replica

2021-04-26 Thread Dave Page
Hi On Mon, Apr 26, 2021 at 3:44 PM Greg Bryant wrote: > Thanks for the reply. > > > > I saw that as an option but I don’t really want to have to go modify every > pgAgent job after a switch-over to the replica (not that I have that many > jobs or that PostgreSQL hardly ever fails). I’m more

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. >