Re: Microsoft Cluster for Failsafe

On Fri, Sep 9, 2011 at 08:54, Al-Salami, Adel <saa(at)klinkhammer(dot)com> wrote:
> Thanks for the prompt response,
>
> Good to hear that, but really I cannot find a document how to configure Postgres as Failover on a 2 node MS cluster (one data store which could be owned by one node at a time and two Postgres Instances on both nodes one is active and the other is passive, just like oracle Failsafe on ms cluster), the available documentation is only mentioning the Replication and standby are the only choices for Postgres High availability and Clustering-Failover not.

You set it up like a "generic service" I think it's called in MSCS. In
a group along with the storage resource and the IP address. And make
sure you have all your postgresql data on that disk. How that's done
should be in the MS documentation.

This is not a PostgreSQL feature really, but one of MSCS, that's why
it's not included in the PostgreSQL documentation. What we have is at
http://www.postgresql.org/docs/9.0/static/different-replication-solutions.html,
under "shared disk failover" - that's the MSCS solution.

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/