Re: Scheduling/Automated Jobs in Postgre

adamodharan(at)ivesia(dot)com ("Aravindhan G.D") wrote:
> I need to do some user defined jobs when ever the Postgre server
> gets restarted. These tasks should be automated one i.e) When ever I
> restart the server the PL/SQL functions I have defined should be
> executed automatically without my intervention. This is to record
> some information like Audit Trails and some more.

You could add this into whatever script starts up pg_ctl, but only if
you decide to use PostgreSQL rather than "Postgre".

> Could any one tell me how can I implement this in Postgre. Is there
> any concept like "Scheduled Jobs" in Postgre. If so pls. provide me
> with related informations or the links from where I could get them.

There surely is. Use cron(8). But that's only true with PostgreSQL,
not with "Postgre".

This mailing list addresses PostgreSQL, not Postgre.
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://linuxdatabases.info/info/slony.html
Some people are only alive because it is illegal to kill.