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