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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
