Le vendredi 17 avril 2009 à 09:26:41, Jaume Sabater a écrit : > On Fri, Apr 17, 2009 at 3:00 AM, Sergio Chavarria > > <[email protected]> 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 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
