Re: automatic verifications

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Melanie Bergeron <mbergeron_pg(at)globeecom(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: automatic verifications
Date: 2003-12-18 22:19:16
Message-ID: 87n09pixaz.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Melanie Bergeron <mbergeron_pg(at)globeecom(dot)com> writes:

> Hi!
>
> I am new with PostgreSQL and I want to know if this database give the
> possibility to verify automatically, each night, if some records are
> too old (by example, if session_date is older than a month) and if so
> delete them.

That's not really something you would build into a server. I'd do it
by writing a maintenance script and having it run by 'cron'. The
script would just do a "DELETE FROM sessions WHERE session_date < ..."

-Doug

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2003-12-18 22:37:24 Re: automatic verifications
Previous Message Rick Gigger 2003-12-18 22:16:34 Re: Firebird and PostgreSQL at the DB Corral.