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 EEECE563DF for ; Wed, 2 Mar 2005 08:09:01 +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 67609-01 for ; Wed, 2 Mar 2005 08:08:53 +0000 (GMT) Received: from tigger.fuhr.org (tigger.fuhr.org [63.214.45.158]) by svr1.postgresql.org (Postfix) with ESMTP id EF2B0563D5 for ; Wed, 2 Mar 2005 08:08:52 +0000 (GMT) Received: from winnie.fuhr.org (winnie.fuhr.org [10.1.0.1]) by tigger.fuhr.org (8.13.3/8.13.3) with ESMTP id j2288m5X002152 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=OK); Wed, 2 Mar 2005 01:08:51 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: from winnie.fuhr.org (localhost [127.0.0.1]) by winnie.fuhr.org (8.13.3/8.13.3) with ESMTP id j2288mHn047921; Wed, 2 Mar 2005 01:08:48 -0700 (MST) (envelope-from mfuhr@winnie.fuhr.org) Received: (from mfuhr@localhost) by winnie.fuhr.org (8.13.3/8.13.3/Submit) id j2288mrB047920; Wed, 2 Mar 2005 01:08:48 -0700 (MST) (envelope-from mfuhr) Date: Wed, 2 Mar 2005 01:08:48 -0700 From: Michael Fuhr To: "Aravindhan G.D" Cc: pgsql-admin@postgresql.org Subject: Re: Scheduling/Automated Jobs in Postgre Message-ID: <20050302080847.GA47871@winnie.fuhr.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-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.003 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/21 X-Sequence-Number: 16519 On Wed, Mar 02, 2005 at 10:09:53AM +0530, 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 an appropriate command to your PostgreSQL startup script. > 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. PostgreSQL doesn't have a scheduler -- most operating systems have one (e.g., cron on Unix-like systems), so that's what people use. (BTW, it's "PostgreSQL" or "Postgres", not "Postgre".) -- Michael Fuhr http://www.fuhr.org/~mfuhr/