[pgpool-general: 8718] Re: PgPool-II v4.4 extension package for PostgreSQL 14 requires PostgreSQL 15 ???

[zam bak]

On Tue, Apr 4, 2023 at 9:33 PM Bo Peng <pengbo at sraoss.co.jp> wrote:
>
> Hello,
>
> > Hello
> >
> > We are trying to install PgPool-II extensions for PostgreSQL as per docs
> > https://www.pgpool.net/docs/44/en/html/install-rpm.html#INSTALLING-RPM
> >
> > We have separate servers for pgpool and postgresql (primary + 1 replica)
> > Our environment is
> > * Rocky Linux v8
> > * PostgreSQL v14.7
> > * PgPool v4.4
> >
> > On postgres servers, after installing PostgreSQL 14 using PGDG
> > repositories and trying to install pgpool extensions package I get
> > following error:
> >
> > dnf install pgpool-II-pg14-extensions
> >
> > Last metadata expiration check: 0:01:02 ago on Mon 03 Apr 2023 11:46:53 AM EDT.
> > Error:
> >  Problem: package pgpool-II-pg14-extensions-4.4.2-1.rhel8.x86_64
> > requires pgpool-II-pcp, but none of the providers can be installed
> >   - cannot install the best candidate for the job
> >   - nothing provides postgresql15-server needed by
> > pgpool-II-pcp-4.4.1-1.rhel8.x86_64
> >   - nothing provides postgresql15-server needed by
> > pgpool-II-pcp-4.4.2-1.rhel8.x86_64
> > (try to add '--skip-broken' to skip uninstallable packages or
> > '--nobest' to use not only best candidate packages)
>
> If you want to install Pgpool-II from Pgpool-II repository,
> you need to disable PGDG repository.
>
> Try the following command:
>
>   dnf install --disablerepo=pgdg* pgpool-II-pg14-extensions

OK, this was not obvious because PostgreSQL gets installed from one of
the PGDG repos (in my case PostgreSQL 14 from "pgdg14" repository)
However, the above command wants to install 2 dependencies
1. libmemcached-libs  (from "appstream" repo)
2. pgpool-II-pg11        (from "pgpool44" repo)

I understand the need for libmemcached-libs, but why do pgpool
extensions for PostgreSQL 14 depend on PgPool for version 11 of
Postgres?
Is that normal or?

>
> > 1. Why does the package "pgpool-II-pg14-extensions" depend on
> > "postgresql15-server"? Shouldn't it depend on PostgreSQL 14 which is
> > what I have installed...
> >
> > I know I can enable "pgdg15" repo so that DNF can find the
> > "postgresql15-server" package but I feel this is not a good workaround
> > as I don't want to install v15 PostgreSQL bits on a PostgreSQL v14
> > production server. Having multiple PostgreSQL versions installed can
> > cause issues because latest version overtakes
> > /etc/alternatives/pgsql-* and has to be "relinked back" to v14.
> >
> > Here is what packages are currently installed on the system and what
> > repositores are enabled:
> >
> > dnf list --installed | grep -i -E "^(postgres|pgpool|pg)+.*"
> > pgdg-redhat-repo.noarch                  42.0-32
> >          @@commandline
> > pgpool-II-release.noarch                 4.4-1
> >          @@commandline
> > postgresql14.x86_64                      14.7-1PGDG.rhel8
> >          @pgdg14
> > postgresql14-contrib.x86_64              14.7-1PGDG.rhel8
> >          @pgdg14
> > postgresql14-libs.x86_64                 14.7-1PGDG.rhel8
> >          @pgdg14
> > postgresql14-server.x86_64               14.7-1PGDG.rhel8
> >          @pgdg14
> >
> >
> > dnf repolist enabled
> > repo id
> >      repo name
> > appstream
> >      Rocky Linux 8 - AppStream
> > baseos
> >      Rocky Linux 8 - BaseOS
> > extras
> >      Rocky Linux 8 - Extras
> > pgdg-common
> >      PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64
> > pgdg14
> >      PostgreSQL 14 for RHEL / Rocky 8 - x86_64
> > pgpool44
> >      pgpool-II 4.4 8 - x86_64
> >
> >
> >
> >
> > Thanks
> > Z...
> > _______________________________________________
> > pgpool-general mailing list
> > pgpool-general at pgpool.net
> > http://www.pgpool.net/mailman/listinfo/pgpool-general
>
>
> --
> Bo Peng <pengbo at sraoss.co.jp>
> SRA OSS LLC
> https://www.sraoss.co.jp/