Issue in postgresql installation - Target version Postgresql 14. - Mailing list pgsql-hackers

From kavya chandren
Subject Issue in postgresql installation - Target version Postgresql 14.
Date
Msg-id CAPXWBGZPDYEV8Rrg5ns7j-EXrVm1Djns46bWq0r5gVxHsUwLbA@mail.gmail.com
Whole thread Raw
Responses Re: Issue in postgresql installation - Target version Postgresql 14.
List pgsql-hackers
Dear team,

We are facing issues during installation of postgresql at our environment.

This command completed with no errors.....

dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-8-x86_64/pgdg-redhat-repo-latest.noarch.rpm

Then we ran this command....

dnf install postgresql14-server-14.5-1PGDG.rhel8.x86_64.rpm postgresql14-14.5-1PGDG.rhel8.x86_64.rpm postgresql14-libs-14.5-1PGDG.rhel8.x86_64.rpm

and got the following messages

Updating Subscription Management repositories.

This system is registered to Red Hat Subscription Management, but is not receiving updates. You can use subscription-manager to assign subscriptions.

Last metadata expiration check: 0:02:07 ago on Thu 18 Aug 2022 03:12:32 PM EDT.
Error:
 Problem 1: cannot install the best candidate for the job
  - nothing provides lz4 needed by postgresql14-14.5-1PGDG.rhel8.x86_64
 Problem 2: package postgresql14-server-14.5-1PGDG.rhel8.x86_64 requires postgresql14(x86-64) = 14.5-1PGDG.rhel8, but none of the providers can be installed
  - cannot install the best candidate for the job
  - nothing provides lz4 needed by postgresql14-14.5-1PGDG.rhel8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate packages)
Again tried `dnf update` and `dnf install -y postgresql14-server` , but still stuck with below error:


# dnf update
Updating Subscription Management repositories.

This system is registered to Red Hat Subscription Management, but is not receiving updates. You can useions.

Last metadata expiration check: 0:42:29 ago on Thu 18 Aug 2022 04:42:25 PM EDT.
Dependencies resolved.
=======================================================================================================
 Package                                   Architecture                Version
=======================================================================================================
Upgrading:
 pg_qualstats_13                           x86_64                      2.0.4-1.rhel8
 postgresql13                              x86_64                      13.8-1PGDG.rhel8
 postgresql13-contrib                      x86_64                      13.8-1PGDG.rhel8
 postgresql13-libs                         x86_64                      13.8-1PGDG.rhel8
 postgresql13-server                       x86_64                      13.8-1PGDG.rhel8

Transaction Summary
=======================================================================================================
Upgrade  5 Packages

Total download size: 8.1 M
Is this ok [y/N]: y
Downloading Packages:
(1/5): pg_qualstats_13-2.0.4-1.rhel8.x86_64.rpm
(2/5): postgresql13-contrib-13.8-1PGDG.rhel8.x86_64.rpm
(3/5): postgresql13-13.8-1PGDG.rhel8.x86_64.rpm
(4/5): postgresql13-libs-13.8-1PGDG.rhel8.x86_64.rpm
(5/5): postgresql13-server-13.8-1PGDG.rhel8.x86_64.rpm
-------------------------------------------------------------------------------------------------------
Total
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
  Preparing        :
  Running scriptlet: postgresql13-libs-13.8-1PGDG.rhel8.x86_64
  Upgrading        : postgresql13-libs-13.8-1PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-libs-13.8-1PGDG.rhel8.x86_64
  Upgrading        : postgresql13-13.8-1PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-13.8-1PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-server-13.8-1PGDG.rhel8.x86_64
  Upgrading        : postgresql13-server-13.8-1PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-server-13.8-1PGDG.rhel8.x86_64
  Upgrading        : pg_qualstats_13-2.0.4-1.rhel8.x86_64
  Running scriptlet: pg_qualstats_13-2.0.4-1.rhel8.x86_64
  Upgrading        : postgresql13-contrib-13.8-1PGDG.rhel8.x86_64
  Cleanup          : postgresql13-contrib-13.1-3PGDG.rhel8.x86_64
  Cleanup          : pg_qualstats_13-2.0.3-1.rhel8.x86_64
  Running scriptlet: pg_qualstats_13-2.0.3-1.rhel8.x86_64
  Running scriptlet: postgresql13-server-13.1-3PGDG.rhel8.x86_64
  Cleanup          : postgresql13-server-13.1-3PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-server-13.1-3PGDG.rhel8.x86_64
  Cleanup          : postgresql13-13.1-3PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-13.1-3PGDG.rhel8.x86_64
  Cleanup          : postgresql13-libs-13.1-3PGDG.rhel8.x86_64
  Running scriptlet: postgresql13-libs-13.1-3PGDG.rhel8.x86_64
  Verifying        : pg_qualstats_13-2.0.4-1.rhel8.x86_64
  Verifying        : pg_qualstats_13-2.0.3-1.rhel8.x86_64
  Verifying        : postgresql13-13.8-1PGDG.rhel8.x86_64
  Verifying        : postgresql13-13.1-3PGDG.rhel8.x86_64
  Verifying        : postgresql13-contrib-13.8-1PGDG.rhel8.x86_64
  Verifying        : postgresql13-contrib-13.1-3PGDG.rhel8.x86_64
  Verifying        : postgresql13-libs-13.8-1PGDG.rhel8.x86_64
  Verifying        : postgresql13-libs-13.1-3PGDG.rhel8.x86_64
  Verifying        : postgresql13-server-13.8-1PGDG.rhel8.x86_64
  Verifying        : postgresql13-server-13.1-3PGDG.rhel8.x86_64
Installed products updated.

Upgraded:
  pg_qualstats_13-2.0.4-1.rhel8.x86_64          postgresql13-13.8-1PGDG.rhel8.x86_64            postgre
  postgresql13-libs-13.8-1PGDG.rhel8.x86_64     postgresql13-server-13.8-1PGDG.rhel8.x86_64

Complete!

 


# dnf install -y postgresql14-server
Updating Subscription Management repositories.

This system is registered to Red Hat Subscription Management, but is not receiving updates. You can useions.

Last metadata expiration check: 0:42:56 ago on Thu 18 Aug 2022 04:42:25 PM EDT.
Error:
 Problem: package postgresql14-server-14.5-1PGDG.rhel8.x86_64 requires postgresql14(x86-64) = 14.5-1PGD installed
  - cannot install the best candidate for the job
  - nothing provides lz4 needed by postgresql14-14.5-1PGDG.rhel8.x86_64
(try to add '--skip-broken' to skip uninstallable packages or '--nobest' to use not only best candidate

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: logical decoding and replication of sequences, take 2
Next
From: Thomas Munro
Date:
Subject: Re: s390x builds on buildfarm