Re: pgAgent for multiple databases in same instance

2021-03-11 Thread Sandeep Saxena
Hi Adam , Thank you for the such a good explaination , actually in same instance dba's are looking to create multiple QA databases and we had jobs in oracle for archiving and some business functionality so I created pgagent extension in multiple databases ,in our application end users can submit j

Re: pgAgent for multiple databases in same instance

2021-03-10 Thread Adam Brusselback
So my experience isn't with pgagent directly, because I have been using my re-written version of it for ~5 years (but at least at one point I had a pretty darn good understanding from doing that rewrite)...please take this with a grain of salt if I am incorrect on anything. So the agent is only ab

pgAgent for multiple databases in same instance

2021-03-10 Thread Sandeep Saxena
Hi, We are using EDB postgres 12 ,and using pgAgent to schedule db jobs , now we have two databases in the instance but job run only on one of the databases. I created a pgAgent extension on both db's , I can submit a job on both db's too , just it doesnt run on one db until i change dbname in edb