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