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

[zam bak]

On Wed, Apr 5, 2023 at 2:46 PM zam bak <zam6ak at gmail.com> wrote:
>
> 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?

This command seems to "pull in" matching versions:
dnf install --disablerepo="*" --enablerepo="appstream,pgpool44"
pgpool-II-pg14 pgpool-II-pg14-extensions

Maybe this is correct?

>
> >
> > > 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/