Is Cubejs possible to connect to a set of postgres replicate set?

[thinhvo-groove]

In the need of connecting cubejs to a set of posgres replicate set for scaling and back-up stategy using multiple standby prosgres db instances, is it possible to connect cubejs to a set of posgres relicate set?

Posgres connection string looks like this:
postgresql://host1:123,host2:456/somedb?target_session_attrs=any&application_name=myapp

Thanks.

[paveltiunov]

@thinhvo-groove Hey Thinh! Great question! Unfortunately there's no easy way to connect to Postgres cluster as there's no support in underlying node-posgres library which is used by driver: brianc/node-postgres#1470. Is it for load balancing? I believe you can use something like HAProxy in front of postgres to do that: https://www.percona.com/blog/2019/11/08/configure-haproxy-with-postgresql-using-built-in-pgsql-check/

[norbertbede]

try this. https://debezium.io/documentation/reference/1.0/postgres-plugins.html

[paveltiunov]

This issue is currently outside of our roadmap and we're looking for contributions here!

[aobzor]

@paveltiunov Are there any news about this issue? We need to support connection to Postgres cluster with cube.js, but it seems still impossible.

Or may be there is a deadline when it will be done.

Thanks.

[Vladislav-Lukyanuk]

Hey! Can it be implemented by cube.js it self, as a temporary solution?
If just taking a postgres driver source code as a basis.
It seems to be work as follow:

1. We can to not create a pool inside a constructor, instead create a async function to get a pool from available hosts.
2. When a function called next time and a host is alive just return a cached pool.