BUG #16948: Packages not signed - Mailing list pgsql-bugs

From PG Bug reporting form
Subject BUG #16948: Packages not signed
Date
Msg-id 16948-4e66275309cea117@postgresql.org
Whole thread Raw
Responses Re: BUG #16948: Packages not signed  (Devrim Gündüz <devrim@gunduz.org>)
List pgsql-bugs
The following bug has been logged on the website:

Bug reference:      16948
Logged by:          Karsten Lenz
Email address:      karsten.lenz@dbi-services.com
PostgreSQL version: 13.2
Operating system:   SLES 15SP2
Description:

Now I've got an example with packages either signed by key with ID
1f16d2e1442df0f8 (postgres) or not signed at all. It looks like packages are
not signed anymore for the latest versions/releases.

From the Postgresql13 packages for SLES15 on
https://download.postgresql.org/pub/repos/zypp/13/suse/sles-15.2-x86_64/ ,
not all packages are singed:

SLES15_HOST:/var/cache/zypp/packages/artifactory:psqlsc-sles15-pgdg-13 # rpm
-qp --qf '%{NAME}-%{VERSION}-%{RELEASE} (a)%{SIGPGP:pgpsig}
(b)%{SIGGPG:pgpsig}\n' *.rpm
pg_qualstats_13-2.0.2-2.sles15 (a)(none) (b)DSA/SHA1, Thu Nov 12 02:29:06
2020, Key ID 1f16d2e1442df0f8
pg_stat_kcache_13-2.2.0-1.sles15 (a)(none) (b)(none)
postgresql13-13.2-1PGDG.sles15 (a)(none) (b)(none)
postgresql13-contrib-13.2-1PGDG.sles15 (a)(none) (b)(none)
postgresql13-libs-13.2-1PGDG.sles15 (a)(none) (b)(none)
postgresql13-server-13.2-1PGDG.sles15 (a)(none) (b)(none)
repmgr_13-5.2.1-2.sles15 (a)(none) (b)(none)

Whereas for Postgres11, SLES12, all packages were signed (
https://download.postgresql.org/pub/repos/zypp/11/suse/sles-12.5-x86_64/
):

SLES12_HOST:~ # rpm -qa --qf '%{NAME}-%{VERSION}-%{RELEASE}
(a)%{SIGPGP:pgpsig} (b)%{SIGGPG:pgpsig}\n' | egrep "pg_|postg|repm"
pg_qualstats11-1.0.6-1.sles12 (a)(none) (b)DSA/SHA1, Fri Nov  9 00:23:20
2018, Key ID 1f16d2e1442df0f8
postgresql11-server-11.9-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Thu Aug 13
16:02:50 2020, Key ID 1f16d2e1442df0f8
repmgr11-5.0.0-1.sles12 (a)(none) (b)DSA/SHA1, Tue Dec 10 11:19:44 2019, Key
ID 1f16d2e1442df0f8
postgresql11-contrib-11.9-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Thu Aug 13
16:02:50 2020, Key ID 1f16d2e1442df0f8
postgresql11-libs-11.9-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Thu Aug 13
16:02:50 2020, Key ID 1f16d2e1442df0f8
pg_stat_kcache11-2.1.1-1.sles12.1 (a)(none) (b)DSA/SHA1, Thu Oct 18 14:47:26
2018, Key ID 1f16d2e1442df0f8
postgresql11-11.9-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Thu Aug 13 16:02:50
2020, Key ID 1f16d2e1442df0f8

From the Postgresql11 repo for SLES12 SP5 and Postgresql13 for SLES15 SP2
I've got downloaded that last few version of postgresql1x-server rpm. Older
packages are signed, but not the latest ones:

rpm -qp --qf '%{NAME}-%{VERSION}-%{RELEASE} (a)%{SIGPGP:pgpsig}
(b)%{SIGGPG:pgpsig}\n' post*.rpm | sort
warning: postgresql11-server-11.10-1PGDG.sles12.x86_64.rpm: Header V4
DSA/SHA1 Signature, key ID 442df0f8: NOKEY
postgresql11-server-11.10-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Thu 12 Nov
2020 01:37:45 AM CET, Key ID 1f16d2e1442df0f8
postgresql11-server-11.11-1PGDG.sles12 (a)(none) (b)(none)
postgresql11-server-11.8-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Fri 15 May 2020
12:50:23 PM CEST, Key ID 1f16d2e1442df0f8
postgresql11-server-11.9-1PGDG.sles12 (a)(none) (b)DSA/SHA1, Thu 13 Aug 2020
04:02:50 PM CEST, Key ID 1f16d2e1442df0f8
postgresql13-server-13.0-1PGDG.sles15 (a)(none) (b)DSA/SHA1, Wed 23 Sep 2020
08:41:46 PM CEST, Key ID 1f16d2e1442df0f8
postgresql13-server-13.1-1PGDG.sles15 (a)(none) (b)DSA/SHA1, Thu 12 Nov 2020
01:18:36 AM CET, Key ID 1f16d2e1442df0f8

Are packages not signed anymore by intention?


pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #16947: Missing signatures on some packages
Next
From: Tom Lane
Date:
Subject: Re: BUG #16946: It may be that the content of the document is missing