Please implement simple failover scenario - Mailing list pgsql-jdbc

Hi,

we are going to switch from Oracle to PostgreSQL and we would like to setup a simple hot-standby/warm-standby replication scenario.

Actually your JDBC driver does not have native support for failover to the slave host.

We are interestend in this scenario in order to implement the warm-standby case:

Case 1: WARM-STANDBY (slave is not accepting connections)

JDBC configuration:   use URL1 on getConnection….and URL2 as failover

Step of “getConnection”:

1)      Connect to URL1

2)      Connection OK à proceed with URL1

3)      Connection FAILED à proceed with URL2

Case 2: HOT-STANDBY (slave is accepting connections)

In order to implement the hot-standby we need to configure a query on getConnection in order to ask to the server if actually it is the actual “master”

1)      Connect to URL1

2)      Connection OK

a.       Ask “Are you the master?”

b.      Yes à proceed with URL1

c.       No à proceed with URL2

3)      Connection FAILED

a.       proceed with URL2

I known that this implementation is really “skinny” and some more advanced features are needed for more complete setups but this is what we need

We can contribute with some patch