Re: Schedule DB Query

Le vendredi 17 avril 2009 à 09:26:41, Jaume Sabater a écrit :
> On Fri, Apr 17, 2009 at 3:00 AM, Sergio Chavarria
>
>  wrote:
> > Hi, i hope someone can help me in this mailing list. Is there a way to
> > schedule databases querys with postgresql?? Ideally i would like to have
> > a database table with one field containing database queries and then
> > create a "postgres cron"  for executing all my queries at a specified
> > time.
> >
> > I know one possible solution would be to create a cron in unix but i
> > think it would be better if i can create it within the database so, if i
> > change my system, i can keep this information just doing a "pgdump" and
> > restoring  in another system.
>
> I would go for a cron job that calls a script that launches a number
> of SQL commands through psql -c or pgsql -f.
>

You can also use pgagent to ease the creation of batch jobs (SQL or shell 
script). See http://www.pgadmin.org/docs/dev/pgagent.html for more 
information.


-- 
Guillaume.
 http://www.postgresqlfr.org
 http://dalibo.com