Horton

Thread

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

    PG Bug reporting form <noreply@postgresql.org> — 2024-04-11T07:31:12Z

    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

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

    Devrim Gündüz <devrim@gunduz.org> — 2024-04-11T10:10:38Z

    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

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

    Rainer Jung <rainer.jung@kippdata.de> — 2024-04-11T10:20:55Z

    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

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

    Devrim Gündüz <devrim@gunduz.org> — 2024-04-11T11:32:53Z

    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