Le vendredi 17 avril 2009 à 09:26:41, Jaume Sabater a écrit : > On Fri, Apr 17, 2009 at 3:00 AM, Sergio Chavarria > > <sergio.chavarria@xxxxxxxxx> 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 (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
