running maintenance tasks on DB

From: Louis-David Mitterrand <cunctator(at)apartia(dot)ch>
To: pgsql-general(at)postgresql(dot)org
Subject: running maintenance tasks on DB
Date: 2000-09-23 15:26:47
Message-ID: 20000923172647.A10488@styx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)apartia(dot)org - http://www.apartia.org

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2000-09-23 15:34:12 Re: Postgresql limits
Previous Message Paul Wehr 2000-09-23 14:08:35 Re: [SQL] how to store a query, that results in a table