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

2020-11-30 Thread Dave Page
Hi On Thu, Nov 26, 2020 at 4:45 PM Zhiyu ZY13 Xu wrote: > 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 f

Re: Export data from a query ran by pgagent

2020-11-30 Thread Dave Page
On Thu, Nov 26, 2020 at 3:46 PM Gonzalo Rubio Casas < gonzalo.rubio.ca...@gmail.com> wrote: > 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 th