From: | Jiří Hlinka <jiri(dot)hlinka(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Cc: | Jiří Hlinka <jiri(dot)hlinka(at)gmail(dot)com> |
Subject: | Central management for regular tasks on multiple databases |
Date: | 2015-01-07 08:41:04 |
Message-ID: | CADCCO5qajoDOt7wa1u6tEDU3qnpu=cD+y8w5dx4V7XtfWNvrwg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi list,
I'd like to ask you if you have any experience with some solution or how do
you manage tasks described below.
We have tens of separate databases (for different apps and purpose) which
we want send regular tasks to. The tasks are always SQL queries, for
example count some bilance after midnight on part of the databases, delete
unneeded items ad so on.
Is there any solution which would behave somethin like central cron for
databases? It should be able to manage these tasks:
- ideally with web UI + auth
- setup which databases would be queried by the task
- setup in which time period the task (query) will be run
How do you manage these kind of tasks?
Thanks for tips.
Best Regards,
Jiri
From | Date | Subject | |
---|---|---|---|
Next Message | Pawel Veselov | 2015-01-07 09:49:15 | Re: Improving performance of merging data between tables |
Previous Message | Beena Emerson | 2015-01-07 03:54:16 | Inconsistent bgworker behaviour |