Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43258=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YBf1h-0007wl-Qz
 for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jan 2015 07:39:33 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-admin-owner+M43258=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
 id 1YBf1h-0006Kw-AL
 for pgsql-admin@arkaria.postgresql.org; Thu, 15 Jan 2015 07:39:33 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <scott@journyx.com>) id 1YBf1f-0006GE-Sm
 for pgsql-admin@postgresql.org; Thu, 15 Jan 2015 07:39:31 +0000
Received: from mail.journyx.com ([209.163.206.41] helo=mail.int.journyx.com)
 by magus.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <scott@journyx.com>) id 1YBf1Y-00041f-3F
 for pgsql-admin@postgresql.org; Thu, 15 Jan 2015 07:39:27 +0000
Received: from localhost (localhost [127.0.0.1])
 by mail.int.journyx.com (Postfix) with ESMTP id D6E22300290;
 Thu, 15 Jan 2015 01:39:18 -0600 (CST)
Received: from mail.int.journyx.com ([127.0.0.1])
 by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10032)
 with ESMTP id I98wS0w96A3k; Thu, 15 Jan 2015 01:39:18 -0600 (CST)
Received: from localhost (localhost [127.0.0.1])
 by mail.int.journyx.com (Postfix) with ESMTP id A9088300294;
 Thu, 15 Jan 2015 01:39:18 -0600 (CST)
X-Amavis-Modified: Mail body modified (using disclaimer) -
 mail.int.journyx.com
X-Virus-Scanned: amavisd-new at mail.int.journyx.com
Received: from mail.int.journyx.com ([127.0.0.1])
 by localhost (mail.int.journyx.com [127.0.0.1]) (amavisd-new, port 10026)
 with ESMTP id kRMNtO-V6FsF; Thu, 15 Jan 2015 01:39:18 -0600 (CST)
Received: from mail.int.journyx.com (zimbra.int.journyx.com [192.168.100.5])
 by mail.int.journyx.com (Postfix) with ESMTP id 7769F300290;
 Thu, 15 Jan 2015 01:39:18 -0600 (CST)
MIME-Version: 1.0
X-Mailer: CloudMagic
X-Mailer: Zimbra 8.5.0_GA_3042 (MobileSync - CloudMagic)
X-Cm-Message-Id: 
 14213075579039145f30565651f6cab3caa433898bc8281854b76ea5dcba81126885635
References: 
 <HKXPR03MB093590470233805DB662C81C984E0@HKXPR03MB0935.apcprd03.prod.outlook.com>
To: "Devrim =?UTF-8?Q?G=C3=BCnd=C3=BCz?=" <devrim@gunduz.org>
Cc: shyamkant.dhamke@wipro.com, pgsql-admin@postgresql.org
Subject: Re: Clustering of pgsql 9.2
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: quoted-printable
Message-ID: 
 <195846703.4130.1421307558284.JavaMail.zimbra@zimbra.int.journyx.com>
From: Scott Whitney <scott@journyx.com>
Date: Thu, 15 Jan 2015 01:39:18 -0600 (CST)
Thread-Topic: Clustering of pgsql 9.2
Thread-Index: VmlVruoqRqqGbROWjaxUjU6U+ebuWg==
X-Pg-Spam-Score: -0.8 (/)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

<p dir=3D=22ltr=22>Looks like a large size database. However, I would be =
concerned about the throughput on a SAN. Also, you didn't specify the =
replication/failover stuff.</p>
<p dir=3D=22ltr=22>So...never replicate or fail over to the same hardware. =
I disagree with the concept of databases on SANs (and we can open THAT =
discussion in another thread). I will pretty well tell you that no one here=
 has my IT/HA/OS experience. The Big Brains sure do know a whole lot more =
about PG, that's certain.</p>
<p dir=3D=22ltr=22>However, you are talking HA and failover (those are =
separate) and replication&nbsp; (also separate).</p>
<p dir=3D=22ltr=22>I would love to advise you on this list where the Big =
Brains are watching.</p>
<p dir=3D=22ltr=22>So...</p>
<p dir=3D=22ltr=22>What's your primary server=3F<br>
Why does it need to replicate=3F <br>
Is PITR an option=3F<br>
Is PITR a necessity=3F<br>
How many servers are involved=3F<br>
What's your bandwidth between master and slave(s)<br>
=3F</p>
<br/><div class=3D=22cm=5Fquote=22 style=3D=22 color: #787878=22>On Thu, =
Jan 15, 2015 at 12:54 AM, Devrim G=C3=BCnd=C3=BCz &lt;<a =
href=3D=22mailto:devrim@gunduz.org=22>devrim@gunduz.org</a>&gt; =
wrote:</div><br><div id=3D=22oldcontent=22 style=3D=22background-color: =
rgb(255, 255, 255); background-position: initial initial; =
background-repeat: initial initial;=22><blockquote style=3D=22=22><p =
dir=3D=22ltr=22>Hi,
<br>

<br>
On Thu, 2015-01-15 at 05:24 +0000, shyamkant.dhamke@wipro.com wrote:
<br>

<br>
&gt; We have following environment for&nbsp; database clustering at =
production environment:
<br>
&gt;=20
<br>
&gt; 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Postgres is running on RedHat 6=
 enterprise edition for primary and failover server
<br>
&gt;=20
<br>
&gt; 2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SAN disk is available
<br>
&gt;=20
<br>
&gt; Now I need help on following
<br>
&gt;=20
<br>
&gt; 1.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; What should be clustering =
software used for Redhat clustering =3F Can Veritas Clustering Software =
(VCS) clustering be used for clustering REDHAT OS=3F
<br>
&gt;=20
<br>
&gt; 2.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; How the SAN disk can be used to=
 store the data centrally=3F Can this be used as QUORAM disk=3F
<br>
&gt;=20
<br>
&gt; 3.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Is there any service for =
Postgres Database service clustering=3F
<br>

<br>
http://www.gunduz.org/download.php=3Fdlid=3D208
<br>

<br>
This presentation gives you an overview about how to setup Red Hat High
<br>
Availability Addon (formerly Red Hat Cluster Suite) with PostgreSQL,
<br>
which matches your needs.
<br>

<br>
Regards,
<br>
--=20
<br>
Devrim G=C3=9CND=C3=9CZ
<br>
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
<br>
PostgreSQL Dan=C4=B1=C5=9Fman=C4=B1/Consultant, Red Hat Certified Engineer
<br>
Twitter: @DevrimGunduz , @DevrimGunduzTR
<br>

<br>
</p>
</blockquote></div>