| From: | Greg Bryant <gregabryant(at)hotmail(dot)com> |
|---|---|
| To: | "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org> |
| Subject: | pgAgent Jobs on replica |
| Date: | 2021-04-23 21:48:40 |
| Message-ID: | SJ0PR05MB72472A1660C81FF0E604C4E6AB459@SJ0PR05MB7247.namprd05.prod.outlook.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgadmin-support |
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.
Thanks,
Greg
Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Idowu Odujobi | 2021-04-25 16:33:23 | The pgAdmin 4 server could not be contacted: |
| Previous Message | Julien de Murcia | 2021-04-23 12:20:19 | Re: Error while starting PgAdmin 5.0 |