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'tspecify the replication/failover stuff.<p dir="ltr">So...never replicate or fail over to the same hardware. I
disagreewith the concept of databases on SANs (and we can open THAT discussion in another thread). I will pretty well
tellyou 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.<pdir="ltr">However, you are talking HA and failover (those are separate) and replication  (also separate).<p
dir="ltr">Iwould love to advise you on this list where the Big Brains are watching.<p dir="ltr">So...<p
dir="ltr">What'syour 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 /> ?<br
/><divclass="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;"><blockquotestyle=""><p dir="ltr">Hi, <br /><br /> On Thu, 2015-01-15 at 05:24 +0000,
shyamkant.dhamke@wipro.comwrote: <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
failoverserver <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
ClusteringSoftware (VCS) clustering be used for clustering REDHAT OS? <br /> > <br /> > 2.       How the SAN disk
canbe used to store the data centrally? Can this be used as QUORAM disk? <br /> > <br /> > 3.       Is there any
servicefor Postgres Database service clustering? <br /><br /> http://www.gunduz.org/download.php?dlid=208 <br /><br />
Thispresentation gives you an overview about how to setup Red Hat High <br /> Availability Addon (formerly Red Hat
ClusterSuite) 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,
RedHat Certified Engineer <br /> Twitter: @DevrimGunduz , @DevrimGunduzTR <br /><br /></blockquote></div>