From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0.migadu.com ([2001:41d0:403:4876::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms13.migadu.com with LMTPS id cyJZMCGLH2dAWAAAqHPOHw:P1 (envelope-from ) for ; Mon, 28 Oct 2024 13:01:21 +0000 Received: from aspmx1.migadu.com ([2001:41d0:403:4876::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0.migadu.com with LMTPS id cyJZMCGLH2dAWAAAqHPOHw (envelope-from ) for ; Mon, 28 Oct 2024 14:01:21 +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=hx8HtXUL; dmarc=none; 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" ARC-Seal: i=1; s=key1; d=yhetil.org; t=1730120481; a=rsa-sha256; cv=none; b=PEuq3x8G+JpLLzDcDKXrjcGN9DoP/3g6a/pnzPRWSofcpSvmGjclkaBSJYuwScNsRTt7Tn REiYZ1VSuUu0/yhlnd8k+18Kus6p4NrW1h7tbr3WdbBVp0PCK/kNd37C2nru/EIxMplr+y LNB6YmW7KZhWUsOmMbXmz5mPN7W27502hM1I/hid/r5LipUu3Q0GIEmnhY8hcJuQkbvo2T X9D845TDf2Ap81Vpsvtq6kxztCqzWhMgxes1ahbT3E677HBeAJEggMpUsLWAnxcGNYDLVT Pvrw5a3n8t79SrkxmC322/AMe4xTsPKWJW/vyGP/WarSYPJx3gTG8ZoI3AeDWg== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=gmail.com header.s=20230601 header.b=hx8HtXUL; dmarc=none; 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" ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1730120481; 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=+ZEheCeUUszEIvBsrEri0m9A+MrvQEbguXQSiCp9UYc=; b=Id+mTEVd3TT+T0dJ0KAHSs3aq6PD6kdZT4HeyllVHmf/+OUrwYnW2fyidhtk3ADP2iGSdN uBGBIiwRC5OCRXCGlAdsLCK0xh+ZTxjdwUB3x+lSEbq7jjXJrGnhPkIQ1Qj7NkWpFCVlDy 7LMqIp9+UfWsTTzvLY41Wn9rLxHdKbDnFKCPJE2VTCk7SGAeW66zXTnmgHqhobDa46J6HO VWP6Jd499B9Yz8bJ4dh2uSa8Cg0WvynQpzlmD647HDDtz5ZBnXcv+4BlexvMm3ZbFslxN9 +t5zi2Qxu1V/A48mXlT4+mySkGFhYzlQYoSJjrxZHPt1yUPdEAfbMpvvUWo4iQ== 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 722771F74E for ; Mon, 28 Oct 2024 14:01:21 +0100 (CET) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t5PMW-0000Lh-Of; Mon, 28 Oct 2024 09:00:48 -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 1t5PM9-0000J8-HI for guix-devel@gnu.org; Mon, 28 Oct 2024 09:00:36 -0400 Received: from mail-wm1-x336.google.com ([2a00:1450:4864:20::336]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1t5PM7-0008D4-7a for guix-devel@gnu.org; Mon, 28 Oct 2024 09:00:24 -0400 Received: by mail-wm1-x336.google.com with SMTP id 5b1f17b1804b1-43162cf1eaaso57905885e9.0 for ; Mon, 28 Oct 2024 06:00:21 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1730120420; x=1730725220; 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=+ZEheCeUUszEIvBsrEri0m9A+MrvQEbguXQSiCp9UYc=; b=hx8HtXULAVrojwuhdlrwZOnFJTfl+h5oF8QjTjWZ4vMAz2ZCw4Yk3I4J60pG4oGMfQ O+VEMtDjB+peYNcV3HphjpHrZ9YdZMiT+q4VHEhVZZnBbqn84iaO4DJqjkNPRbY1h4fJ 7nMXhb2XGol0yEtWCi8SFRDJcpHyc/h2BjGXwjenVpUS42pUUzzmr+4Q+/O4Sm4QBMQw Y9ZtC7apcb9Ea0GM+1UUNFZ5ancyM1dh/V6hcdwH/8DkQMfmpytLB1Ic73ZYwYPsbTfs bbHa7NUAk3g2bH8WB5/fYyEOoXghWbNJ+mqJU2+qvbg7HxQ2Q4s+v5lU4mmdbThC5+yA GR1A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1730120420; x=1730725220; 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=+ZEheCeUUszEIvBsrEri0m9A+MrvQEbguXQSiCp9UYc=; b=vh7bfPD6pFTXphrPoPueFeELEkEI87fP5IFpuKSSANsDcrVMvIELFfwnGuNE+W6lvT dynqGj9T2rn/kctv4K2h9Yl4CwqMdMmNFrjYkx1BeaNdCUcu4a5Ki3fOdWS8vxXvekVw uhmSqwOrwW1lWJw74J/EKCUJs247Rnu5mhz7Ko2Bk1TAQ/N8ZA+5WAkHDNOq110P/BGF ZXnlBlunlLfmXzOWGa7eaVgfrs6XQOo0x3uUeJwRTIAIpDH7iibEwPzoadjBUe2MkKqK Ebt+h2w33OUkyagB13yvPodT1HOTuJDt8aMXsSo3Yf1Yi8Lp2zqjF2kxo6/JkYr7Bywr 175Q== X-Forwarded-Encrypted: i=1; AJvYcCVtJ6vw0XQ9ZWn55yxVQS5CIf/QS7g6WQ12HehpbjSszMrazQRJnGV2fH7pgaGrDwgIdmFIipT/cZwB@gnu.org X-Gm-Message-State: AOJu0Yyh5VcrCXKIlJ7jLBAtC8mvyK85dIoPPlTgMKugFXkMvWLenJmO dsE1rpZgDTEiaWnV3ObLpbs6SUA3PO39II/nU5suyVVhgDoyXT6Z X-Google-Smtp-Source: AGHT+IF5Yfk4wwqjjc35OieIokv0KkuYQo7/Pvkq1fDAf9GD6jiNdg20lOKltQsheD0qvBfBzKDJqw== X-Received: by 2002:adf:f10a:0:b0:37d:4b26:54ca with SMTP id ffacd0b85a97d-38061171f6bmr8287569f8f.14.1730120420038; Mon, 28 Oct 2024 06:00:20 -0700 (PDT) Received: from localhost ([141.226.162.35]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-a9b3a0887d8sm371526066b.206.2024.10.28.06.00.18 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 28 Oct 2024 06:00:19 -0700 (PDT) Date: Mon, 28 Oct 2024 15:00:14 +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> <87sesgscgx.fsf@ngraves.fr> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="eR3+ek2IF3VnXt/S" Content-Disposition: inline In-Reply-To: <87sesgscgx.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::336; envelope-from=efraim.flashner@gmail.com; helo=mail-wm1-x336.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.249, 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-Spam-Score: -1.08 X-Spam-Score: -1.08 X-Migadu-Queue-Id: 722771F74E X-Migadu-Scanner: mx10.migadu.com X-TUID: t73VY7ZQyIuj --eR3+ek2IF3VnXt/S Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Mon, Oct 28, 2024 at 12:17:50PM +0100, Nicolas Graves wrote: > On 2024-10-28 12:02, Andreas Enge wrote: >=20 > > Am Mon, Oct 28, 2024 at 10:59:29AM +0100 schrieb Nicolas Graves: > >> Sorry I should have thought about it with the patch, let me know if > >> you'd wish I write this patch + news item. > > > > Well, I wondered whether or not to apply the patch, but since it had a > > CVE, I thought solving it would be the more urgent action. > > > > A patch and news item would be welcome, and I hope that someone using > > postgresql (maybe that is you? or Efraim who already replied?) can then > > chime in and provide a more substantial opinion than I could give. >=20 > Done now in 74058. Indeed Efraim probably would have a more substantial > opinion, please go ahead and change the patches if you find a more > relevant approach! I added a comment about doing the migration > automatically with Guix, but I won't be able to handle that quickly > either. No, I try to stay away from needing a database, I don't want to have to administer it. I just like being able to apply CVE patches. --=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 --eR3+ek2IF3VnXt/S Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCAAdFiEEoov0DD5VE3JmLRT3Qarn3Mo9g1EFAmcfitcACgkQQarn3Mo9 g1GndQ//Um36/Q/yTIU6roMxaOxR5P02ClWKbFAXBT3osKVgv6lZjIIZK2nVErjf Gl2zap5mTZa+9Fq5bMEaK1cCH9uESfQK/YIZiwu4gPElQW4BjZ/iNYa98gEIPgo4 q7LbJJT6/+uW9R3O1Qb5rEYUyxBAHdRLXJ5GVpKqVqqsncaXyQ9x4rN7u8yLzFv0 5vUfO7Wq4YYb3V5bcpsz2oWobtfq90KiMIX9asoRdpZg7YKm0W1fx13uGjWT8Elm sCDNMPN5/7rI+cp9TJsosfsyo8EKMxf35I3Pfeirr5u/dTDvTJCJAFC/0VFKSHFW U3j19DBN+FhvYnTAJUqARrzCReT9gPyx+O8ahbJI7jeGslgu/ISv9kxIgGHYUk7e H+INs2sGamsyPrOSEwgEG6qTNPTgtdYwH5FvYUdskyNYTCOM4gt861fbNjUUEk7J FbgGfCUQ2tyK07Ca8tYyn5tm+z/NDl6vEYgGAGFS6QOJQx2vuZzORNgmOuiCmHMf PdXneaEPyurPJspZ1z46FWzXVzst0aQuCR6JQfzHMRc+nMqB0EJ4sBMLWSkEpcV9 J9o5Wflox0XHPsj+N9D7GY71TCb4GsopLcNXm/dc99ga4Y/wxo+W55KhtT2Ov8vC H3akGRH3wNdocCu41a+L1phGSyPQm9z/7KJ8sCP/1Ml0SJk9XF8= =+1yj -----END PGP SIGNATURE----- --eR3+ek2IF3VnXt/S--