failed to update postgresql on Linux Oracle8

Поиск
Список
Период
Сортировка
От Jiri Pridal
Тема failed to update postgresql on Linux Oracle8
Дата
Msg-id c62ed9db-327e-4dad-ba04-73d527a61621@firebrno.cz
обсуждение исходный текст
Список pgsql-pkg-yum
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

В списке pgsql-pkg-yum по дате отправления:

Предыдущее
От: Devrim Gündüz
Дата:
Сообщение: Re: Missed python3-psycopg2* packages for ppc64le
Следующее
От: Danilo Vivenes
Дата:
Сообщение: Repositories Postgresql-11