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 E52A454C94 for ; Wed, 2 Mar 2005 20:40:52 +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 88751-09 for ; Wed, 2 Mar 2005 20:40:43 +0000 (GMT) Received: from flake.decibel.org (unknown [67.100.216.10]) by svr1.postgresql.org (Postfix) with ESMTP id 5B311560ED for ; Wed, 2 Mar 2005 20:40:42 +0000 (GMT) Received: by flake.decibel.org (Postfix, from userid 1001) id E9C7A1C91F; Wed, 2 Mar 2005 14:40:43 -0600 (CST) Date: Wed, 2 Mar 2005 14:40:43 -0600 From: "Jim C. Nasby" To: "Aravindhan G.D" Cc: pgsql-admin@postgresql.org Subject: Re: Scheduling/Automated Jobs in Postgre Message-ID: <20050302204043.GA2209@decibel.org> References: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> X-Operating-System: FreeBSD 4.10-RELEASE-p3 i386 X-Distributed: Join the Effort! http://www.distributed.net User-Agent: Mutt/1.5.6i X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.145 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/33 X-Sequence-Number: 16531 This is something that comes up every few months. Core is of the opinion that you should just use the tools of your OS. Personally, I think some kind of job system in the database would be very useful, so the last time this came up I created http://pgfoundry.org/projects/pgjob/. No work is being done on it right now, but if this is something you have an interest in you should sign up for the mailing list. On Wed, Mar 02, 2005 at 10:09:53AM +0530, Aravindhan G.D wrote: > Hi All, > > 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. > > 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. > > With Regards, > Aravindhan. -- Jim C. Nasby, Database Consultant decibel@decibel.org Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?"