Hi, Can you please share the pgAgent logs in debug mode ? If possible, also share the job details or screenshots so that we can reproduce at our end.
Thanks, Neel Patel On Thu, Sep 6, 2018 at 11:30 PM, Eugene Wang <eugenewan...@gmail.com> wrote: > My environment is Ubuntu 16.04 LTS, Postgres 9.6.8 with PgAgent 4.0 > installed and setup successfully. > > I tried to use a PgAgent Job to pull data from a MySQL table using FDW on > a routine basis in order to keep a updated copy of the mysql table. This > job has two steps. When I run those steps directly, the first one would > take less than 30 mins and the second one usually takes 44 minutes. > However, when I try to run it with PgAgent, my logs showed me that only the > first step was finished, and PgAgent daemon was terminated during this job > and it would never execute the second step. > > Is there a solution on this issue? If it is beyond the capability of > PgAgent, what solution would help me? the system cron? I really like the > feature of PgAgent that steps could be executed one by one if the previous > is done, so I would hope I could just set up some configuration and get > this fixed. > > Thank you. > > > Yujie Wang (Welcome to call me Eugene, for your pronunciation > convenience) > GIS Developer > Connected2fiber > Linkedin : https://www.linkedin.com/in/yujie-wang-61a129a0/ >
