Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kSLLP-0004PQ-GS for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 13 Oct 2020 14:32:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kSLLN-00019d-0g for pgsql-pkg-debian@arkaria.postgresql.org; Tue, 13 Oct 2020 14:32:01 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kSLLM-00019W-6Q for pgsql-pkg-debian@lists.postgresql.org; Tue, 13 Oct 2020 14:32:00 +0000 Received: from mail-il1-x142.google.com ([2607:f8b0:4864:20::142]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kSLLF-0003nB-IN for pgsql-pkg-debian@postgresql.org; Tue, 13 Oct 2020 14:31:59 +0000 Received: by mail-il1-x142.google.com with SMTP id p16so12513677ilq.5 for ; Tue, 13 Oct 2020 07:31:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=pavely.net; s=google; h=mime-version:references:in-reply-to:from:date:message-id:subject:to; bh=zVJZLINg1yP/27g1joBzHNtn2YK1OzxZFoRz189LAuo=; b=NSzDptG43SqLnUpoFE+cxRrHvwjxJrPNy3nrRzlVAOmLdpLczvAyoYYVtxxpHQ6mPs uOOyTexdzF54oDpzOtFKrmfTZqS5wLPnMvSXh7ULvLY55cJS0WnXaBumbsAZr8Yp3yPj fuZDYEg6/YZNsFcOTaBBbSDYxIq+woy92vSzU= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to; bh=zVJZLINg1yP/27g1joBzHNtn2YK1OzxZFoRz189LAuo=; b=ALar+oy16KzbwFqlPSrYdbragxGCckSZjwS50IPTAEuZR51+QyO9AELCHGjPRc5JBF DIoCKYj432/s6KctdbCMU8MskYpukq946iv2APznVGfKdHsaA0ZILiWAsm+PQXjgWU/y n7Fao8tFMxpnsv9NRqz57MNC8+bQ4dRCKyTh12Ydi77aVXMbUcfb7mOYX4pelH4437nx mhs0Cj/lbmP26C29gYTfUGg5BuMkz/h1tQFMQwxHTIbilfRf/DgXvlLr4oRaoDctG8uF oR66OqkwOapsuQScyPEL4jZTtTgs7GfZFWdqNx0rLX8GfrbTq2JiY6JY1j7UwED4OvSd WQZQ== X-Gm-Message-State: AOAM530GLhm1QN+eJpRycliPkwaJ86ZM2suJASx1v2z73Fx6lqzuflQC BXF/JUnkR5BWqT63S02JlLL1MKul72V0QI3H123OGQ== X-Google-Smtp-Source: ABdhPJyem0/9BPTJ2ygJw+vu/bqEreuvRiwX5Akjk2Q+0FLKM8X5lo1BmzH24IPu2KYALRrI4IvfzO3GntX9jIiMtEQ= X-Received: by 2002:a92:3007:: with SMTP id x7mr175910ile.141.1602599512506; Tue, 13 Oct 2020 07:31:52 -0700 (PDT) MIME-Version: 1.0 References: <522ED40C-C3D6-4BA8-B88D-45C7EB74F9C7@justatheory.com> <20200608142813.GG2654726@msg.df7cb.de> <20200614152851.GA4144@msg.df7cb.de> <3FBE4444-B0C3-4EA9-8403-2F0DAE94D2BB@justatheory.com> <2DB83370-B525-4DE7-B65C-7F5C9A9F03E2@justatheory.com> <60B54CDC-F51B-405B-BEBB-0EEB46912D43@justatheory.com> <20201012212818.GC719127@msg.df7cb.de> In-Reply-To: <20201012212818.GC719127@msg.df7cb.de> From: Aaron Pavely Date: Tue, 13 Oct 2020 09:31:41 -0500 Message-ID: Subject: Re: Update Old Version Public Keys? To: Christoph Berg , "David E. Wheeler" , pgsql-pkg-debian@postgresql.org Content-Type: multipart/alternative; boundary="000000000000a91f8e05b18e46a7" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000a91f8e05b18e46a7 Content-Type: text/plain; charset="UTF-8" On Mon, Oct 12, 2020 at 4:28 PM Christoph Berg wrote: > Re: David E. Wheeler > > > Okay, I changed it to: > > > > > > ``` > > > ADD > https://salsa.debian.org/postgresql/postgresql-common/-/raw/master/pgdg/apt.postgresql.org.sh > /usr/local/bin/ > > > Hello gang. I tried this again today, now that 13.0 is out, and get the > same errors. Do I need to do something different than I did for 12 and > earlier? Example: > > > > https://github.com/theory/pg-semver/runs/1239421317 > > | + apt.postgresql.org.sh -p -v 13 > | This script will enable the PostgreSQL APT repository on > apt.postgresql.org on > | your system. The distribution codename used will be buster-pgdg-testing. > > Is that the latest version of the apt.postgresql.org.sh script? It > should only use "-testing" when passed -t. > > Christoph > I think the issue (in part) is here: https://salsa.debian.org/postgresql/postgresql-common/-/blob/master/pgdg/apt.postgresql.org.sh#L77-85 Because `-v 13` called in the script above forces the 'testing' release, installation will fail since the pgxn docker image's 'pg-start' script doesn't re-pin the release priority to include 'testing': https://github.com/pgxn/docker-pgxn-tools/blob/main/bin/pg-start#L12 Both should be updated; the former updated to realize the release of PostgreSQL 13 in non-testing repositories, and the latter to enable pinning of the testing release when necessary. -- Aaron --000000000000a91f8e05b18e46a7 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Oct 12, 2020 at 4:28 PM Christoph Ber= g <myon@debian.org<= /a>> wrote:
R= e: David E. Wheeler
> > Okay, I changed it to:
> >
> > ```
> > ADD https://salsa.debian.org/postgresql/postgresql-common/-/raw/master/p= gdg/apt.postgresql.org.sh /usr/local/bin/

> Hello gang. I tried this again today, now that 13.0 is out, and get th= e same errors. Do I need to do something different than I did for 12 and ea= rlier? Example:
>
>=C2=A0 =C2=A0https://github.com/theory/pg-sem= ver/runs/1239421317

| + apt.postgresql.org.sh -p -v 13
| This script will enable the PostgreSQL APT repository on apt.postgresql.o= rg on
| your system. The distribution codename used will be buster-pgdg-testing.<= br>
Is that the latest version of the apt.postgresql.org.sh script? It should only use "-testing" when passed -t.

Christoph


Because `-v 13` called in the s= cript above forces the 'testing' release, installation will fail si= nce the pgxn docker image's 'pg-start' script doesn't re-pi= n the release priority to include 'testing': https://github.com/pgxn/docker-pgxn-tools/blob/main/bin/pg-start#L12<= br>

Both should be updated; the former updated to = realize the release of PostgreSQL 13 in non-testing repositories, and the l= atter to enable pinning of the testing release when necessary.
-- Aaron
--000000000000a91f8e05b18e46a7--