Central management for regular tasks on multiple databases

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

Browse pgsql-general by date

  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