Received: from localhost (unknown [200.46.204.191])
	by postgresql.org (Postfix) with ESMTP id E3BFC2E3100
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 28 Dec 2007 04:12:25 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024)
	with ESMTP id 99936-01 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Fri, 28 Dec 2007 04:12:21 -0400 (AST)
Received: from py-out-1112.google.com (py-out-1112.google.com
 [64.233.166.180])
	by postgresql.org (Postfix) with ESMTP id 90D862E30F6
	for <pgsql-performance@postgresql.org>;
	Fri, 28 Dec 2007 04:12:21 -0400 (AST)
Received: by py-out-1112.google.com with SMTP id u77so6852139pyb.15
	for <pgsql-performance@postgresql.org>;
	Fri, 28 Dec 2007 00:12:20 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	bh=F7b0+di/6pfFG+UJfezgI7tKmZEBHhVMGun3IoZ43Z4=;
	b=x74Krxh4znudRBWj10m9Qpvg/CcOH/irqmJD37RAigmHSNBAgI56fzqrixFeKAsKfCxsWwsGBuBJGTNMsvR+rxTOd5L4bTINWAmqtl3CI6BEBVProNozglTj6Vn3ZAYn5poQGW7VfxANYoWp2BfbFi0+O9n5CdWVXgVgan9dYo0=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references;
	b=r+12N9a+6JHK/m7NlTdiq9cd13tfHCZrWc/2yrwBFWEC9jurkr+h7Zmg8TYDjjKuYiObH13wG9i5nWJMIt6amhY7wBWHVGY/0S+9UKx5VmdSgwYVN0oLDl2pUpCjnlFqPv7pmE165xFfSv5AScyMWeC2HCAUBvcHBgZQK5l6KbQ=
Received: by 10.65.93.19 with SMTP id v19mr17335530qbl.89.1198829537317;
	Fri, 28 Dec 2007 00:12:17 -0800 (PST)
Received: by 10.65.83.8 with HTTP; Fri, 28 Dec 2007 00:12:17 -0800 (PST)
Message-ID: <2ca799770712280012k63641aeap13dfd54eed4dc59@mail.gmail.com>
Date: Fri, 28 Dec 2007 10:12:17 +0200
From: "Mikko Partio" <mpartio@gmail.com>
To: "Chris Hoover" <revoohc@gmail.com>
Subject: Re: Anyone running on RHEL Cluster?
Cc: "PGSQL Performance" <pgsql-performance@postgresql.org>
In-Reply-To: <1d219a6f0712260936gd86f49eu7287b7cab523e10e@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_15256_20396995.1198829537312"
References: <1d219a6f0712260936gd86f49eu7287b7cab523e10e@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200712/420
X-Sequence-Number: 28236

------=_Part_15256_20396995.1198829537312
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Dec 26, 2007 7:36 PM, Chris Hoover <revoohc@gmail.com> wrote:

> Is anyone running their production PostgreSQL server on the RHEL Cluster
> software?  If so, how is it working for you?  My linux admin is looking at
> trying to increase the robustness of our environment and wanting to try and
> eliminate as many single points of failure as possible.
>
> So, I am looking for any hands on experience in running PostgreSQL in some
> sort of HA cluster.
>
>
I was looking for the same information previously this year (
http://archives.postgresql.org/pgsql-general/2007-08/msg00910.php). At that
time I concluded that using drbd for data replication was probably better
choice than using RHCS and shared storage, but afterwards the requirements
for the cluster changed so that drbd was no longer a suitable choice, and we
ended up with building a RHCS cluster with shared disk and gfs.

The cluster has been working as expected and not counting a few minor
annoyances I haven't had any problems with it (this is with RHEL 5.1). My
initial fear was that somehow two postmasters could be accessing the same
set of file but after testing I have not been able to produce this (ie. the
fencing is working). So overall I see no reason not to go with RHCS if it
satisifies your business requirements.

Regards

M

------=_Part_15256_20396995.1198829537312
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<br><br><div class="gmail_quote">On Dec 26, 2007 7:36 PM, Chris Hoover &lt;<a href="mailto:revoohc@gmail.com">revoohc@gmail.com</a>&gt; wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Is anyone running their production PostgreSQL server on the RHEL Cluster software?&nbsp; If so, how is it working for you?&nbsp; My linux admin is looking at trying to increase the robustness of our environment and wanting to try and eliminate as many single points of failure as possible.
<br><br>So, I am looking for any hands on experience in running PostgreSQL in some sort of HA cluster.<br><br></blockquote></div><br>I was looking for the same information previously this year (<a href="http://archives.postgresql.org/pgsql-general/2007-08/msg00910.php">
http://archives.postgresql.org/pgsql-general/2007-08/msg00910.php</a>). At that time I concluded that using drbd for data replication was probably better choice than using RHCS and shared storage, but afterwards the requirements for the cluster changed so that drbd was no longer a suitable choice, and we ended up with building a RHCS cluster with shared disk and gfs.
<br><br>The cluster has been working as expected and not counting a few minor annoyances I haven&#39;t had any problems with it (this is with RHEL 5.1). My initial fear was that somehow two postmasters could be accessing the same set of file but after testing I have not been able to produce this (ie. the fencing is working). So overall I see no reason not to go with RHCS if it satisifies your business requirements.
<br><br>Regards<br><br>M<br>

------=_Part_15256_20396995.1198829537312--