Re: Microsoft Cluster for Failsafe

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.

Cheers
Adel

-----Ursprüngliche Nachricht-----
Von: Magnus Hagander [mailto:magnus(at)hagander(dot)net]
Gesendet: Donnerstag, 8. September 2011 23:04
An: Simon Riggs
Cc: Al-Salami, Adel; pgsql-cluster-hackers(at)postgresql(dot)org
Betreff: Re: [pgsql-cluster-hackers] Microsoft Cluster for Failsafe

On Thu, Sep 8, 2011 at 19:55, Simon Riggs <simon(at)2ndquadrant(dot)com> wrote:
> On Thu, Sep 8, 2011 at 2:17 PM, Al-Salami, Adel <saa(at)klinkhammer(dot)com> wrote:
>
>> We are working only on base of microsoft OS, and am thinking of installing
>> Postgres 9 on a 2 node microsoft cluster as a failsafe solution.
>>
>> Can I do that, using a builtin feature of Postgres, or is there an extra
>> software I can use?
>
> PostgreSQL 9.0 or higher is all you for a 2 node cluster.
>
> PostgreSQL 9.1 is available next week and you should start with that.

PostgreSQL has worked fine with the 2 node MS failover cluster since
the first native version on Windows, which was 8.0. You need no extra
software, and yo udon't need PostgreSQL 9.0 for it.

I share Simons recommentation that you *should* use PostgreSQL 9.0 or
9.1 though ;) And it also gives you other ways to build the
availability solution than the MS cluster one.

> Good luck and welcome to Postgres.

+1 :-)

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

A. Klinkhammer Förderanlagen Kreative Lager- und Produktionslogistik GmbH
Sitz der Gesellschaft: Nürnberg • Registergericht: Amtsgericht Nürnberg, HRB 15958
Geschäftsführer: Frank Klinkhammer, Gerald Schulz
USt ID: DE 198 660 907 • Steuer Nr.: 241/115/83087

Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und vernichten Sie diese Mail. Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail sind nicht gestattet.

This e-mail may contain confidential and/or privileged information. If you are not the intended recipient (or have received this e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying, disclosure or distribution of the material in this e-mail is strictly forbidden.