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

[Nirav Bhatt]

The code that gave me the said error was this: (my server is ARM arch)

dnf install pgpool-II-pg13

On Tue, Oct 5, 2021 at 10:58 PM Nirav Bhatt <niravbhatt.cpp at gmail.com>
wrote:

> Thanks again.
>
> I managed to switch to *CentOS **7.9.2009* (source image: ami-0db02f65655518c52
> from https://wiki.centos.org/Cloud/AWS)
>
> $>cat /etc/centos-release
> CentOS Linux release 7.9.2009 (AltArch)
>
> NAME="CentOS Linux"
> VERSION="7 (AltArch)"
> ID="centos"
> ID_LIKE="rhel fedora"
> VERSION_ID="7"
> PRETTY_NAME="CentOS Linux 7 (AltArch)"
> CENTOS_MANTISBT_PROJECT="CentOS-7"
> CENTOS_MANTISBT_PROJECT_VERSION="7"
> REDHAT_SUPPORT_PRODUCT="centos"
> REDHAT_SUPPORT_PRODUCT_VERSION="7"
>
> *Then, I run:*
>
> dnf/yum install
> https://www.pgpool.net/yum/rpms/4.2/redhat/rhel-7-x86_64/pgpool-II-release-4.2-1.noarch.rpm
>
> which results in:
>
> pgpool-II 4.2 7 - aarch64
>
>
> Failed to synchronize cache for repo 'pgpool42', ignoring this repo.
> Last metadata expiration check: 3:05:20 ago on Tue 05 Oct 2021 04:49:01 PM
> UTC.
> No match for argument: pgpool-II-pg13
> Error: Unable to find a match: pgpool-II-pg13
>
> Where am I wrong?
>
> Thanks,
> -Nirav
>
> On Tue, Oct 5, 2021 at 4:49 AM Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>
>> > Thank you so much for quick reply!
>>
>> You are welcome.
>>
>> > 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?
>>
>> Yes, at least from funcionality's point of view. Pgpool-II does not
>> rely on specific distro's feature (if any).
>>
>> > 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)?
>>
>> I am not in the position of talking about Ubuntu distribution
>> activities. So I don't know why they only release 4.1.4, and no 4.2.x
>> at this point.
>>
>> > 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.
>>
>> Another possibility is PGDB packages. This project is driven by
>> PostgreSQL developers/contributors and is mainly aiming to provide the
>> latest packages of PostgreSQL. The packages also include a few
>> PostgreSQL related projects, including pgpool2.
>>
>> https://www.postgresql.org/download/linux/ubuntu/
>> https://wiki.postgresql.org/wiki/Apt
>>
>> I have looked into the packages list but I only found pgpool2 4.1.4 is
>> the latest. I am subscribed to the pgsql-pkg-debian at postgresql.org and
>> sending a question whether they have a plan to provide more recent
>> versions of pgpool2 packages.
>>
>> https://www.postgresql.org/download/linux/ubuntu/
>> --
>> 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/20211005/042ddb05/attachment.htm>