Re: Load balancing and high availability with PostgreSQL

<div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace,
sans-serif;font-size:24px"><br/><div class="qtdSeparateBR"><br /><br /></div><div class="yahoo_quoted"
id="yui_3_16_0_ym19_1_1465310133343_3893"style="display: block;"><div id="yui_3_16_0_ym19_1_1465310133343_3892"
style="font-family:Courier New, courier, monaco, monospace, sans-serif; font-size: 24px;"><div
id="yui_3_16_0_ym19_1_1465310133343_3891"style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida
Grande,sans-serif; font-size: 16px;"><div dir="ltr" id="yui_3_16_0_ym19_1_1465310133343_3890"><font face="Arial"
id="yui_3_16_0_ym19_1_1465310133343_3897"size="2"><b><span style="font-weight:bold;">>From:</span></b> Sunil N
Shinde<Sunil.Shinde@mastek.com><br /><b><span style="font-weight: bold;">>To:</span></b>
"pgadmin-support@postgresql.org"<pgadmin-support@postgresql.org> <br /><b><span style="font-weight:
bold;">>Sent:</span></b>Tuesday, June 7, 2016 5:11 AM<br /><b><span style="font-weight:
bold;">>Subject:</span></b>[pgadmin-support] Load balancing and high availability with PostgreSQL<br
/></font></div><divclass="y_msg_container" id="yui_3_16_0_ym19_1_1465310133343_3898">><br /><div
id="yiv1202724327"><style><!--
#yiv1202724327  _filtered #yiv1202724327 {font-family:"Cambria Math";panose-1:2 4 5 3 5 4 6 3 2 4;}_filtered
#yiv1202724327{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} 
#yiv1202724327
#yiv1202724327 p.yiv1202724327MsoNormal, #yiv1202724327 li.yiv1202724327MsoNormal, #yiv1202724327
div.yiv1202724327MsoNormal{margin:0cm;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",sans-serif;} 
#yiv1202724327 a:link, #yiv1202724327 span.yiv1202724327MsoHyperlink{color:blue;text-decoration:underline;}
#yiv1202724327 a:visited, #yiv1202724327
span.yiv1202724327MsoHyperlinkFollowed{color:purple;text-decoration:underline;}
#yiv1202724327 span.yiv1202724327EmailStyle17{font-family:"Calibri", sans-serif;color:windowtext;}
#yiv1202724327 .yiv1202724327MsoChpDefault{font-family:"Calibri", sans-serif;}_filtered #yiv1202724327 {margin:72.0pt
72.0pt72.0pt 72.0pt;} 
#yiv1202724327 div.yiv1202724327WordSection1{}
--></style><div id="yui_3_16_0_ym19_1_1465310133343_3901"><div class="yiv1202724327WordSection1"
id="yui_3_16_0_ym19_1_1465310133343_3900"><divclass="yiv1202724327MsoNormal"
id="yui_3_16_0_ym19_1_1465310133343_3899">>Hi,</div><divclass="yiv1202724327MsoNormal"
id="yui_3_16_0_ym19_1_1465310133343_3904">> <br /></div><div class="yiv1202724327MsoNormal"
id="yui_3_16_0_ym19_1_1465310133343_3903">>Ineed to do the setup of High availability load balancing with 02
nodes.</div><divclass="yiv1202724327MsoNormal" id="yui_3_16_0_ym19_1_1465310133343_3906">>Can you please help me in
thisregard by providing me the detailed steps to do this setup?</div><div class="yiv1202724327MsoNormal"> > <br
/></div><divclass="yiv1202724327MsoNormal" id="yui_3_16_0_ym19_1_1465310133343_3907">>                Database --
Postgresql9.1</div><div class="yiv1202724327MsoNormal" id="yui_3_16_0_ym19_1_1465310133343_3908">>               
OS            -- Linux 6          </div><div class="yiv1202724327MsoNormal"
id="yui_3_16_0_ym19_1_1465310133343_3910"></div><divclass="yiv1202724327MsoNormal"
id="yui_3_16_0_ym19_1_1465310133343_3911">? <br /></div><div class="yiv1202724327MsoNormal"
id="yui_3_16_0_ym19_1_1465310133343_3913"><spanstyle="">>Thanks & Regards,</span></div><div
class="yiv1202724327MsoNormal"id="yui_3_16_0_ym19_1_1465310133343_3914"><span style="">>Sunil N Shinde</span><span
style=""></span></div><divclass="yiv1202724327MsoNormal" id="yui_3_16_0_ym19_1_1465310133343_3915">
 </div></div></div></div><divid="yui_3_16_0_ym19_1_1465310133343_4087"><br /></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1465310133343_3999"><spanid="yui_3_16_0_ym19_1_1465310133343_4000">>I need to do the setup of
Highavailability load balancing with 02 nodes.<br id="yui_3_16_0_ym19_1_1465310133343_4114" /><br
id="yui_3_16_0_ym19_1_1465310133343_4115"/><b>Three things.</b></span></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1465310133343_4135"><b><spanid="yui_3_16_0_ym19_1_1465310133343_4000"><br /></span></b></div><div
dir="ltr"id="yui_3_16_0_ym19_1_1465310133343_4134"><b id="yui_3_16_0_ym19_1_1465310133343_4143"><span
id="yui_3_16_0_ym19_1_1465310133343_4000">1.This is not the mailing list for this type of question. PgAdmin is a
utilityfor accessing PostgreSQL, it is not PostgreSQL per se.<br id="yui_3_16_0_ym19_1_1465310133343_4117" />You should
insteadaddress the pgsql-general@postgresql.org list, but FIRST you must subscribe to that list at <br
id="yui_3_16_0_ym19_1_1465310133343_4118"/>https://www.postgresql.org/list/<br
id="yui_3_16_0_ym19_1_1465310133343_4119"/><br id="yui_3_16_0_ym19_1_1465310133343_4120" />2. These are TWO DIFFERENT
items.For load balancing you will want to look at either <br /></span></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1465310133343_4185"><bid="yui_3_16_0_ym19_1_1465310133343_4143"><span
id="yui_3_16_0_ym19_1_1465310133343_4000">PgBouncer
http://lists.pgfoundry.org/pipermail/pgbouncer-general/2012-April/000980.html<br
id="yui_3_16_0_ym19_1_1465310133343_4121"/>or <br /></span></b></div><div dir="ltr"
id="yui_3_16_0_ym19_1_1465310133343_4184"><bid="yui_3_16_0_ym19_1_1465310133343_4143"><span
id="yui_3_16_0_ym19_1_1465310133343_4000">PgPoolhttp://www.pgpool.net/docs/latest/tutorial-en.html<br
id="yui_3_16_0_ym19_1_1465310133343_4122"/><br id="yui_3_16_0_ym19_1_1465310133343_4123" />3. For High availablity, you
shouldlook into Replication https://www.postgresql.org/docs/9.1/static/high-availability.html<br
id="yui_3_16_0_ym19_1_1465310133343_4124"/>or alternatively Slony http://lists.slony.info/<br
id="yui_3_16_0_ym19_1_1465310133343_4125"/>or Bucardo <a class="enhancr2_38cb1a9f-69c7-4825-ff90-559a8b8e5fff"
href="https://bucardo.org/wiki/Bucardo"id="yui_3_16_0_ym19_1_1465310133343_4128">Bucardo - Bucardo</a><br
id="yui_3_16_0_ym19_1_1465310133343_4001"/></span></b></div><div id="yui_3_16_0_ym19_1_1465310133343_4156"><br
/></div><divclass="yahoo-link-enhancr-card  ymail-preserve-class ymail-preserve-style" contenteditable="false"
data-category="article"data-embed-url="" data-size="medium" data-type="yenhancr"
data-url="https://bucardo.org/wiki/Bucardo"dir="ltr" id="enhancr2_38cb1a9f-69c7-4825-ff90-559a8b8e5fff"
style="max-width:400px;font-family:'HelveticaNeue', Helvetica, Arial, sans-serif;"><a class="yahoo-enhancr-cardlink"
href="https://bucardo.org/wiki/Bucardo"rel="noreferrer" style="text-decoration:none !important; color: #000
!important;"target="_blank"><table border="0" cellpadding="0" cellspacing="0" class="card-wrapper yahoo-ignore-table"
style="max-width:400px;"><tbody><tr><tdwidth="400"><table border="0" cellpadding="0" cellspacing="0" class="card
yahoo-ignore-table"style="max-width:400px;" width="100%"><tbody><tr><td
background="https://s.yimg.com/vv//api/res/1.2/FUwzpkCLAxTbowZbU3jFhw--/YXBwaWQ9bWFpbDtmaT1maWxsO2g9MjAwO3c9NDAw/https://bucardo.org/bucardowiki/resources/assets/poweredby_mediawiki_88x31.png.cf.jpg"
bgcolor="#000000"class="card-primary-image-cell" style="background:#000
url('https://s.yimg.com/vv//api/res/1.2/FUwzpkCLAxTbowZbU3jFhw--/YXBwaWQ9bWFpbDtmaT1maWxsO2g9MjAwO3c9NDAw/https://bucardo.org/bucardowiki/resources/assets/poweredby_mediawiki_88x31.png.cf.jpg')
no-repeatcenter center;background-size:cover;height:200px;position:relative;" valign="top"><table border="0"
cellpadding="0"cellspacing="0" class="yahoo-ignore-table" style="width:100%;" valign="top"><tbody><tr><td
background="https://s.yimg.com/nq/storm/assets/enhancrV2/12/overlay-tile.png"bgcolor="transparent"
style="background:transparenturl('https://s.yimg.com/nq/storm/assets/enhancrV2/12/overlay-tile.png') repeat left
top;height:200px;"valign="top"><table class="yahoo-ignore-table" height="185"
style="width:100%;height:185px;min-height:185px;"><tbody><tr><tdclass="card-richInfo2"
style="text-align:left;text-align:left;padding:15px0 0 15px;vertical-align:top;"></td><td class="card-actions"
style="text-align:right;padding:15px15px 0 0;vertical-align:top;"><div
class="card-share-container"></div></td></tr></tbody></table></td></tr></tbody></table></td></tr><tr><td><table
align="center"border="0" cellpadding="0" cellspacing="0" class="card-info yahoo-ignore-table"
style="background:#fff;position:relative;z-index:2;width:95%;max-width:380px;border:1pxsolid #e0e4e9;border-bottom:3px
solid#000000;margin-top:-40px;margin-left:auto;margin-right:auto;"><tbody><tr><td
style="background-color:#ffffff;padding:16px0 16px 12px;vertical-align:top;"></td><td
style="vertical-align:middle;padding:16px12px;width:99%;"><h2 class="card-title" style="font-size: 16px;
line-height:19px;margin:0 0 4px 0;font-family:'Helvetica Neue', Helvetica, Arial,
sans-serif;word-break:break-word;">Bucardo- Bucardo</h2><div class="card-description"
style="font-size:11px;line-height:15px;color:#999;word-break:break-word;"></div></td><td
style="text-align:right;padding:16px12px 16px
0;"></td></tr></tbody></table></td></tr></tbody></table></td></tr></tbody></table></a></div><div
id="yui_3_16_0_ym19_1_1465310133343_4203"><br/></div><div id="yui_3_16_0_ym19_1_1465310133343_4002"> </div><div
id="yui_3_16_0_ym19_1_1465310133343_4003"><divid="yui_3_16_0_ym19_1_1465310133343_4004"><font
id="yui_3_16_0_ym19_1_1465310133343_4005"size="4"><span id="yui_3_16_0_ym19_1_1465310133343_4006"
style="font-weight:bold;font-family:arial;color:rgb(0,0, 255);">Melvin Davidson </span></font><font
id="yui_3_16_0_ym19_1_1465310133343_4008"size="3"><br id="yui_3_16_0_ym19_1_1465310133343_4015" /></font><font
id="yui_3_16_0_ym19_1_1465310133343_4016"size="3" style="font-weight:bold;"><span
id="yui_3_16_0_ym19_1_1465310133343_4017"style="color:rgb(128, 0, 255);">I reserve the right to fantasize.  Whether or
notyou </span><br id="yui_3_16_0_ym19_1_1465310133343_4018" style="color:rgb(128, 0, 255);" /><span
id="yui_3_16_0_ym19_1_1465310133343_4019"style="color:rgb(128, 0, 255);">wish to share my fantasy is entirely up to
you.</span><img data-id="c2dd4149-6523-9d1c-b8c3-b55e21dc536b" id="yui_3_16_0_ym19_1_1465310133343_4020"
src="http://us.i1.yimg.com/us.yimg.com/i/mesg/tsmileys2/01.gif"style="color:rgb(128, 0, 255);" /><br
id="yui_3_16_0_ym19_1_1465310133343_4021"/></font><font id="yui_3_16_0_ym19_1_1465310133343_4023" size="3"><span
id="yui_3_16_0_ym19_1_1465310133343_4024"style="font-weight:bold;font-family:courier;">Folk Alley - All Folk - 24 Hours
aday </span><span id="yui_3_16_0_ym19_1_1465310133343_4025" style="font-weight:bold;font-family:courier;"><br
id="yui_3_16_0_ym19_1_1465310133343_4026"/>www.folkalley.com<br id="yui_3_16_0_ym19_1_1465310133343_4027" /><br
id="yui_3_16_0_ym19_1_1465310133343_4028"/></span></font></div></div></div></div></div></div></div>