Top
Enterprise Postgres 18 for Kubernetes User's Guide

5.17 Setup of Job Scheduler

pg_cron allows SQL statements to run a job scheduler.

Add "pg_cron" to the parameter "shared _preload_ libraries" of spec.fepChildCrVal.customPgParams in the FEPCluster custom resource. Increase the parameter “max_worker_processes” as needed. In addition to one resident process of pg_cron, max_worker_processes must be increased depending on the number of concurrently running jobs.

postgres=# CREATE EXTENSION pg_cron;
CREATE EXTENSION

When using the automatic password generation function of SUPERUSER and setting up this feature, refer to "6.7.1 CREATE EXTENSION" and execute CREATE EXTENSION.