I'm trying to set up PostgreSQL 9.3 server in HA mode on 2 Windows servers. Final solution should be deployed to Microsoft azure network, so there are few limitations. Since Microsoft is doing maintenance on their machines without any warning, I find it difficult to setup such system. If you have any idea how to do it, I'll be glad to hear it.
I already tried to setup Windows Cluster with shared data disk (ISCSI), as suggested on several sites. I found out that, due to heavy NFS caching, failover works only if there are no transactions for few minutes. If there are transactions, after several failovers database became corrupted and service failed to start on both machines.
I can always try to setup this on linux machines using pgpool, but I prefer if this could be done on windows because application is written for IIS. I've done this with Microsoft SQL server on 3 machines without much difficulties, but I couldn't find similar solution for PostgreSQL.
Thanks in advance! Kind regards, Ivan