Re: 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(at)momjian(dot)us> https://momjian.us
EDB https://enterprisedb.com

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