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

zam bak zam6ak at gmail.com
Tue Apr 4 01:05:04 JST 2023


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)


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



More information about the pgpool-general mailing list