pgpool can do this for you, however, we have found quite a few issues with its codebase.  I'll work on pushing our patches up to pgpool next week sometime.

Mike

On Aug 3, 2010, at 5:17 PM, Madovsky wrote:

Hi Clue guys,
 
hope you enjoy at Cluecon !
Is there any setings in FS to restart it
in case of idle DB connection ?
exemple : if the DB on node1 fails and node2 starts DB in failover with the same shared IP,
FS continues to believe that node1 is yet the right node to contact....
so all SIP communicatio with DB are stalled
maybe a restart or other would be nice or anything else to unblock the status.