I have a normal problem to anyone that can't trust on applications to do their 'work/ AKA be online' and needs a DB Stored Procedure to run every minute .
- PostgreSQL 9.2
- Need To Run A SP To 'Compile' Information That has been inserted into the database.
No I Can't trust the App to be online and call this on the client side.
Job(s) must execute every minute.
Unfortunately I can't use trigger based or any 'EventBased' Model since I don't know when all the data has arrived.
The cluster is made of headless machines.
I could install CRON on every server but that could cause unnecessary chatter inside the Cluster , DeadLocks , Calls at 3 AM , Pain , etc
Problem 1: Now my problem is PGAgent requires ( As far as I know) a GUI , X and so on things I would like to avoid specially for 'just' running jobs.
Problem 2: Also what if the server that runs the Agent ( call it Master ) dies the cluster will self heal but will the agent survive?
So how do you do it?