X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CADCA52A5D for ; Wed, 2 Mar 2005 14:08:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 69960-08 for ; Wed, 2 Mar 2005 14:07:54 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 0DC345662E for ; Wed, 2 Mar 2005 14:07:54 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id j22E7s7E071897 for ; Wed, 2 Mar 2005 14:07:54 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j22Do1sD066424 for pgsql-admin@postgresql.org; Wed, 2 Mar 2005 13:50:01 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Scheduling/Automated Jobs in Postgre Date: Wed, 02 Mar 2005 08:23:01 -0500 Organization: cbbrowne Computing Inc Lines: 22 Message-ID: References: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@news.hub.org X-message-flag: Outlook is rather hackable, isn't it? X-Home-Page: http://www.cbbrowne.com/info/ X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4 (Jumbo Shrimp, linux) Cancel-Lock: sha1:bSAnsyvzHgdleayHyK6pGrjVzFU= To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/26 X-Sequence-Number: 16524 adamodharan@ivesia.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.