Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id B49FD1335ED4 for ; Mon, 20 Sep 2010 12:26:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 06137-07 for ; Mon, 20 Sep 2010 15:26:45 +0000 (UTC) X-Greylist: delayed 00:30:37.532999 by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id ADA151335C08 for ; Mon, 20 Sep 2010 12:26:44 -0300 (ADT) Received: by pxi10 with SMTP id 10so1167186pxi.19 for ; Mon, 20 Sep 2010 08:26:43 -0700 (PDT) Received: by 10.114.130.20 with SMTP id c20mr10147258wad.104.1284994566214; Mon, 20 Sep 2010 07:56:06 -0700 (PDT) Received: from ANIBALVAIO ([190.128.222.90]) by mx.google.com with ESMTPS id k14sm2870310vcs.1.2010.09.20.07.56.01 (version=TLSv1/SSLv3 cipher=RC4-MD5); Mon, 20 Sep 2010 07:56:03 -0700 (PDT) From: "Anibal David Acosta" To: "'Kasia Tuszynska'" , References: <232B5217AD58584C87019E8933556D110214AB147C@redmx2.esri.com> In-Reply-To: <232B5217AD58584C87019E8933556D110214AB147C@redmx2.esri.com> Subject: Re: question about HA in PG 9.0 Date: Mon, 20 Sep 2010 10:55:59 -0400 Message-ID: <000b01cb58d3$f1cabad0$d5603070$@edge.com.py> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_000C_01CB58B2.6ABB8BD0" X-Mailer: Microsoft Outlook 14.0 Thread-Index: AQGjS4h8MaKi0E5qh+tnJvKO23DLWpNrD2CQ Content-Language: es-py X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.899 tagged_above=-10 required=5 tests=BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/138 X-Sequence-Number: 35682 This is a multipart message in MIME format. ------=_NextPart_000_000C_01CB58B2.6ABB8BD0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit Windows server enterprise has the Microsoft Cluster Services. This enable fail-over scenario between two computers. So, when one of them go offline, the other is activated, this involve many steps, including IP changing, the slave become the master IP address . But you can choose between has a replication between both postgres or maybe you can put your postgresql DATA directory to an external storage shared between those two servers. If this case, when the second server become available the Cluster service map map the DATA unit and starts the postgres service. So, you have everything running and working in aprox. 10 seconds. De: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] En nombre de Kasia Tuszynska Enviado el: viernes, 17 de septiembre de 2010 07:30 p.m. Para: pgsql-admin@postgresql.org Asunto: [ADMIN] question about HA in PG 9.0 Hi Everybody, I am doing a bit of research about High Availability solutions offered as part of core in Postges 9.0, I have couple of questions, sorry if they expose my novice status where it comes to HA on Postgres: 1. The doc is lovely but all of the examples are for linux, has anyone tired a Hot Standby streaming scenario on windows? Any issues specific to windows? I know that linux and windows environments "should" behave the same but actually running in both of those environments exposes many differences. 2. I am reading the Beta4 doc where under section 25.3 Failover it says: "PostgreSQL does not provide the system software required to identify a failure on the primary and notify the standby database server. Many such tools exist and are well integrated with the operating system facilities required for successful failover, such as IP address migration." I have been reading up on this issue most notably on http://wiki.postgresql.org/wiki/Shared_Storage, where the suggestions have been gravitating to solutions on the physical level. Are there any software level solutions? ( I have a feeling that this may be a stupid question, but I want to implement this in the cloud, and not potentially kill an ami instance) I found a presentation by Heikki Linnakangas where he mentions: Heartbeat and Shoot the other Node in the head as types of 3rd party high availability tools, does anyone have any recommendations of specific software packages? Thank you, Sincerely, Kasia ------=_NextPart_000_000C_01CB58B2.6ABB8BD0 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Windows server enterprise has the = Microsoft Cluster Services.

This enable = fail-over scenario between two computers.

 

So, when = one of them go offline, the other is activated, this involve many steps, = including IP changing, the slave become the master IP address = .

 

But you can = choose between has a replication between both postgres or maybe you can = put your postgresql DATA directory to an external storage shared between = those two servers.

 

If this = case, when the second server become available the Cluster service map = map the DATA unit and starts the postgres = service.

 

So, you = have everything running and working in aprox. 10 = seconds.

 

 

 

 

De: = pgsql-admin-owner@postgresql.org = [mailto:pgsql-admin-owner@postgresql.org] En nombre de Kasia = Tuszynska
Enviado el: viernes, 17 de septiembre de 2010 07:30 = p.m.
Para: pgsql-admin@postgresql.org
Asunto: = [ADMIN] question about HA in PG 9.0

 

Hi Everybody,

I am doing a bit of research about = High Availability solutions offered as part of core in Postges 9.0, I = have couple of questions, sorry if they expose my novice status where it = comes to HA on Postgres:

1.       = The doc is lovely but = all of the examples are for linux, has anyone tired a Hot Standby = streaming scenario on windows?  Any issues specific to windows? =  I know that linux and windows environments “should” = behave the same but actually running in both of those environments = exposes many differences.

2.       = I am reading the Beta4 = doc where under section 25.3 Failover it says:

“PostgreSQL does not = provide the system software required to identify a failure on the = primary and notify the standby database server. Many such tools exist = and are well integrated with the operating system facilities required = for successful failover, such as IP address = migration.”

I have been reading up = on this issue most notably on http://wiki.postg= resql.org/wiki/Shared_Storage, where the suggestions have been = gravitating to solutions on the physical level.

Are = there any software level solutions? ( I have a feeling that this may be = a stupid question, but I want to implement this in the cloud, and not = potentially kill an ami instance)

I = found a presentation by Heikki Linnakangas where he mentions: Heartbeat = and Shoot the other Node in the head as types of 3rd party = high availability tools, does anyone have any recommendations of = specific software packages?

 

Thank you,

Sincerely,

Kasia =

------=_NextPart_000_000C_01CB58B2.6ABB8BD0--