Re: Microsoft Cluster for Failsafe - Mailing list pgsql-cluster-hackers

From Al-Salami, Adel
Subject Re: Microsoft Cluster for Failsafe
Date
Msg-id A325334B2DF7DC4690FF38CB11BC3AFB22EFFD1276@w2k8n202
Whole thread Raw
In response to Re: Microsoft Cluster for Failsafe  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Microsoft Cluster for Failsafe  (Magnus Hagander <magnus@hagander.net>)
List pgsql-cluster-hackers
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
(onedata store which could be owned by one node at a time and two Postgres Instances on both nodes one is active and
theother is passive, just like oracle Failsafe on ms cluster), the available documentation is only mentioning the
Replicationand standby are the only choices for Postgres High availability and Clustering-Failover not.
 



Cheers
Adel


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

On Thu, Sep 8, 2011 at 19:55, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Thu, Sep 8, 2011 at 2:17 PM, Al-Salami, Adel <saa@klinkhammer.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
sindoder 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
receivedthis e-mail in error) please notify the sender immediately and destroy this e-mail. Any unauthorized copying,
disclosureor distribution of the material in this e-mail is strictly forbidden.
 

pgsql-cluster-hackers by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Microsoft Cluster for Failsafe
Next
From: Magnus Hagander
Date:
Subject: Re: Microsoft Cluster for Failsafe