PgAgent daemon terminated itself when it was running a time-consuming job.

From: Eugene Wang <eugenewangfw(at)gmail(dot)com>
To: pgAdmin Support <pgadmin-support(at)postgresql(dot)org>
Subject: PgAgent daemon terminated itself when it was running a time-consuming job.
Date: 2018-09-06 16:19:29
Message-ID: CAEsxC1ZTPWOHy8Mda6m9nAHn3MUkK1Rf4mwusZtAuiiA1dnjvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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/

Browse pgadmin-support by date

  From Date Subject
Next Message jlvoo@postgres 2018-09-06 17:02:31 Re: pgAdmin Unable to connect to server via SSH Tunnel (nothing in logs)
Previous Message Adam Brusselback 2018-09-06 15:57:23 Re: Re: How to install pgAgent on windows for postresql-bigsql-10.5