On Thu, Sep 23, 2010 at 16:20, Martin A. Brooks <martin@xxxxxxxxxxxxxx> wrote: > 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. You can use pgAgent for this. It ships with pgAdmin3 (and as a separate download) and can do all this. -- Magnus Hagander Me: http://www.hagander.net/ Work: http://www.redpill-linpro.com/ -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
