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

[Bo Peng]

Hello,

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

If you want to install pgpool-II-pg14, you need to
explicitly specify the major version.
 
> >
> > >
> > > > 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/


-- 
Bo Peng <pengbo at sraoss.co.jp>
SRA OSS LLC
https://www.sraoss.co.jp/