[EMAIL PROTECTED] ("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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings