Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <vindex+lists-pgsql-sql@apartia.org>)
	id 1Ta8Oq-00054c-Js
	for pgsql-sql@postgresql.org; Sun, 18 Nov 2012 17:11:16 +0000
Received: from marius.cruisefish.net ([178.63.80.84])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <vindex+lists-pgsql-sql@apartia.org>)
	id 1Ta8Op-0006rP-8h
	for pgsql-sql@postgresql.org; Sun, 18 Nov 2012 17:11:16 +0000
Received: by marius.cruisefish.net (Postfix, from userid 1000)
	id 880E381345B30; Sun, 18 Nov 2012 18:11:13 +0100 (CET)
Date: Sun, 18 Nov 2012 18:11:13 +0100
From: Louis-David Mitterrand <vindex+lists-pgsql-sql@apartia.org>
To: pgsql-sql@postgresql.org
Subject: Re: organizing cron jobs in one function
Message-ID: <20121118171111.GA2945@apartia.fr>
Mail-Followup-To: pgsql-sql@postgresql.org
References: <20121117161916.GA9492@apartia.fr>
	<50A8C63A.5070801@2ndQuadrant.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <50A8C63A.5070801@2ndQuadrant.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201211/16
X-Sequence-Number: 36949

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?