citusdata / citusdata/pg_cron

Many databases, possibility to have different cron schémas?

Open
#151 3 comments 5 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

We have several databases in the same Postgres instance and we would like to 'split' them across crondb schemas, instead of having them all in the 'cron' schema. We tried creating a cron_test schema in crondb and using select * from cron_test.schedule but it didn't work.

ERROR: function cron_test.schedule(unknown, unknown, unknown) does not exist
LINE 1: select cron_test.schedule('tester test schedule',' * * * * *...

Is there a quick and dirty work-around to this? We are doing to it 'secure' cron info between databases.

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.