On 11/5/20 1:07 PM, Gabi Draghici wrote:
Hi,
I have installed postgresql 12 on sles 15 for some tests. Now I'm
interested in some sort of scheduler and from what I've read so far,
pgagent should do the job. So I've installed pgagent 4.0. I've added a
job (which I can see in pgagent.pga_job) but everytime I ran it (from
pgadmin) nothing happens ! When I start the pgagent I can see "...
pgagent ... connection authorized" in the main log. What else should I
check ?
pg_cron:
https://www.citusdata.com/blog/2020/10/31/evolving-pg-cron-together/
For pgagent what is the job doing and when? Could it be it hasn't run
because it has not reached it's scheduled time.
Thanks,
Gabi
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
