From: | Christopher Browne <cbbrowne(at)cbbrowne(dot)com> |
---|---|
To: | Zlatko Michailov <zmichailov(at)yahoo(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Scheduled jobs |
Date: | 2003-05-12 22:38:14 |
Message-ID: | 20030512223814.5D54286F@cbbrowne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Zlatko Wrote:
> I didn't find any documentation mentioning scheduled jobs. I assume
> there is no such a feature yet. I would like to implement it if
> someone helps me with the development process (I am brand new to
> OpenSource projects).
> Basically the feature should include scheduling function exeution at:
> - postmaster startup
> - postmaster shutdown
> - a specified moment
> - a time of the day/month/year
> - recurring at a time interval
Have you ever considered using cron?
- It is available on every Unix.
- It may readily be compiled for Cygwin.
It seems preposterous to imagine that reimplementing the functionality
of cron would significantly add to the functionality of PostgreSQL.
If you really want a unified way of accessing crontabs, then feel free
to write some plpgsql functions that are "wrappers" for cron...
--
(concatenate 'string "aa454" "@freenet.carleton.ca")
http://www.ntlug.org/~cbbrowne/unix.html
FLORIDA: Relax, Retire, Re Vote.
From | Date | Subject | |
---|---|---|---|
Next Message | Nigel J. Andrews | 2003-05-12 22:38:59 | Re: Scheduled jobs |
Previous Message | Tom Lane | 2003-05-12 22:27:26 | Re: Scheduled jobs |