pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility
2+ messages / 2 participants
[nested] [flat]

* BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility
@ 2022-10-31 07:36 PG Bug reporting form <noreply@postgresql.org>
  2022-10-31 12:18 ` Re: BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility Christoph Berg <myon@debian.org>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2022-10-31 07:36 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: mike.burgener@zg.ch

The following bug has been logged on the website:

Bug reference:      17672
Logged by:          Michael Burgener
Email address:      mike.burgener@zg.ch
PostgreSQL version: Unsupported/Unknown
Operating system:   Ubuntu/Debian Distrbution Postgres Repository
Description:        

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.

In your case the structure is like:
https://apt.postgresql.org/pub/repos/apt/dists/focal-pgdg/
where as of best-practice and for best compatibility with mirroring tools
etc. the format should be
https://apt.postgresql.org/pub/repos/apt/dists/focal/

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.

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)

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"

My suggestion to have a proper repository setup which follows the guidelines
would be 

https://apt.postgresql.org/pub/repos/apt/dists/focal/postgresql
https://apt.postgresql.org/pub/repos/apt/dists/focal/postgresql-testing
https://apt.postgresql.org/pub/repos/apt/dists/focal/postgresql-snapshot

https://apt.postgresql.org/pub/repos/apt/dists/jammy/postgresql
https://apt.postgresql.org/pub/repos/apt/dists/jammy/postgresql-testing
https://apt.postgresql.org/pub/repos/apt/dists/jammy/postgresql-snapshot

Adjusting the Repository mirrors to better match the guidelines would make
things a lot easier to maintain IMHO.

Btw i provide Ubuntu Official mirrors for about 15 years now and have quite
some experience with Ubuntu/Debian package repos :-)

kind regards

Michael



^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility
  2022-10-31 07:36 BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility PG Bug reporting form <noreply@postgresql.org>
@ 2022-10-31 12:18 ` Christoph Berg <myon@debian.org>
  0 siblings, 0 replies; 2+ messages in thread

From: Christoph Berg @ 2022-10-31 12:18 UTC (permalink / raw)
  To: mike.burgener@zg.ch; pgsql-bugs@lists.postgresql.org

> 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





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2022-10-31 12:18 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-10-31 07:36 BUG #17672: Wrong logic of Postgresql Resporitory Naming and mirroring incompatibility PG Bug reporting form <noreply@postgresql.org>
2022-10-31 12:18 ` Christoph Berg <myon@debian.org>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox