Thread: 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