BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed

Started by PG Bug reporting formabout 2 years ago4 messagesbugs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

The following bug has been logged on the website:

Bug reference: 18427
Logged by: Rainer Jung
Email address: rainer.jung@kippdata.de
PostgreSQL version: 15.6
Operating system: RHEL 9 x86_64
Description:

The RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm downloaded from the repos
pgdg15
(https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm)
is not signed:

rpm -q -i postgis33_15-3.3.6-3PGDG.rhel9.x86_6
...
Signature : (none)
...

which leads to failed installation attempts using yum.

The previous packages postgis33_15-3.3.6-1PGDG.rhel9.x86_64.rpm and
postgis33_15-3.3.5-1PGDG.rhel9.x86_64.rpm where signed.

Thanks and regards,
Rainer

#2Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: PG Bug reporting form (#1)
Re: BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed

Hi,

On Thu, 2024-04-11 at 07:31 +0000, PG Bug reporting form wrote:

Bug reference:      18427
Logged by:          Rainer Jung
Email address:      rainer.jung@kippdata.de
PostgreSQL version: 15.6
Operating system:   RHEL 9 x86_64
Description:       

The RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm downloaded from the
repos
pgdg15
(
https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/p
ostgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm)
is not signed:

rpm -q -i postgis33_15-3.3.6-3PGDG.rhel9.x86_6
...
Signature   : (none)
...

which leads to failed installation attempts using yum.

The previous packages postgis33_15-3.3.6-1PGDG.rhel9.x86_64.rpm and
postgis33_15-3.3.5-1PGDG.rhel9.x86_64.rpm where signed.

can you please run

dnf clean metadata

and try again?

Thanks!

Regards,

--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR

#3Rainer Jung
rainer.jung@kippdata.de
In reply to: Devrim GÜNDÜZ (#2)
Re: BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed

Am 11.04.24 um 12:10 schrieb Devrim Gündüz:

Hi,

On Thu, 2024-04-11 at 07:31 +0000, PG Bug reporting form wrote:

Bug reference:      18427
Logged by:          Rainer Jung
Email address:      rainer.jung@kippdata.de
PostgreSQL version: 15.6
Operating system:   RHEL 9 x86_64
Description:

The RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm downloaded from the
repos
pgdg15
(
https://download.postgresql.org/pub/repos/yum/15/redhat/rhel-9-x86_64/p
ostgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm)
is not signed:

rpm -q -i postgis33_15-3.3.6-3PGDG.rhel9.x86_6
...
Signature   : (none)
...

which leads to failed installation attempts using yum.

The previous packages postgis33_15-3.3.6-1PGDG.rhel9.x86_64.rpm and
postgis33_15-3.3.5-1PGDG.rhel9.x86_64.rpm where signed.

can you please run

dnf clean metadata

and try again?

That helps, it works now, thank you. The timestamp of the RPM file has
changed (size stayed the same), so I guess it was signed in the meantime?

Thanks and best regards!

Rainer

#4Devrim GÜNDÜZ
devrim@gunduz.org
In reply to: Rainer Jung (#3)
Re: BUG #18427: RPM postgis33_15-3.3.6-3PGDG.rhel9.x86_64.rpm not signed

Hi,

On Thu, 2024-04-11 at 12:20 +0200, Rainer Jung wrote:

That helps, it works now, thank you. The timestamp of the RPM file has
changed (size stayed the same), so I guess it was signed in the
meantime?

Well, I fixed the signing issue yesterday, but only PostGIS 3.3 -
PostgreSQL 15 - RHEL 9 packages were not synced for some reason. I
rebuilt all the repository data early morning.

Regards,
--
Devrim Gündüz
Open Source Solution Architect, PostgreSQL Major Contributor
Twitter: @DevrimGunduz , @DevrimGunduzTR