Re: BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility

From: Christoph Berg <myon(at)debian(dot)org>
To: mike(dot)burgener(at)zg(dot)ch, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility
Date: 2022-10-31 12:18:51
Message-ID: Y1+9K0H7G83fQTxr@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> Dear Postgresql Community, while trying to mirror your repository to a
> Canonical Landscape Server, i discovered that you don't follow the
> guidelines of the Repository Format.

Hi Mike,

do you have any references to these guidelines?

> I could not get landscape to mirror, as it quite strictly checks if the
> repository is in the correct format and it internaly reuses the
> $distribution name set earlier and globally as a variable value.

Did you try setting distribution to focal-pgdg? Then everything should
be consistent.

> Maybe a quick on your repository to fullfill the Repository format standard
> could be to link/bindmount
>
> https://apt.postgresql.org/pub/repos/apt/dists/focal/ to
> https://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/ (stable)

That doesn't work as the Release file mentions the name as well and
apt will complain if it doesn't match.

> Another special case i discovered on your repositories, you are using the
> Postgres-Version name like
> https://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/12/
> actually that's not really needed, as your package-names for each major
> version seem to be different, you could just use
> https://apt.postgresql.org/pub/repos/apt/dists/focal/postgresql and have all
> versions like postgresql-12 postgresql-13 etc. in the same release file, as
> thats selectable by apt later for example with "apt install postgresql-12"
> "apt install postgresql-13"

Please see https://apt.postgresql.org/pub/repos/apt/pool/README for an
explanation.

> My suggestion to have a proper repository setup which follows the guidelines
> would be
>
> https://apt.postgresql.org/pub/repos/apt/dists/focal/postgresql

That would require you to set distribution = focal/postgresql. Is that
any better?

Christoph

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2022-10-31 13:40:23 Re: Memory leak on subquery as scalar operand
Previous Message Japin Li 2022-10-31 10:40:56 Re: BUG #17671: Query returns unexpected result