Is it possible to add pg_dbms_job to shared_preload_libraries

[Eric-zch]

Hi There,

Instead of run the pg_dbms_job process manually, is it possible to add pg_dbms_job to shared_preload_libraries, and postgres can start and manage the process. Just like pg_cron?

Thank you.

[darold]

Hi,

No, pg_dbms_job is a standalone deamon that you have to start interdependently of PostgreSQL to be able to execute the daemon on an other server in case of very high parallel job. I have in plan to also write it as a PostgreSQL background worker and in this case it will be loadable by shared_preload_libraries.

Best regards

[Eric-zch]

@darold
Got it. Thank you.
I will start pg_dbms_job scheduler on a separate server. Also looking forward to the enhancements.

[rsabankar]

+1 for this request. It would be nice to have this loaded in shared_preload_libraries

[cwang9208]

+1 for this request.

[psavva]

+1 for this request