<div dir="ltr">Dears,<div><br></div><div>Just a kind reminder, if someone can help me in this regard.</div></div><br><div class="gmail_quote"><div dir="ltr" class="gmail_attr">On Wed, Mar 13, 2019 at 4:42 PM Shereef Sakr <<a href="mailto:shereef.sakr@gmail.com">shereef.sakr@gmail.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="ltr"><div dir="ltr">Dears<div><br></div><div>I'm having a problem regarding a high availability setup on Microsoft Azure since PG Pool high availability depends on the existence of Virtual IP, which simply doesn't work on Microsoft Azure and is not visible except on the same virtual machine.</div><div><br></div><div>I found the example for Amazon AWS below, but I don't like the solution that it's a public IP visible to the internet, and we can't accept that for security reasons, also I didn't find a comparable example on Microsoft Azure too.</div><div><br></div><div><a href="https://www.pgpool.net/docs/latest/en/html/example-aws.html" target="_blank">https://www.pgpool.net/docs/latest/en/html/example-aws.html</a></div><div><br></div><div>Also in addition to that I tried to disregard the virtual IP and configure my application using both internal IPs of both pg pool servers, but as per my observation I found the following:</div><div><br></div><div>1- Double the needed connections are opened to both backend application servers, which shouldn't be good to Postgres servers performance according to "PostgreSQL High Availability Cookbook" ( that Postgres performance is acceptable when the number of open connection is ~ triple the number of cores)</div><div>2- Also I find that both pg pool servers behave as Active/Active and can be used at the same time.</div><div><br></div><div>So what is the recommended solution in this case?</div><div><div><br></div>-- <br><div dir="ltr" class="gmail-m_7157476996653936255gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Shereef Sakr<br>------------------------------------------------------------------<br></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><div><br></div>-- <br><div dir="ltr" class="gmail_signature"><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr"><div><div dir="ltr">Shereef Sakr<br>Software Development Manager<br>Esri Northeast Africa<br>------------------------------------------------------------------<br>Personal Blog: <a href="http://shereefsakr.blogspot.com" target="_blank">shereefsakr.blogspot.com</a><br>Technical Blog: <a href="http://fci-h.blogspot.com" target="_blank">fci-h.blogspot.com</a></div></div></div></div></div></div></div></div>