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
>
> <sergio(dot)chavarria(at)gmail(dot)com> 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