Thread

1. Facing issue while installing postgres14 on rhel 9.2 machine

   Sohan Wadalkar <sohan.wadalkar@gmail.com> — 2024-04-11T17:15:49Z

   Hi Team,
   
   Trying to deploy Postgres 14 on rhel 9.2 azure vm.
   Azure vm details:-
   SKU_TYPE :- RHEL
   IMAGE_VERSION :- 9.2.2024022012
   publisher :- REDHAT
   
   Steps which are following as per this document
   https://www.postgresql.org/download/linux/redhat/
   
   But while executing this step getting following error message
   
   sudo dnf -qy module disable postgresql
   
   Importing GPG key 0x08B40D20:
   Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org
   >"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org
   >"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org
   >"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org
   >"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org
   >"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org
   >"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Error: Failed to download metadata for repo 'pgdg-common-debuginfo': Cannot
   download repomd.xml: Cannot download repodata/repomd.xml: All mirrors were
   tried
   
   NOTE:-
   Till 8 April 2024 it was working fine, as per the new update in rpm file we
   are facing an above issue.(
   https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/ last
   change on 9 April 2024)
   
   Thanks,
   Sohan
   

2. Re: Facing issue while installing postgres14 on rhel 9.2 machine

   Devrim Gündüz <devrim@gunduz.org> — 2024-04-12T08:29:42Z

   Hi,
   
   On Thu, 2024-04-11 at 22:45 +0530, Sohan Wadalkar wrote:
   > From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   > Error: Failed to download metadata for repo 'pgdg-common-debuginfo':
   > Cannot download repomd.xml: Cannot download repodata/repomd.xml: All
   > mirrors were tried
   > 
   > NOTE:-
   > Till 8 April 2024 it was working fine, as per the new update in rpm
   > file we are facing an above issue.(
   > https://download.postgresql.org/pub/repos/yum/reporpms/EL-9-x86_64/ la
   > st
   > change on 9 April 2024)
   
   Are you sure that you are using at least 42.0-42 version of the repo
   RPM? I broke it on that specific day for an hour or so, then released a
   new RPM to fix it (42.0-42).
   
   FWIW the last release is 42.0-43 which I released about 30 mins ago. The
   previous version even fixes your problem  -- tested on 2 separate
   instances today with -42:
   
   # dnf -qy module disable postgresql
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   Importing GPG key 0x08B40D20:
    Userid     : "PostgreSQL RPM Repository <pgsql-pkg-yum@lists.postgresql.org>"
    Fingerprint: D4BF 08AE 67A0 B4C7 A1DB CCD2 40BC A2B4 08B4 0D20
    From       : /etc/pki/rpm-gpg/PGDG-RPM-GPG-KEY-RHEL
   
   Regards,
   
   -- 
   Devrim Gündüz
   Open Source Solution Architect, PostgreSQL Major Contributor
   Twitter: @DevrimGunduz , @DevrimGunduzTR