[pgpool-general: 7740] Re: Pgpool-II on Ubuntu - older Pgpool version is OK?

[Nirav Bhatt]

Thank you so much for quick reply!

Your answer relieves me at least from the worries about Ubuntu in
production.

However, I still did not get 2 things:

- Is Pgpool (4.1.4 - the one I am using
<https://www.pgpool.net/docs/42/en/html/release-4-1-4.html>) compatible
with Postgresql 13 on Ubuntu? I have been focusing solely on configuration
part and did not test anything, also did not check the compatibility in the
first place, nor I can find any sources for it.

- Is 4.1.4 the last version supported for Ubuntu? I checked here
<https://packages.ubuntu.com/search?keywords=pgpool2&searchon=names&suite=all&section=all>,
and it seems the case.
What are the risks if I go with Ubuntu if let's say it doesn't get the
latest pgpool2 (which is 4.2.5)?

Maybe I am missing some other source of installing latest Pgpool2 on
Ubuntu? I am very new to Linux distro world as well. If possible, please
enlighten.

-Nirav

On Mon, Oct 4, 2021 at 2:44 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:

> Welcome to the Pgpool-II community!
>
> > A big hello from newbie to the Pgpool community! I took a long time
> setting
> > up the Pgpool-II high availability on my postgres 13 cluster on Ubuntu
> > machines. I kept following this great example
> > <https://www.pgpool.net/docs/latest/en/html/example-cluster.html>, while
> > converting the CentOS tutorial to Ubuntu equivalent.
> > I am working on AWS EC2. However, after 80% config done, I realized I was
> > using an older version of Pgpool-II(*4.1.4-3*) against the tutorial
> version
> > that is *4.2.5*.
> >
> > While I quickly found out the tutorial for my version
> > <https://www.pgpool.net/docs/41/en/html/example-cluster.html>(4.1.x),
> there
> > are bigger questions in my mind:
> >
> > *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)?*
> >
> > I ran apt-cache policy pgpool2 on my *Ubuntu 20.04.2 LTS* Ec2 instance:
> >
> > *Installed: 4.1.4-3.pgdg20.04+2*
> >
> > I do not find much on Pgpool website about what are their plans for
> Ubuntu,
> > so I wonder if I made the right choice.
>
> I regularly use Ubuntu 20 and 18 for pgpool development works. So
> basically I see no problem with Ubuntu to use pgpool.
>
> There's only one problem, however. When I try to build pgpool
> documents I get segault from jade (an SGML compiler) on Ubuntu 20. 18
> is fine. (I already filed this to Ubuntu developer's community but so
> far I got no response). But this is only an issue for developers, not
> for users.
>
> > *2 - Should I stick to Ubuntu (and hence with Pgpool 4.1 for now) or
> should
> > I switch to RHEL/CentOS?*
>
> So I see no problem with using pgpool on Ubuntu except one thing above.
>
> > 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.
>
> Of course Pgpool-II is an open source software and free to use.
>
> > 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.
> >
> > (so far I was believing that all in the Linux world is free but I could
> be
> > wrong given all the distros being offered on AWS
> > <https://aws.amazon.com/mp/linux/>)
> >
> >
> > Thank you for the great tool and the community support!
>
> You are welcome.
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20211004/d0826859/attachment.htm>