Feature Request: Support for multiple databases with the Citus integration

[scottybrisbane]

Describe the feature request

We’re actively using Citus + Patroni with multiple "citus-enabled" databases in production and would really like to be able to use the new Citus integration with Patroni in our setup. Currently this integration only supports clusters with a single "citus-enabled" database which prevents us from using the new functionality.

[lkral-navmatix]

We would be very interested in using multiple Citus enabled databases with Patroni as well.
I am not currently familiar with the codebase but if there is something we could do to help move this forward, let me know.

[DBexpert]

I'm also very interested in this feature (and in our case it only need to support few databases - 5 or so; no more than 10)

[CyberDem0n]

few databases - 5 or so; no more than 10

Usually people create many databases in a single cluster because they are small or because the host where cluster runs has a lot of hardware resources. In both cases it is about efficiently utilizing resources.

Citus solves a different problem. You have a lot of data so it doesn't fit into a single machine and you want to spread this data across many of machines.

Therefore, creating multiple databases (especially so many) with a Citus extension is an antipattern. Either you have to few data and you don't need Citus, or you better run multiple Citus clusters, with one DB per cluster.

In other words, this feature will never be a top priority.