Re: How to run a task continuously in the background - Mailing list pgsql-general
You could perhaps tweak the code for pg_cron or pg_agent for a custom solution that supports a finer time resolution?
On Friday, July 12, 2019, 5:06:42 PM GMT+12, Dirk Mika <Dirk.Mika@mikatiming.de> wrote:
A cron job will only run once a minute, not wake up every second.
Right, that’s an issue.
But you could write a PHP program that does a one-second sleep before checking if there's something to do, and a batch job that runs periodically to see if the PHP program is running, and if not, launch it.
I would like to avoid external programs if possible. In the current Oracle environment, there are potentially multiple schemas on a server in which processing can be active. And processing can be started, monitored and stopped from a client application. And only for the schema with which the application is connected.
BR
Dirk
| -- Dirk Mika Software Developer |
|
fon +49 2202 2401-1197 |
| AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884 Geschäftsführer: Harald Mika, Jörg Mika |
|
Attachment
pgsql-general by date: