running maintenance tasks on DB - Mailing list pgsql-general

From Louis-David Mitterrand
Subject running maintenance tasks on DB
Date
Msg-id 20000923172647.A10488@styx
Whole thread Raw
Responses Re: running maintenance tasks on DB
List pgsql-general
Hello,

Approaching completion of an online auction system based on Postgres and
mod_perl/Apache I yet have to devise a good way of running certain
maintenance tasks on the DB like closing auctions, notifying winners,
transferring old records to archive tables, etc.

What is the usual way of programming such tasks? Write a backend
function (in pl/sql or C) and call it from a cron job? From a mod_perl
handler?

Thanks in advance for any insight, cheers,

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.org

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] how to store a query, that results in a table
Next
From: Neil Conway
Date:
Subject: Re: running maintenance tasks on DB