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

[Bo Peng]

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

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