Datasource Reactive url with several connections and Leader and Replica setup

[debajit-sen]

Hi Team,

I have created a project with the following Quarkus dependencies:
implementation 'io.quarkus:quarkus-rest-jackson'
implementation 'io.quarkus:quarkus-hibernate-reactive-panache'
implementation 'io.quarkus:quarkus-reactive-pg-client'

I am using a PostgreSQL DB with a Leader and Replica setup, where localhost:5432 is the leader (write enabled) and localhost:5433 is the replica (read-only mode).

My application.properties file has the following configuration:
quarkus.datasource.db-kind=postgresql
quarkus.datasource.reactive.url=postgresql://localhost:5432/postgres,postgresql://localhost:5433/postgres

With this configuration, during database writes, I am facing issues where some write transactions marked with @WithTransaction are landing on the Replica DB (localhost:5433), resulting in the error: ERROR: cannot execute DELETE in a read-only transaction.

For JDBC connection strings, jdbc:postgresql://localhost:5432,localhost:5433/postgres?targetServerType=master with targetServerType set as master works correctly. Do we have something similar for defining reactive connection strings?

I have not been able to find a solution so far. Any help will be greatly appreciated.

[mbellade]

Hi @debajit-sen, this seems like a duplicate of #47698. Currently, @WithTransaction/@Transactional are not supported with Hibernate Reactive, but @lucamolteni is working on it.