Issue in postgresql installation - Target version Postgresql 14.

First, this is not an appropriate question for hackers. Second, this is
a question for the package manager where you got the pre-built software.

---------------------------------------------------------------------------

On Fri, Aug 19, 2022 at 03:39:29AM +0530, kavya chandren wrote:

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

--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com

Indecision is a decision. Inaction is an action. Mark Batterson

Dear Bruce Momjian,

Thanks for clarifying, got the issue resolved with installation of lz4
independently.

On Fri, Aug 19, 2022 at 9:16 PM Bruce Momjian <bruce@momjian.us> wrote: