Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQ78K-00Ga2y-1a for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 17 Jan 2024 14:43:13 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rQ78J-00DfiJ-0j for pgsql-pkg-yum@arkaria.postgresql.org; Wed, 17 Jan 2024 14:43:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQ4Ov-00CqrQ-9B for pgsql-pkg-yum@lists.postgresql.org; Wed, 17 Jan 2024 11:48:09 +0000 Received: from webmail.firebrno.cz ([195.113.171.154]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rQ4Or-001ypQ-Gw for pgsql-pkg-yum@lists.postgresql.org; Wed, 17 Jan 2024 11:48:08 +0000 DKIM-Signature: a=rsa-sha256; t=1705492082; x=1706096882; s=HZSJmK; d=firebrno.cz; c=relaxed/relaxed; v=1; bh=LKfWDPRWim5N4SGs/UAcwWPM0K53BTFTW9NJobYINsA=; h=From:Reply-To:Subject:Date:Message-ID:To:MIME-Version:Content-Type; b=9vVY7VrvqxxsJfF1tbEfLKNHwkwd3XX+3vN6v18EqhqWaDYVRcGk2e3HgaH9Pupc6XwGYxebxoKZFtpA3IEylCDPSIiwpCkddmZWyTngrNOlDJUY57Hyvb76M6KYgCzGQRqxI3nx8ocOvCaMxE3jr7yCEfn8ZajGGZJQ8B4dDbg= Received: from [192.168.10.31] by webmail.firebrno.cz (13.0.3 build 10 RHEL7 x64) with ASMTP id 202401171248019881 for ; Wed, 17 Jan 2024 12:48:01 +0100 Content-Type: multipart/alternative; boundary="------------Pju50majp4Ljwe0cKyeFLzVn" Message-ID: Date: Wed, 17 Jan 2024 12:47:56 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Reply-To: jiri.pridal@firebrno.cz Content-Language: cs To: pgsql-pkg-yum@lists.postgresql.org From: Jiri Pridal Subject: failed to update postgresql on Linux Oracle8 Organization: HZS JmK X-CTCH: RefID="str=0001.0A702F17.65A7BE72.0008,ss=1,re=0.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0"; Spam="Unknown"; VOD="Unknown" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------Pju50majp4Ljwe0cKyeFLzVn Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Hello, I have a problem with updating PG on Linux Oracle 8 I found the page https://yum.postgresql.org/news/pgdg-rpm-repo-gpg-key-update/ So reason is clear. Looks like the same problem exists in Oracle Linux 8, although it is not among the affected ones. I cannot get correct key for repository pgdg_common [root@postgresql rpm-gpg]# yum clean all 32 files removed [root@postgresql rpm-gpg]# yum check-update Oracle Linux 8 EPEL Packages for Development (x86_64) 7.4 MB/s |  60 MB     00:08 Oracle Linux 8 EPEL Modular Packages for Development (x86_64) 1.7 MB/s | 322 kB     00:00 Oracle Linux 8 BaseOS Latest (x86_64) 9.9 MB/s |  68 MB     00:06 Oracle Linux 8 Application Stream (x86_64) 9.8 MB/s |  53 MB     00:05 PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 807  B/s | 659  B     00:00 PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 1.0 MB/s | 1.7 kB     00:00 PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 1.1 kB/s | 659  B     00:00 Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG signature verification error: Bad GPG signature [root@postgresql rpm-gpg]# gpg --list-keys --homedir /var/cache/dnf/pgdg-common-38b6c5045045f841/pubring/ gpg: WARNING: unsafe permissions on homedir '/var/cache/dnf/pgdg-common-38b6c5045045f841/pubring' /var/cache/dnf/pgdg-common-38b6c5045045f841/pubring/pubring.kbx --------------------------------------------------------------- pub   dsa1024 2008-01-08 [SCA]       68C9E2B91A37D136FE74D1761F16D2E1442DF0F8 uid           [ unknown] PostgreSQL RPM Building Project sub   elg2048 2008-01-08 [E] [root@postgresql rpm-gpg]# gpg --homedir /var/cache/dnf/pgdg-common-38b6c5045045f841/pubring --delete-key 68C9E2B91A37D136FE74D1761F16D2E1442DF0F8 gpg: WARNING: unsafe permissions on homedir '/var/cache/dnf/pgdg-common-38b6c5045045f841/pubring' gpg (GnuPG) 2.2.20; Copyright (C) 2020 Free Software Foundation, Inc. This is free software: you are free to change and redistribute it. There is NO WARRANTY, to the extent permitted by law. pub  dsa1024/1F16D2E1442DF0F8 2008-01-08 PostgreSQL RPM Building Project Delete this key from the keyring? (y/N) y [root@postgresql rpm-gpg]# yum check-update PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 2.1 kB/s | 659  B     00:00 PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 1.2 MB/s | 1.7 kB     00:00 Importing GPG key 0x442DF0F8:  Userid     : "PostgreSQL RPM Building Project "  Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8  From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG Is this ok [y/N]: n PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64 1.2 kB/s | 659  B     00:00 Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG signature verification error: Bad GPG signature [root@postgresql rpm-gpg]# uname -a Linux postgresql.firebrno.cz 5.4.17-2136.317.5.3.el8uek.x86_64 #2 SMP Thu Mar 16 19:09:30 PDT 2023 x86_64 x86_64 x86_64 GNU/Linux [root@postgresql rpm-gpg]# cat /etc/*release oracle-release  os-release      redhat-release  system-release [root@postgresql rpm-gpg]# cat /etc/*release Oracle Linux Server release 8.9 NAME="Oracle Linux Server" VERSION="8.9" ID="ol" ID_LIKE="fedora" VARIANT="Server" VARIANT_ID="server" VERSION_ID="8.9" PLATFORM_ID="platform:el8" PRETTY_NAME="Oracle Linux Server 8.9" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:8:9:server" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://github.com/oracle/oracle-linux" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8" ORACLE_BUGZILLA_PRODUCT_VERSION=8.9 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=8.9 Red Hat Enterprise Linux release 8.9 (Ootpa) Oracle Linux Server release 8.9 Which one key is correct for my OS? https://download.postgresql.org/pub/repos/yum/keys/ thanks JP -- kpt. Bc. Jiří Přidal technik KIS - informační služba Hasičský záchranný sbor Jihomoravského kraje krajské ředitelství Zubatého 1, 614 00 Brno tel.: +420 950 630 136 mob.: +420 724 117 857 e-mail: jiri.pridal@hzscr.cz web: www.firebrno.c --------------Pju50majp4Ljwe0cKyeFLzVn Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Hello,

I have a problem with updating PG on Linux Oracle 8
I found the page https://yum.postgresql.org/news/pgdg-rpm-repo-gpg-key-update/
So reason is clear.
Looks like the same problem exists in Oracle Linux 8, although it is not among the affected ones.
I cannot get correct key for repository pgdg_common

[root@postgresql rpm-gpg]# yum clean all
32 files removed
[root@postgresql rpm-gpg]# yum check-update
Oracle Linux 8 EPEL Packages for Development (x86_64)                                                                                                                           7.4 MB/s |  60 MB     00:08
Oracle Linux 8 EPEL Modular Packages for Development (x86_64)                                                                                                                   1.7 MB/s | 322 kB     00:00
Oracle Linux 8 BaseOS Latest (x86_64)                                                                                                                                           9.9 MB/s |  68 MB     00:06
Oracle Linux 8 Application Stream (x86_64)                                                                                                                                      9.8 MB/s |  53 MB     00:05
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                                                                                                              807  B/s | 659  B     00:00
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                                                                                                              1.0 MB/s | 1.7 kB     00:00
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                                                                                                              1.1 kB/s | 659  B     00:00
Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG signature verification error: Bad GPG signature
[root@postgresql rpm-gpg]# gpg --list-keys --homedir /var/cache/dnf/pgdg-common-38b6c5045045f841/pubring/
gpg: WARNING: unsafe permissions on homedir '/var/cache/dnf/pgdg-common-38b6c5045045f841/pubring'
/var/cache/dnf/pgdg-common-38b6c5045045f841/pubring/pubring.kbx
---------------------------------------------------------------
pub   dsa1024 2008-01-08 [SCA]
      68C9E2B91A37D136FE74D1761F16D2E1442DF0F8
uid           [ unknown] PostgreSQL RPM Building Project <pgsqlrpms-hackers@pgfoundry.org>
sub   elg2048 2008-01-08 [E]

[root@postgresql rpm-gpg]# gpg --homedir /var/cache/dnf/pgdg-common-38b6c5045045f841/pubring --delete-key 68C9E2B91A37D136FE74D1761F16D2E1442DF0F8
gpg: WARNING: unsafe permissions on homedir '/var/cache/dnf/pgdg-common-38b6c5045045f841/pubring'
gpg (GnuPG) 2.2.20; Copyright (C) 2020 Free Software Foundation, Inc.
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.


pub  dsa1024/1F16D2E1442DF0F8 2008-01-08 PostgreSQL RPM Building Project <pgsqlrpms-hackers@pgfoundry.org>

Delete this key from the keyring? (y/N) y
[root@postgresql rpm-gpg]# yum check-update
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                                                                                                              2.1 kB/s | 659  B     00:00
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                                                                                                              1.2 MB/s | 1.7 kB     00:00
Importing GPG key 0x442DF0F8:
 Userid     : "PostgreSQL RPM Building Project <pgsqlrpms-hackers@pgfoundry.org>"
 Fingerprint: 68C9 E2B9 1A37 D136 FE74 D176 1F16 D2E1 442D F0F8
 From       : /etc/pki/rpm-gpg/RPM-GPG-KEY-PGDG
Is this ok [y/N]: n
PostgreSQL common RPMs for RHEL / Rocky 8 - x86_64                                                                                                                              1.2 kB/s | 659  B     00:00
Error: Failed to download metadata for repo 'pgdg-common': repomd.xml GPG signature verification error: Bad GPG signature

[root@postgresql rpm-gpg]# uname -a
Linux postgresql.firebrno.cz 5.4.17-2136.317.5.3.el8uek.x86_64 #2 SMP Thu Mar 16 19:09:30 PDT 2023 x86_64 x86_64 x86_64 GNU/Linux
[root@postgresql rpm-gpg]# cat /etc/*release
oracle-release  os-release      redhat-release  system-release
[root@postgresql rpm-gpg]# cat /etc/*release
Oracle Linux Server release 8.9
NAME="Oracle Linux Server"
VERSION="8.9"
ID="ol"
ID_LIKE="fedora"
VARIANT="Server"
VARIANT_ID="server"
VERSION_ID="8.9"
PLATFORM_ID="platform:el8"
PRETTY_NAME="Oracle Linux Server 8.9"
ANSI_COLOR="0;31"
CPE_NAME="cpe:/o:oracle:linux:8:9:server"
HOME_URL="https://linux.oracle.com/"
BUG_REPORT_URL="https://github.com/oracle/oracle-linux"

ORACLE_BUGZILLA_PRODUCT="Oracle Linux 8"
ORACLE_BUGZILLA_PRODUCT_VERSION=8.9
ORACLE_SUPPORT_PRODUCT="Oracle Linux"
ORACLE_SUPPORT_PRODUCT_VERSION=8.9
Red Hat Enterprise Linux release 8.9 (Ootpa)
Oracle Linux Server release 8.9


Which one key is correct for my OS?

https://download.postgresql.org/pub/repos/yum/keys/

thanks
JP

--

kpt. Bc. Jiří Přidal
technik KIS - informační služba

Hasičský záchranný sbor Jihomoravského kraje
krajské ředitelství
Zubatého 1, 614 00 Brno
tel.: +420 950 630 136
mob.: +420 724 117 857
e-mail: jiri.pridal@hzscr.cz
web: www.firebrno.c



--------------Pju50majp4Ljwe0cKyeFLzVn--