From: Scott Whitney <scott@journyx.com>
To: Devrim Gündüz <devrim@gunduz.org>
Cc: shyamkant.dhamke@wipro.com
Cc: pgsql-admin@postgresql.org
Subject: Re: Clustering of pgsql 9.2
Date: Thu, 15 Jan 2015 01:39:18 -0600 (CST)
Message-ID: <195846703.4130.1421307558284.JavaMail.zimbra@zimbra.int.journyx.com> (raw)
References: <HKXPR03MB093590470233805DB662C81C984E0@HKXPR03MB0935.apcprd03.prod.outlook.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
<p dir="ltr">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="ltr">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="ltr">However, you are talking HA and failover (those are separate) and replication (also separate).</p>
<p dir="ltr">I would love to advise you on this list where the Big Brains are watching.</p>
<p dir="ltr">So...</p>
<p dir="ltr">What's your primary server?<br>
Why does it need to replicate? <br>
Is PITR an option?<br>
Is PITR a necessity?<br>
How many servers are involved?<br>
What's your bandwidth between master and slave(s)<br>
?</p>
<br/><div class="cm_quote" style=" color: #787878">On Thu, Jan 15, 2015 at 12:54 AM, Devrim Gündüz <<a href="mailto:devrim@gunduz.org">devrim@gunduz.org</a>> wrote:</div><br><div id="oldcontent" style="background-color: rgb(255, 255, 255); background-position: initial initial; background-repeat: initial initial;"><blockquote style=""><p dir="ltr">Hi,
<br>
<br>
On Thu, 2015-01-15 at 05:24 +0000, shyamkant.dhamke@wipro.com wrote:
<br>
<br>
> We have following environment for database clustering at production environment:
<br>
>
<br>
> 1. Postgres is running on RedHat 6 enterprise edition for primary and failover server
<br>
>
<br>
> 2. SAN disk is available
<br>
>
<br>
> Now I need help on following
<br>
>
<br>
> 1. What should be clustering software used for Redhat clustering ? Can Veritas Clustering Software (VCS) clustering be used for clustering REDHAT OS?
<br>
>
<br>
> 2. How the SAN disk can be used to store the data centrally? Can this be used as QUORAM disk?
<br>
>
<br>
> 3. Is there any service for Postgres Database service clustering?
<br>
<br>
http://www.gunduz.org/download.php?dlid=208
<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>
--
<br>
Devrim GÜNDÜZ
<br>
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
<br>
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
<br>
Twitter: @DevrimGunduz , @DevrimGunduzTR
<br>
<br>
</p>
</blockquote></div>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott@journyx.com, devrim@gunduz.org, shyamkant.dhamke@wipro.com
Subject: Re: Clustering of pgsql 9.2
In-Reply-To: <195846703.4130.1421307558284.JavaMail.zimbra@zimbra.int.journyx.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox