Feature request: pgcron

From: "Martin A(dot) Brooks" <martin(at)antibodymx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Feature request: pgcron
Date: 2010-09-23 14:20:19
Message-ID: 584ff0a51339aa1efc4f483a3b1beffa.squirrel@olga.hinterlands.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I did not see this feature on the TODO page on the wiki. I apologise if I
have overlooked something similar.

I would like postgres to have a cron-like feature for scheduling things to
happen at particular times.

An example of this might be routinely purging data from tables, or
vacuuming specific tables.

I realise that these can easily be done via cron itself, but I feel an
internal implementation would be useful because:

* The tasks would live with the database itself and become part of the
schema and so are not "forgotten" if the database is moved across clusters
or hosts.
* Windows doesn't have cron, it uses its own system. This would provide a
consistent way of running tasks regardless of platform.

I hope this makes sense.

Regards

Martin A. Brooks
http://antibodymx.net/

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2010-09-23 14:54:17 Re: Feature request: pgcron
Previous Message Scott Ribe 2010-09-23 13:59:53 Re: What was new in 8.4 & 8.3?