Configuring EDB Job Scheduler
Suggest editsThe EDB Job Scheduler has a scheduler process that starts when the database cluster starts. To start the scheduler process, load the EDB Job Scheduler extension using the shared_preload_libraries
parameter.
After you load the extension, create the extension using the CREATE EXTENSION
command. The database in which you're creating the extension must be listed in the edb_job_scheduler.database_list
parameter.
The CREATE EXTENSION
command also creates two tables in the sys
schema: jobs
and job_run_details
.
In addition, the EDB Job Scheduler provides two more GUCs:
edb_job_scheduler.max_jobs_per_database
— Controls the maximum number of jobs per database level.edb_job_scheduler.max_workers_per_database
— Controls the maximum number of worker processes per database level.
To apply your changes, reload the configuration using pg_reload_conf()
or pg_ctl reload
.
Example
This example configures the EDB Job Scheduler extension.
Set the GUC parameter and the shared libraries parameter in
postgresql.conf
:Restart the database server.
Create the extension:
- On this page
- Example
Could this page be better? Report a problem or suggest an addition!