Re: organizing cron jobs in one function

From: Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: organizing cron jobs in one function
Date: 2012-11-18 17:11:13
Message-ID: 20121118171111.GA2945@apartia.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sun, Nov 18, 2012 at 07:27:54PM +0800, Craig Ringer wrote:
> On 11/18/2012 12:19 AM, Louis-David Mitterrand wrote:
> > Hi,
> >
> > I'm planning to centralize all db maintenance jobs from a single
> > pl/pgsql function called by cron every 15 minutes (highest frequency
> > required by a list of jobs).
> It sounds like you're effectively duplicating PgAgent.
>
> Why not use PgAgent instead?

Sure, I didn't know about PgAgent.

Is it still a good solution if I'm not running PgAdmin and have no plan
doing so?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Craig Ringer 2012-11-19 00:31:10 Re: organizing cron jobs in one function
Previous Message Craig Ringer 2012-11-18 11:27:54 Re: organizing cron jobs in one function