Re: Clustering of pgsql 9.2

<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&nbsp; (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 &lt;<a href="mailto:devrim(at)gunduz(dot)org">devrim(at)gunduz(dot)org</a>&gt; 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(dot)dhamke(at)wipro(dot)com wrote:
<br>

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