Replication failover on windows

[CS_DBA <cs_dba@xxxxxxxxxxxxxxxxxxx>]

Hi all;

we have a client running PostgreSQL on windows, and they want to run 
streaming replication with some sort of failover.

We have streaming replication in place, we thought we could use 
pgbouncer and in the case of the master being down our heartbeat script 
would reload the pgbouncer configs however pgbouncer on windows seems to 
never time out connections even when we set it to timeout. So this 
solution is probably a no go.

We are currently looking at IP aliases but it's windows so I have little 
confidence that it will be simple or stable.

Has anyone else deployed a heartbeat/failover solution on windows 
platforms? Any suggestions per an approach that would be seamless to the 
applications?


Thanks in advance