I am using JBoss 7.2, an enterprise application communicating with a PostgreSQL Database.
I would like to know, if it is possible to transparently fail over to a replicated Slave DB in case of a failure of a primary DB server.
It is possible to automate the process so that secondary server(replicated slave) starts functioning as a primary server in case of a failure of the original primary server.But I am not sure if it's possible to redirect app server's connections to point to a new host ?
Even if app server supports transparent failover, what happens to existing connections in the pool ?