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 E6AB5569DF for ; Thu, 17 Mar 2005 05:41:12 +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 88643-06 for ; Thu, 17 Mar 2005 05:41:10 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 46CCD569CF for ; Thu, 17 Mar 2005 05:41:09 +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 j2H5f8Fs090622 for ; Thu, 17 Mar 2005 05:41:09 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id j2H5Mi5G086119 for pgsql-admin@postgresql.org; Thu, 17 Mar 2005 05:22:44 GMT (envelope-from news) From: Christopher Browne X-Newsgroups: pgsql.admin Subject: Re: Scheduling/Automated Jobs in Postgre Date: 17 Mar 2005 05:22:43 GMT Organization: cbbrowne Computing Inc Lines: 15 Message-ID: <39sih3F66n1imU4@individual.net> References: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> X-Draft-From: ("nntp+wolfe:pgsql.admin" 912) 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= In-Reply-To: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> (Aravindhan G. D.'s message of "Wed, 2 Mar 2005 10:09:53 +0530") To: pgsql-admin@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/253 X-Sequence-Number: 16751 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.