Re: Issue in postgresql installation - Target version Postgresql 14.

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(at)momjian(dot)us> wrote:

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