答复: [External] Re: pgadmin--pgagent---the process hang by unknow reasons

2020-11-26 Thread Zhiyu ZY13 Xu
Hi Dave Thanks for your quick response. This env was deploy on Jan 2019 by my team mate. Currently the pgagent have 30 jobs running. The version is pgagent_10-3.4.0 I don’t know how to upgrade the pgagent. I try to find upgrade document. But failed. Only find that edb ppas could upgrade pgag

Re: Export data from a query ran by pgagent

2020-11-26 Thread Gonzalo Rubio Casas
Hi Dave, Thanks for your quick response, I'm afraid dumping the query results into another table is not possible as the queried database is a read-only copy of our main database. I assume there's no way to schedule remote shell script executions with pgAgent right? I didn't find anything on the

Re: Export data from a query ran by pgagent

2020-11-26 Thread Dave Page
Hi On Thu, Nov 26, 2020 at 2:42 PM Gonzalo Rubio Casas < gonzalo.rubio.ca...@gmail.com> wrote: > Hi everyone, > > I hope someone has an idea because I have been stuck with this for a > couple of days. I'm using pgagent to allow some users of my database to > schedule period *remote* queries that

Export data from a query ran by pgagent

2020-11-26 Thread Gonzalo Rubio Casas
Hi everyone, I hope someone has an idea because I have been stuck with this for a couple of days. I'm using pgagent to allow some users of my database to schedule period *remote* queries that create some reports. However, I do not find anywhere on the manual or the mailing list how to retrieve th

Re: pgadmin--pgagent---the process hang by unknow reasons

2020-11-26 Thread Dave Page
Hi Given the libwx* references in your stacktrace, you appear to be using an old version of pgagent - we removed the dependency on wxWidgets nearly 2.5 years ago and replaced it with Boost. Please upgrade and try again. Thanks. On Thu, Nov 26, 2020 at 8:05 AM Zhiyu ZY13 Xu wrote: > Hi Support

pgadmin--pgagent---the process hang by unknow reasons

2020-11-26 Thread Zhiyu ZY13 Xu
Hi Support I using pgagent over 2 years. There are over 30 jobs running by pgagent. Recently. I found a problem that sometime the pgagent hang by unknow reasons. From the stack information. Look like the pagent experience dead-lock issue in code. The stack display many thread stop on