On 5/4/2017 2:08 PM, Sven R. Kunze wrote:
> After searching the web, it seems to me that PostgreSQL doesn't offer
> a cron-like background job for cleanup tasks.
>
> http://stackoverflow.com/questions/18187490/postgresql-delete-old-rows-on-a-rolling-basis
>
>
>
> 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
--
john r pierce, recycling bits in santa cruz