Re: [sqlalchemy] Support for backup node connection.

2019-04-04 Thread Mike Bayer
On Thu, Apr 4, 2019 at 3:49 PM rishi reddy wrote: > > Unfortunately, I am using Superset which uses SQLALCHEMY for metadata DB > connection. So I am not sure if I could have control over the code or not. Is > there any other way I could do this? unfortunately no until someone has time to help

Re: [sqlalchemy] Support for backup node connection.

2019-04-04 Thread rishi reddy
Unfortunately, I am using Superset which uses SQLALCHEMY for metadata DB connection. So I am not sure if I could have control over the code or not. Is there any other way I could do this? On Thursday, 4 April 2019 15:24:42 UTC-4, Mike Bayer wrote: > > the issue describing how this feature can

Re: [sqlalchemy] Support for backup node connection.

2019-04-04 Thread Mike Bayer
the issue describing how this feature can be added is at: https://github.com/sqlalchemy/sqlalchemy/issues/4392 for now you need to use creator to connect to psycopg2 directly and return the connection yourself from a function, which you pass to create_engine:

[sqlalchemy] Support for backup node connection.

2019-04-04 Thread rishi reddy
Hi All, I have Postgres DB two node cluster and using SQLALCHEMY_DATABASE_URI were we can give only one node details. But how can i achieve a scenario were if the given node goes down SQLALCHEMY will connect to the other backup node. Is there an option of giving the backup node details in