How to install pg_cron extension with Postgres-cluster

zalando / postgres-operator

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes

https://postgres-operator.readthedocs.io/

MIT License

4.37k stars 980 forks source link

How to install pg_cron extension with Postgres-cluster #2797

Open bhanotjyoti opened 3 weeks ago

bhanotjyoti commented 3 weeks ago

I would like to install pg_cron in my postgres cluster created by zalando operator. How can I do it?

FxKu commented 3 days ago

It's available in the postgres database or every Postgres cluster and you would use the cron.schedule_in_database function to create cron jobs connecting to your app databases.