Answer the question
In order to leave comments, you need to log in
Does PostgreSQL 11 have a task scheduler out of the box?
Hello comrades! Please help me figure it out.
I am using a PostgreSQL 11 database . In it I created a stored procedure.
My next question. Is it possible by means of the database itself to run this very procedure with a certain frequency. If I'm not mistaken, earlier (in version 9.6) there was no such possibility out of the box. We used the CRON task scheduler on the operating system side, or third-party pg_cron extensions. I don’t want to contact CRON if the new version has this option out of the box. Perhaps I searched badly, but I did not find anything specific on this topic in the context of PostgreSQL 11. If the database doesn't provide this out of the box, what do you think is the best way to use it? What is more fault tolerant?
Answer the question
In order to leave comments, you need to log in
No, there is no such thing. Because it is not clear why.
If you can reasonably point out to the community that such a thing is needed for some reason - welcome. Then find an interested developer (well, or yourself), who will take up the discussion of the user interface, write a patch and bring it to agreement with at least one committer in the absence of strong objections from the rest of the community.
Now pg12 is being prepared, there are no discussions of task schedulers. Therefore, it is unlikely that it will appear in the pg13 release.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question