From: | Jaume Sabater <jsabater(at)gmail(dot)com> |
---|---|
To: | Sergio Chavarria <sergio(dot)chavarria(at)gmail(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Schedule DB Query |
Date: | 2009-04-17 07:26:41 |
Message-ID: | 3786f7bb0904170026u55a5a1d8xcd6ea541eb693b91@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
--
Jaume Sabater
http://linuxsilo.net/
"Ubi sapientas ibi libertas"
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2009-04-17 07:56:14 | Re: Schedule DB Query |
Previous Message | Sergio Chavarria | 2009-04-17 01:00:34 | Schedule DB Query |