Re: organizing cron jobs in one function - Mailing list pgsql-sql

From Louis-David Mitterrand
Subject Re: organizing cron jobs in one function
Date
Msg-id 20121118171111.GA2945@apartia.fr
Whole thread Raw
In response to Re: organizing cron jobs in one function  (Craig Ringer <craig@2ndQuadrant.com>)
Responses Re: organizing cron jobs in one function  (Craig Ringer <craig@2ndQuadrant.com>)
List 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?



pgsql-sql by date:

Previous
From: Craig Ringer
Date:
Subject: Re: organizing cron jobs in one function
Next
From: Craig Ringer
Date:
Subject: Re: organizing cron jobs in one function