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 1jkUZ9-0002vr-Eg for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 14 Jun 2020 15:28:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1jkUZ8-0005en-3l for pgsql-pkg-debian@arkaria.postgresql.org; Sun, 14 Jun 2020 15:28:58 +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 1jkUZ7-0005eg-Uo for pgsql-pkg-debian@lists.postgresql.org; Sun, 14 Jun 2020 15:28:57 +0000 Received: from feynman.df7cb.de ([195.49.152.168]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1jkUZ3-0005rf-5q for pgsql-pkg-debian@postgresql.org; Sun, 14 Jun 2020 15:28:57 +0000 Received: from msg.df7cb.de (unknown [IPv6:2a02:908:1474:3de0:76e5:bff:fef3:7e00]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (4096 bits) server-digest SHA256) (Client did not present a certificate) by feynman.df7cb.de (Postfix) with ESMTPSA id 49lJJz4DDyz3DwZ; Sun, 14 Jun 2020 17:28:51 +0200 (CEST) Date: Sun, 14 Jun 2020 17:28:51 +0200 From: Christoph Berg To: "David E. Wheeler" Cc: pgsql-pkg-debian@postgresql.org Subject: Re: Update Old Version Public Keys? Message-ID: <20200614152851.GA4144@msg.df7cb.de> Mail-Followup-To: Christoph Berg , "David E. Wheeler" , pgsql-pkg-debian@postgresql.org References: <522ED40C-C3D6-4BA8-B88D-45C7EB74F9C7@justatheory.com> <20200608142813.GG2654726@msg.df7cb.de> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Re: David E. Wheeler > Works very well, except for Postgres 13 (and presumably future pre-releases). Is there some incantation I could put into the Dockerfile to permanently configure it to ready from the prerelease repo, too? Sorry for the newb question, I’m only a superficial apt user. PG13 requires an extra "13" added to the sources.list entry: https://wiki.postgresql.org/wiki/Apt/FAQ#I_want_to_try_the_beta_version_of_the_next_PostgreSQL_release There's a shell script to automate these bits in postgresql-common 204 or newer: /usr/share/postgresql-common/pgdg/apt.postgresql.org.sh -v 13 https://salsa.debian.org/postgresql/postgresql-common/-/blob/master/pgdg/apt.postgresql.org.sh (Unfortunately, buster has only version 200, so you'd need to install postgresql-common from buster-pgdg first, but if you do that, you have a trust path from buster via buster-pgdg to PG13 without fetching random things via wget.) Christoph