Handle DB Fail-over on postgres

Question

Can anyone help with the following?

• Is there any solution to feature similar to Oracle TAF (Transparent application Fail-over) in Postgres database
• Else how database fail-overs handled on industry level in Java code? Is there any solution other than retry the query with a timer?

Answer 1

TAF is partly a lie - data modifying statements won't fail over. And no, there is no such thing in PostgreSQL.

I don't see the need for a timer. What you do to make your application resilient to failovers is to examine the SQLSTATE of the error you got, and if it indicates connection loss, you repeat the transaction. Keep a count so that you don't end up looping endlessly if the error is persistent.