<div dir="ltr"><div class="gmail-votecell gmail-post-layout--left" style="margin:0px;padding:0px 16px 0px 0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:top;box-sizing:inherit;width:auto;color:rgb(35,38,41)"><div class="gmail-js-voting-container gmail-d-flex gmail-jc-center gmail-fd-column gmail-ai-stretch gmail-gs4 gmail-fc-black-200" style="padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;display:flex"><div class="gmail-js-vote-count gmail-flex--item gmail-d-flex gmail-fd-column gmail-ai-center gmail-fc-black-500 gmail-fs-title" style="margin:2px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;display:flex"><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit"><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">A big hello from newbie to the Pgpool community! </span><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">I took a long time setting up the Pgpool-II high availability on my postgres 13 cluster on Ubuntu machines. I kept following </span><a href="https://www.pgpool.net/docs/latest/en/html/example-cluster.html" rel="nofollow noreferrer" style="font-style:inherit;font-variant:inherit;font-weight:inherit;font-family:arial,sans-serif;margin:0px;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;display:inline!important">this great example</a><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">, while converting the CentOS tutorial to Ubuntu equivalent. </span></span><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit"><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif"><br></span></span><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit"><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">I am working on AWS EC2. </span><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">However, after 80% config done, I realized I was using an older version of Pgpool-II(</span><strong style="font-style:inherit;font-variant:inherit;font-family:arial,sans-serif;margin:0px;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">4.1.4-3</strong><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">) against the tutorial version that is</span><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif"> </span><strong style="font-style:inherit;font-variant:inherit;font-family:arial,sans-serif;margin:0px;padding:0px;border:0px;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">4.2.5</strong><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit;font-family:arial,sans-serif">.</span><br></span><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit"><span style="font-style:inherit;font-variant-ligatures:inherit;font-variant-caps:inherit;font-weight:inherit"><font face="arial, sans-serif"><br></font></span></span></div></div></div><div class="gmail-postcell gmail-post-layout--right" style="margin:0px;padding:0px 16px 0px 0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:top;box-sizing:inherit;width:auto;min-width:0px;color:rgb(35,38,41)"><div class="gmail-s-prose gmail-js-post-body" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;vertical-align:baseline;box-sizing:inherit;width:658px"><p style="font-weight:inherit;margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif">While I quickly found out the tutorial for <a href="https://www.pgpool.net/docs/41/en/html/example-cluster.html" rel="nofollow noreferrer" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">my version</a>(4.1.x), there are bigger questions in my mind:</font></p><p style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><b><font face="arial, sans-serif">1 - Is Ubuntu a good choice for a Postgres Database cluster compared to CentOS/RHEL wherein Pgpool-II is ahead (latest is 4.2.5)?</font></b></p><p style="font-weight:inherit;margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif">I ran <code style="margin:0px;padding:2px 4px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;white-space:pre-wrap;border-radius:3px">apt-cache policy pgpool2</code> on my <strong style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">Ubuntu 20.04.2 LTS</strong> Ec2 instance:</font></p><pre class="gmail-lang-sql gmail-s-code-block" style="margin-top:0px;padding:12px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:1.30769;vertical-align:baseline;box-sizing:inherit;width:auto;max-height:600px;overflow:auto;border-radius:5px"><code class="gmail-hljs gmail-language-sql" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;background-color:transparent;white-space:inherit"><font face="arial, sans-serif" style=""><b>Installed: <span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">4.1</span><span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">.4</span><span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">-3.</span>pgdg20<span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">.04</span><span class="gmail-hljs-operator" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">+</span><span class="gmail-hljs-number" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">2</span></b></font></code></pre><p style="font-weight:inherit;margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif">I do not find much on Pgpool website about what are their plans for Ubuntu, so I wonder if I made the right choice.</font></p><p style="margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><b><font face="arial, sans-serif">2 - Should I stick to Ubuntu (and hence with Pgpool 4.1 for now) or should I switch to RHEL/CentOS?</font></b></p><p style="font-weight:inherit;margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif">Pgpool aside, I do not know if there are any OS licensing cost implications of this (I am on AWS EC2 instances), as I am new to Linux world as well.</font></p><p style="font-weight:inherit;margin-top:0px;margin-right:0px;margin-left:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif">Since switching also requires heavy work I did in setting up so far, please enlighten me if I am risking anything by keeping my Ubuntu intact.</font></p><p style="font-weight:inherit;margin:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif">(so far I was believing that all in the Linux world is free but I could be wrong given <a href="https://aws.amazon.com/mp/linux/" rel="nofollow noreferrer" style="margin:0px;padding:0px;border:0px;font-style:inherit;font-variant:inherit;font-weight:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit">all the distros being offered on AWS</a>)</font></p><p style="font-weight:inherit;margin:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif"><br></font></p><p style="font-weight:inherit;margin:0px;padding:0px;border:0px;font-variant-numeric:inherit;font-variant-east-asian:inherit;font-stretch:inherit;line-height:inherit;vertical-align:baseline;box-sizing:inherit;clear:both"><font face="arial, sans-serif" style="">Thank you for the great tool and the community support!</font></p></div></div></div>