On 5/4/2017 2:50 PM, John R Pierce wrote:
>> But there's an extension - pg_cron:
>> https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/
>>
>
>
> there's also pg_agent which is a cron-like extension, usually bundled
> with pg_admin but also available standalone
>
> https://www.pgadmin.org/docs4/dev/pgagent.html
oh, it should be made clear... both of these extensions require an OS
level cron/scheduler job to be run every minute or whatever, this job
invokes some SQL stuff which checks the pg_cron or pg_agent tables and
runs whatever sql tasks are due.
--
john r pierce, recycling bits in santa cruz