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 1kTx2G-0007TK-A0 for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 18 Oct 2020 00:58:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kTx2C-0004Z4-L3 for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 18 Oct 2020 00:58:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kTx2C-0004Yw-4B for pgsql-pkg-debian@lists.postgresql.org; Sun, 18 Oct 2020 00:58:52 +0000 Received: from mail-il1-x142.google.com ([2607:f8b0:4864:20::142]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1kTx24-0001zE-EX for pgsql-pkg-debian@postgresql.org; Sun, 18 Oct 2020 00:58:51 +0000 Received: by mail-il1-x142.google.com with SMTP id l16so6776494ilt.13 for ; Sat, 17 Oct 2020 17:58:43 -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 :cc; bh=MpDZLjwQVVzLHb1aGJdTki3qzG7DBT90M7EpyJCnj3E=; b=cwh1aksh0YvOGTDrKFkTtzAqWKG62WlBS37Rl21Lry5rn7hXHnO5KFDUOs9KNsXO1w ZUHcwTCh3xgyne0PNe+KsdyMlSOP9/lZTll4n33fD6QDdWB0txLzPpjwkHXnBcSGBN9h 3EfWraBO2DnI7JWp6XKClQdnRcX9KEVm8CT88= 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:cc; bh=MpDZLjwQVVzLHb1aGJdTki3qzG7DBT90M7EpyJCnj3E=; b=cDxN6fV7NOhtIV0ZoIOlFpEpCQtkGl35PaW7FVmhxXxBQ3rWdJlynKAmJQ+1Yu3OFI 3TaZEWdw3X0GRCkOzLY3hfkhA7JCpIXKt77VapzwZwHiuzQGgyzNWsiZb/G24iWk3Hnd BknzgOY2fktKiKbMCJfySx/mOEiCifir54LShCVlc1PQIwU960hVc/YXjlgC3qH0zQEb jZC5WGEAp/84FvBbWu2ChAM8GQt6TSwtZm6LfjbgvfapUTMuQolMHuhNgF2m4tMdPgaD 17wb9QoRAMyvsdNkTh2YrtVqLgUezDwzU5bbzaUj/5rg5ePMZDG9TRlTuiSgF6FOTaUF mGTw== X-Gm-Message-State: AOAM530jvIpHlWw1nv7BMfTxBdr01dRsInQH2fciCjCAyogAnK1wLi2l pQGOfAh02aB5GCYnHBe4B1hn1A+Bes5r3ivAaXVWDg== X-Google-Smtp-Source: ABdhPJxUwWi2muxYqGeosbkNLw/CpvrbFKw4eXPH1CYQ8W5eJYaKMSnv08mPuFD9Vi+Jp/doDtpOZYA5tjjDUUtnyi0= X-Received: by 2002:a92:3007:: with SMTP id x7mr7302070ile.141.1602982722030; Sat, 17 Oct 2020 17:58:42 -0700 (PDT) MIME-Version: 1.0 References: <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> <20201013151535.GG719127@msg.df7cb.de> <20201013184429.GI719127@msg.df7cb.de> <1264A57A-FB05-47BC-993E-B139A3CEE71E@justatheory.com> In-Reply-To: <1264A57A-FB05-47BC-993E-B139A3CEE71E@justatheory.com> From: Aaron Pavely Date: Sat, 17 Oct 2020 19:58:31 -0500 Message-ID: Subject: Re: Update Old Version Public Keys? To: "David E. Wheeler" Cc: Christoph Berg , pgsql-pkg-debian@postgresql.org Content-Type: multipart/alternative; boundary="000000000000ba67c405b1e77f7e" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000ba67c405b1e77f7e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Sat, Oct 17, 2020 at 6:30 PM David E. Wheeler wrote: > On Oct 13, 2020, at 14:44, Christoph Berg wrote: > > >> Now, if I wanted to test Postgres 14 (dev), what additional steps woul= d > I have to take? > > > > sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh -v 14 -i > > For some reason it doesn=E2=80=99t work: > > > https://github.com/theory/pg-semver/runs/1269694601?check_suite_focus=3Dt= rue > > That=E2=80=99s running > > PGVERSION=3D14 > apt.postgresql.org.sh -p -v $PGVERSION > packages=3D"postgresql-$PGVERSION postgresql-server-dev-$PGVERSION > postgresql-common" > apt-get -o Dpkg::Options::=3D"--force-confdef" -o > Dpkg::Options::=3D"--force-confold" install -y $packages > > Working fine on v13 and earlier. > > Thanks, > > David > This is back to the release pin priority issue. PG14 is only available in the testing release, and the testing release's pin priority does not permit use without explicit enabling, i.e., use of apt-get option `-t -pgdg-testing`. Alternatively, skip the `apt-get` and simply use apt.postgresql.org.sh's `-i` option to install, if you can accept it overwriting any existing PostgreSQL configuration files, since it would achieve the same package set installation goal. -- Aaron --000000000000ba67c405b1e77f7e Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Sat, Oct 17, 2020 at 6:30 PM David E. = Wheeler <davi= d@justatheory.com> wrote:
On Oct 13, 202= 0, at 14:44, Christoph Berg <myon@debian.org> wrote:

>> Now, if I wanted to test Postgres 14 (dev), what additional steps = would I have to take?
>
> sudo /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh -v= 14 -i

For some reason it doesn=E2=80=99t work:

=C2=A0 https://github.co= m/theory/pg-semver/runs/1269694601?check_suite_focus=3Dtrue

That=E2=80=99s running

PGVERSION=3D14
apt.postgresql.org.sh -p -v $PGVERSION
packages=3D"postgresql-$PGVERSION postgresql-server-dev-$PGVERSION pos= tgresql-common"
apt-get -o Dpkg::Options::=3D"--force-confdef" -o Dpkg::Options::= =3D"--force-confold" install -y $packages

Working fine on v13 and earlier.

Thanks,

David

This is back to the release = pin priority issue. PG14 is only available in the testing release, and the = testing release's pin priority does not permit use without explicit ena= bling, i.e., use of apt-get option `-t <release-codename>-pgdg-testin= g`.

Alternatively, skip the `apt-get` and simply u= se=C2=A0apt.postgresql.org.sh&= #39;s `-i` option to install, if you can accept it overwriting any existin= g PostgreSQL configuration files, since it would achieve the same package s= et installation goal.

-- Aaron
--000000000000ba67c405b1e77f7e--