pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Jim C. Nasby <decibel@decibel.org>
To: Aravindhan G.D <adamodharan@ivesia.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Scheduling/Automated Jobs in Postgre
Date: Wed, 2 Mar 2005 14:40:43 -0600
Message-ID: <20050302204043.GA2209@decibel.org> (raw)
In-Reply-To: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52>
References: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52>

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?"



view thread (5+ messages)  latest in thread

Message-ID: <20050302204043.GA2209@decibel.org>
Permalink:  ../20050302204043.GA2209@decibel.org/
Also on:    postgresql.org/message-id/20050302204043.GA2209@decibel.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: decibel@decibel.org, adamodharan@ivesia.com
  Subject: Re: Scheduling/Automated Jobs in Postgre
  In-Reply-To: <20050302204043.GA2209@decibel.org>
  References: <002801c51ee1$e2c95f50$8b02a8c0@ivesia52> <20050302204043.GA2209@decibel.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox