From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1.migadu.com ([2001:41d0:403:58f0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id EIQXBIJmH2e6qgAA62LTzQ:P1 (envelope-from ) for ; Mon, 28 Oct 2024 10:25:06 +0000 Received: from aspmx1.migadu.com ([2001:41d0:403:58f0::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1.migadu.com with LMTPS id EIQXBIJmH2e6qgAA62LTzQ (envelope-from ) for ; Mon, 28 Oct 2024 11:25:06 +0100 X-Envelope-To: larch@yhetil.org Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20230601 header.b=RJ2ewlHo; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1730111105; h=from:from:sender:sender:reply-to:subject:subject:date:date: message-id:message-id:to:to:cc:cc:mime-version:mime-version: content-type:content-type:in-reply-to:in-reply-to: references:references:list-id:list-help:list-unsubscribe: list-subscribe:list-post:dkim-signature; bh=LXwH5aTEs7V6rl7wvcHc2OjsvawQKHgCBEqPeMUfVQo=; b=VMz8jxPVv7tfBC2/Gf99htd5iPMKWGHmCRc6wfVmvvPxFK+PekHIq8XKnGoDYGXLUUqrSF 3r+g9NTkVBg5yyq/vBogWmO7kYpwcCZXL/zR47p5fiwdBVEZUg86zLoWjCrYRY3yhdKcNL YzB+cUUzALRWrO5fNPx48Y2m86n1RjECP7PLP0cuVniXU8YLEVrVT7AX8gTciUAuX3sOOv Tv5+dQdL4Gv/hATtTPkfb4ExY66NIcEvE5HMi5GjW/OGRKEysECbEGAiiBZCTfKENBAVYk DH+XZ7U701423y/3z8iaWPv/DRo9d7ITVylpbqrMpDjeOwUBElulyVmkZrMfRA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20230601 header.b=RJ2ewlHo; spf=pass (aspmx1.migadu.com: domain of "guix-devel-bounces+larch=yhetil.org@gnu.org" designates 209.51.188.17 as permitted sender) smtp.mailfrom="guix-devel-bounces+larch=yhetil.org@gnu.org"; dmarc=none ARC-Seal: i=1; s=key1; d=yhetil.org; t=1730111105; a=rsa-sha256; cv=none; b=lsP0OED5wcWvBRMwQa8eYWjDMJivYGCaM1bvNqxAOfLdf7t3XZqzcKXjbbj8JHopCnLYLb zFHgFUIdPk5JwaxiiKQ+BDEegZVamNSAMVuNx17qO8e08BPf12/GBlrgcGygwkI2ZfvrSP PeuFF/GlkvATY7/5WzIC9qQ8vJ3QC0GFqEAAIfjt5t0al32FrSAgsYxHbstg8H+9X9kbcx MnsEoryRfc8Icl1VCYtFNsUuHj6raUWDghBOCaIGXvv8V6koHA44UMlp7/RaslNgEH3WO0 Hsw+nVRIcZeL4hWT8i1ftbkxPbVEiucL6yjYG0QsUZWuFPRhO4157z7bXCGFJg== Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by aspmx1.migadu.com (Postfix) with ESMTPS id 975F7803C8 for ; Mon, 28 Oct 2024 11:25:05 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t5MvR-0003DJ-JC; Mon, 28 Oct 2024 06:24:41 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1t5MvP-0003DA-H3 for guix-devel@gnu.org; Mon, 28 Oct 2024 06:24:39 -0400 Received: from mail-ej1-x629.google.com ([2a00:1450:4864:20::629]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1t5MvN-0006RN-TV for guix-devel@gnu.org; Mon, 28 Oct 2024 06:24:39 -0400 Received: by mail-ej1-x629.google.com with SMTP id a640c23a62f3a-a9abe139088so606121266b.1 for ; Mon, 28 Oct 2024 03:24:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730111076; x=1730715876; darn=gnu.org; h=in-reply-to:content-disposition:mime-version:references :mail-followup-to:message-id:subject:cc:to:from:date:sender:from:to :cc:subject:date:message-id:reply-to; bh=LXwH5aTEs7V6rl7wvcHc2OjsvawQKHgCBEqPeMUfVQo=; b=RJ2ewlHoxK65Ql3i3m1P7GHZjL0LAbdZ+pxWmEJTMwlhUEckS5Pi0Almj/hSjgT2SO 0lHmNMs+1a2t50ut8AvDUgFUB1WvzsR8seneRatd6BT8j4mVA1j9VCskXCI3IHH7N5lR /VFUBnq+J4PTFjbt2mhxGOa+dQpVV4y5IBn+sdJn1N2Eb782b/B0ASKiLBYj8jNRDi2V 78ryIpQcsXJApK6/l6tN9QA381K6OyDEpIuS6hoUOuWeVxmYaSOFaEPi2GLS27F3Tzb4 cihW4GgSS4EPOJW+ueS2LaifYqPVduVdUV83YBLknzRmbbYvFpuO9PDIDTzJZEAMWx4N qAeQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730111076; x=1730715876; h=in-reply-to:content-disposition:mime-version:references :mail-followup-to:message-id:subject:cc:to:from:date:sender :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=LXwH5aTEs7V6rl7wvcHc2OjsvawQKHgCBEqPeMUfVQo=; b=YmRiNcQ2usCUryzEP8arZ3+F8IJR3SRMk4R380kGBLVolVQ0hpL4e+Mh8a21WYUsJi d6m68PXiF6s6EIe67e34OQq+Dxlulhp2qQsE6R0HlX3PwF9zdBBkUBTSdpK5uP37hQ/+ 1EoDmSEDR+SXxEb5ERPM6RWNLsoEiEGM0fC+HaJhjhNtOH7FnxxuyYyb8/GXuXruAME8 ikmqTAPEJpRBL9JNdkrd8NDJDcBcnufxcm3ZEKW9MPhv9cbGC1Wut7X3GdPE260R7DeT 2FPzNYaQFhlcOB4lNGsizSoM+pA73+K0NKDftBcTHMmlIwbppcHhNJVZxGAJOHlduMUL GuQA== X-Forwarded-Encrypted: i=1; AJvYcCVczqgZvHJKbCHp5sQp4No838bpJ4jq6WnBfGPtRfCTuxvJHSUUfbmC7c8ilLe5WLrOcJmNOJh5X3Oo@gnu.org X-Gm-Message-State: AOJu0YzDap8HCnkKF/OTm3EPHadpie0dkzwGYrJl6e5xpC4IpchhK3Lz m0+2qQEvVRFoO5ArHuUiQaXT/feFWF8OqOIbxkqlyw1NpnUhI98+TOoLfgrP X-Google-Smtp-Source: AGHT+IFMTOLP+VFOwzWGO8FfVHQAu112K7qMPAEscuJ2s+dMpNwwKPNzlUh63M79c1BQ3+L92pw9sA== X-Received: by 2002:a17:907:7211:b0:a9a:ad8:fc56 with SMTP id a640c23a62f3a-a9de6167c81mr642047166b.44.1730111075867; Mon, 28 Oct 2024 03:24:35 -0700 (PDT) Received: from localhost ([141.226.162.35]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a9b343d267esm358528266b.182.2024.10.28.03.24.34 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 28 Oct 2024 03:24:35 -0700 (PDT) Date: Mon, 28 Oct 2024 12:24:30 +0200 From: Efraim Flashner To: Nicolas Graves Cc: Andreas Enge , guix-devel@gnu.org, Christopher Baines Subject: Re: Default postgresql version Message-ID: Mail-Followup-To: Nicolas Graves , Andreas Enge , guix-devel@gnu.org, Christopher Baines References: <874j4wtuny.fsf@ngraves.fr> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="xXONEpQTw5SGeA3L" Content-Disposition: inline In-Reply-To: <874j4wtuny.fsf@ngraves.fr> X-PGP-Key-ID: 0x41AAE7DCCA3D8351 X-PGP-Key: https://flashner.co.il/~efraim/efraim_flashner.asc X-PGP-Fingerprint: A28B F40C 3E55 1372 662D 14F7 41AA E7DC CA3D 8351 Received-SPF: pass client-ip=2a00:1450:4864:20::629; envelope-from=efraim.flashner@gmail.com; helo=mail-ej1-x629.google.com X-Spam_score_int: -16 X-Spam_score: -1.7 X-Spam_bar: - X-Spam_report: (-1.7 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FORGED_FROMDOMAIN=0.001, FREEMAIL_FROM=0.001, HEADER_FROM_DIFFERENT_DOMAINS=0.25, RCVD_IN_DNSWL_NONE=-0.0001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-BeenThere: guix-devel@gnu.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: "Development of GNU Guix and the GNU System distribution." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: guix-devel-bounces+larch=yhetil.org@gnu.org Sender: guix-devel-bounces+larch=yhetil.org@gnu.org X-Migadu-Country: US X-Migadu-Flow: FLOW_IN X-Migadu-Scanner: mx11.migadu.com X-Migadu-Spam-Score: 2.93 X-Spam-Score: 2.93 X-Migadu-Queue-Id: 975F7803C8 X-TUID: TGQYSvOQc0xK --xXONEpQTw5SGeA3L Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Oct 28, 2024 at 10:59:29AM +0100, Nicolas Graves wrote: > On 2024-10-28 10:49, Andreas Enge wrote: >=20 > > Hello, > > > > I have just pushed this commit > > https://issues.guix.gnu.org/74006 > > that changes the default postgresql version from 10 (which has a CVE) to > > just the postgresql variable (now at 15). > > > > Since as I understood changing postgresql versions requires a > > (manual?) >=20 > Indeed, in https://www.postgresql.org/support/versioning/:=20 >=20 > Upgrading >=20 > Major versions make complex changes, so the contents of the data > directory cannot be maintained in a backward compatible way. A > dump/reload of the database or use of the pg_upgrade application is > required for major upgrades. We also recommend reading the upgrading > section of the major version you are planning to upgrade to. You can > upgrade from one major version to another without upgrading to > intervening versions, but we recommend reading the release notes of all > intervening major versions prior to doing so. >=20 > > update of the database format, I am wondering whether we should > > - instead again choose a default value of a specific version? > > or maybe #f and force the user to choose one themselves? >=20 > #f seems a good option since it forces users to update manually when > they require it, no magic updates involved. Maybe we should add a > comment about why the default is #f, and point to the url of the > documentation about upgrades. >=20 > > - add a news item to be displayed during "guix pull"? >=20 > I think a news item is necessary. >=20 > Sorry I should have thought about it with the patch, let me know if > you'd wish I write this patch + news item. >=20 > > Andreas > > >=20 I feel like there is room for an 'upgrade action for postgresql, to dump a database (also useful for a 'backup action!) and then re-import it, but I didn't want to come anywhere near touching that. Also, thank you for updating it! I was recently feeling like it was on the 10 branch for too long and could use a bump. And some CVE handling. --=20 Efraim Flashner =D7=A8=D7=A0=D7=A9=D7=9C=D7=A4 = =D7=9D=D7=99=D7=A8=D7=A4=D7=90 GPG key =3D A28B F40C 3E55 1372 662D 14F7 41AA E7DC CA3D 8351 Confidentiality cannot be guaranteed on emails sent or received unencrypted --xXONEpQTw5SGeA3L Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEoov0DD5VE3JmLRT3Qarn3Mo9g1EFAmcfZl4ACgkQQarn3Mo9 g1FJsw//TuR/jwTqVZVJdedJeqklLZzH7WsQ2tccwfIAhS3uOJpGJMBCi4EcGlNl Db14MhmtY8CvkdonGIwTjxDtaJC8i44OhEoLFnaOoPheFIjY02vzTTNJxG+TVbfJ wEfX8hlup0y/epq+LkdtqFc0YI92e5SWY/BhH92oDE11BHL8LbCq8GUL25wDjCb4 rCuEhURqIUHOLspKoDr31UD9n71Fpk3jZlM81o0Uwecjst2mHIO5qO05oz+5y0El /GAz3ygUi2NAt78OWSutLa9/C6lkfMhot5Sidzq7wqWV673IIrpGZMtivwL9bCm/ TuOHcoYALN4XI8fSEx1yUrKkQ2FQWmMTQxfUFoa4KoTgnSN3JnZ6H68g+k2W64I8 KKVJooSj0t2Z1zgwpmxgvE1BlntfwrVsRG7XvRbmSFGqFDwmhPUgaCYLE7HUcenG bxehuAty/GAz5DUlqVZwj9aFFwC/aWJmh3RTmbETZzWcNBIvOTBYSEzgkR2FIx2a ffAmTXRjohNOI8JjHh865WHnzw1f9PxgmA/2Ah9Va5QvXSGpH3RLv9hltlmvGEyR /6B68/VCoF/7YQhSyjIqeZlbKLSHaYu5tcm/AuMODl665jHCL3Q/bj33LG0TsC+q 1QA2Pao6KuzGMI8yMdyFwpigS3vWBTqr+ank59Wu7Cs6R8iFZUo= =1TGP -----END PGP SIGNATURE----- --xXONEpQTw5SGeA3L--