From patchwork Thu Nov 7 17:09:59 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Nicolas Graves X-Patchwork-Id: 70052 Return-Path: X-Original-To: patchwork@mira.cbaines.net Delivered-To: patchwork@mira.cbaines.net Received: by mira.cbaines.net (Postfix, from userid 113) id 9BC6527BBEA; Thu, 7 Nov 2024 17:11:25 +0000 (GMT) X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on mira.cbaines.net X-Spam-Level: X-Spam-Status: No, score=-6.4 required=5.0 tests=BAYES_00,DKIM_INVALID, DKIM_SIGNED,MAILING_LIST_MULTI,RCVD_IN_DNSWL_BLOCKED, RCVD_IN_VALIDITY_CERTIFIED,RCVD_IN_VALIDITY_RPBL,RCVD_IN_VALIDITY_SAFE, SPF_HELO_PASS,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.6 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) by mira.cbaines.net (Postfix) with ESMTPS id 5748027BBE2 for ; Thu, 7 Nov 2024 17:11:24 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t962D-0003cU-9f; Thu, 07 Nov 2024 12:11:05 -0500 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 1t962C-0003cJ-3n for guix-patches@gnu.org; Thu, 07 Nov 2024 12:11:04 -0500 Received: from debbugs.gnu.org ([2001:470:142:5::43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1t962B-0002Td-Nl for guix-patches@gnu.org; Thu, 07 Nov 2024 12:11:03 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=debbugs.gnu.org; s=debbugs-gnu-org; h=MIME-Version:Date:From:To:In-Reply-To:References:Subject; bh=32KFITK/8yxrApGcEbFuYWy1u4dPYlM+r6xWmyMcKcc=; b=MWEFYhs9rAUHdywqy/NqZR9C22djesJdVRmVuOHqfeSuxVC7Zr3KQoASvDglWUdukvT7HU6Z6WHliraBw13R6dfNXbnBBLTUVA5/DYJgGOjqQUk9E0yI4C0cAxTbTFd0DtXsb0ygkG9hRS0v4UkUdNWuq027kzyaBHAQX5Wm4sFkdGbItNLS9Xi+QIWnnGKSYePqfZpnIQPN1OMt9LVqYz+9YXFuxeAH3GXw6nndtZmGVWzCI8Ylt2PxY3LxAPSeJ2sWV95I0IYaK4Fc0zH48A4m6CUM+feHFy5QqyElAmeponP510Dlt+vLPvY6dIJDKwl9N4PfbryRVptMs/Ct8w==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1t962B-0001Ja-AK for guix-patches@gnu.org; Thu, 07 Nov 2024 12:11:03 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#74058] [PATCH v3 1/2] gnu: postgresql-configuration: Set default postgresql to *no*. References: <20241028105741.12834-1-ngraves@ngraves.fr> In-Reply-To: <20241028105741.12834-1-ngraves@ngraves.fr> Resent-From: Nicolas Graves Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Thu, 07 Nov 2024 17:11:03 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74058 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 74058@debbugs.gnu.org Cc: Nicolas Graves Received: via spool by 74058-submit@debbugs.gnu.org id=B74058.17309994174834 (code B ref 74058); Thu, 07 Nov 2024 17:11:03 +0000 Received: (at 74058) by debbugs.gnu.org; 7 Nov 2024 17:10:17 +0000 Received: from localhost ([127.0.0.1]:49427 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t961Q-0001Fj-VG for submit@debbugs.gnu.org; Thu, 07 Nov 2024 12:10:17 -0500 Received: from 12.mo582.mail-out.ovh.net ([178.32.125.228]:53913) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t961M-0001Bx-9G for 74058@debbugs.gnu.org; Thu, 07 Nov 2024 12:10:15 -0500 Received: from director1.ghost.mail-out.ovh.net (unknown [10.108.25.169]) by mo582.mail-out.ovh.net (Postfix) with ESMTP id 4XkpVB44Fjz1SLD for <74058@debbugs.gnu.org>; Thu, 7 Nov 2024 17:10:10 +0000 (UTC) Received: from ghost-submission-5b5ff79f4f-jfdqd (unknown [10.110.188.136]) by director1.ghost.mail-out.ovh.net (Postfix) with ESMTPS id ECE281FD41; Thu, 7 Nov 2024 17:10:09 +0000 (UTC) Received: from ngraves.fr ([37.59.142.101]) by ghost-submission-5b5ff79f4f-jfdqd with ESMTPSA id SFRyF3H0LGeiRwEANhF84w (envelope-from ); Thu, 07 Nov 2024 17:10:09 +0000 Authentication-Results: garm.ovh; auth=pass (GARM-101G0044666dbfa-f666-4d9a-97ba-1fa34c766931, 2B264539C56665297410E0ABC0C486ED03F6DD63) smtp.auth=ngraves@ngraves.fr X-OVh-ClientIp: 80.215.103.88 Date: Thu, 7 Nov 2024 18:09:59 +0100 Message-ID: <20241107171006.14868-1-ngraves@ngraves.fr> X-Mailer: git-send-email 2.46.0 MIME-Version: 1.0 X-Ovh-Tracer-Id: 17614141093378384610 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeefuddrtdeggdeliecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvvefufffkofgggfestdekredtredttdenucfhrhhomheppfhitgholhgrshcuifhrrghvvghsuceonhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrqeenucggtffrrghtthgvrhhnpeekffegteffgfffjeegjedvfffgtddvueeutefgfeeuvdejgedvgeejjeevueeuveenucfkphepuddvjedrtddrtddruddpkedtrddvudehrddutdefrdekkedpfeejrdehledrudegvddruddtudenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeduvdejrddtrddtrddupdhmrghilhhfrhhomhepnhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrpdhnsggprhgtphhtthhopedupdhrtghpthhtohepjeegtdehkeesuggvsggsuhhgshdrghhnuhdrohhrghdpoffvtefjohhsthepmhhoheekvdgmpdhmohguvgepshhmthhpohhuth DKIM-Signature: a=rsa-sha256; bh=32KFITK/8yxrApGcEbFuYWy1u4dPYlM+r6xWmyMcKcc=; c=relaxed/relaxed; d=ngraves.fr; h=From; s=ovhmo4487190-selector1; t=1730999410; v=1; b=C1e5F0ryHxdzmMtn96gAW3vjaAcemJPJ8f2i8EWZdqMjJO5+872LpPmRnczrQI/diFrjCoUr oTqDj2xraVHSAqP1RzoZHmFho/7KJm5iFRqA/q26HjfLb/69GaLX+B4g9pJ0f7sc/ZYFmhMNqLN rvk6MC9e0nmRfiqEVWM68FFFYw9NZfCet4Gld4aFxF43kjm9dzzCVfv1SHRtLbdv6A2wbEDHDoA WmPnFMz0jQez92XihslZbvMWOdlvPMLCVuIW1G+oZkuRW/2tCJLdSl/PwuslmItUyZE6k9NzS5M 7LmRWzLCDvr/XRSR6pQ7DolKgvrA6eCGKopTVszu6y/7g== X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: guix-patches@gnu.org List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-to: Nicolas Graves X-ACL-Warn: , Nicolas Graves via Guix-patches X-Patchwork-Original-From: Nicolas Graves via Guix-patches via From: Nicolas Graves Errors-To: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org Sender: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org X-getmail-retrieved-from-mailbox: Patches * gnu/services/databases.scm (postgresql-configuration)[postgresql]: Set default to *no*. (postgresql-service): Revert default to postgresql-10 (rationale: We can remove this service at the same time than postgresql-10, in something like 6 months to a year). --- gnu/services/databases.scm | 8 ++++++-- 1 file changed, 6 insertions(+), 2 deletions(-) diff --git a/gnu/services/databases.scm b/gnu/services/databases.scm index 0933eb5e79..c499356c3a 100644 --- a/gnu/services/databases.scm +++ b/gnu/services/databases.scm @@ -167,8 +167,12 @@ (define contents (define-record-type* postgresql-configuration make-postgresql-configuration postgresql-configuration? + ;; Setting it to '*no* ensures that the user sets its current postgresql + ;; explicitely. Since major upgrades currently require a manual migration + ;; of the database, this way the user is responsible for upgrading properly. + ;; MAYBE TODO: Write an action to automatically upgrade in Guix. (postgresql postgresql-configuration-postgresql ;file-like - (default postgresql)) + (default '*no*)) (port postgresql-configuration-port (default 5432)) (locale postgresql-configuration-locale @@ -346,7 +350,7 @@ (define postgresql-service-type (default-value (postgresql-configuration)) (description "Run the PostgreSQL database server."))) -(define-deprecated (postgresql-service #:key (postgresql postgresql) +(define-deprecated (postgresql-service #:key (postgresql postgresql-10) (port 5432) (locale "en_US.utf8") (config-file (postgresql-config-file)) From patchwork Thu Nov 7 17:10:00 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Nicolas Graves X-Patchwork-Id: 70054 Return-Path: X-Original-To: patchwork@mira.cbaines.net Delivered-To: patchwork@mira.cbaines.net Received: by mira.cbaines.net (Postfix, from userid 113) id 837A527BBEA; Thu, 7 Nov 2024 17:12:14 +0000 (GMT) X-Spam-Checker-Version: SpamAssassin 3.4.6 (2021-04-09) on mira.cbaines.net X-Spam-Level: X-Spam-Status: No, score=-6.4 required=5.0 tests=BAYES_00,DKIM_INVALID, DKIM_SIGNED,MAILING_LIST_MULTI,RCVD_IN_DNSWL_BLOCKED, RCVD_IN_VALIDITY_CERTIFIED,RCVD_IN_VALIDITY_RPBL,RCVD_IN_VALIDITY_SAFE, SPF_HELO_PASS,URIBL_BLOCKED autolearn=ham autolearn_force=no version=3.4.6 Received: from lists.gnu.org (lists.gnu.org [209.51.188.17]) by mira.cbaines.net (Postfix) with ESMTPS id CFF0327BBE2 for ; Thu, 7 Nov 2024 17:12:13 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t963B-0003mR-Os; Thu, 07 Nov 2024 12:12:05 -0500 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 1t9638-0003m5-Rr for guix-patches@gnu.org; Thu, 07 Nov 2024 12:12:03 -0500 Received: from debbugs.gnu.org ([2001:470:142:5::43]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1t9638-0002c1-JD for guix-patches@gnu.org; Thu, 07 Nov 2024 12:12:02 -0500 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=debbugs.gnu.org; s=debbugs-gnu-org; h=MIME-Version:References:In-Reply-To:Date:From:To:Subject; bh=O7FtLML3cFF3B1NsUvIsFghtof3lna8NjCbmK1YguEA=; b=Rtf5tEklA5usRCqd/lsEbZSMHk1uHuU91Ri0RsHqoq1Hxx9n0VjPVmjuxTFSBxnBp5efIWIa8QHPSduBGwthXMMwFUVSRzinbS0SMR7vSFXWDfBLefj+tk+gzCWjOIJGHheo0oihVhTByhWVQh5AvoFIIb6LpamX+U5yUc7igLiCqce8dsF23dLIVUTP7etawz4VPhmutwHR4LtTHV7RHpBtvP3FMWns70PK884zWPtD3iPMOkx9GjLzu9rT+0d6U3M1i8HQeOF77GP0k/bRsLqAOEp7rXK+t1+d6It2iu8o8WgoCyyqfgEN3oQoo0hMuVAPuT1nA7KRKoyzDRAubQ==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1t9638-0001LV-Dz for guix-patches@gnu.org; Thu, 07 Nov 2024 12:12:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#74058] [PATCH v3 2/2] etc: news: Warn users about postgresql default update. Resent-From: Nicolas Graves Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Thu, 07 Nov 2024 17:12:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 74058 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 74058@debbugs.gnu.org Cc: Nicolas Graves Received: via spool by 74058-submit@debbugs.gnu.org id=B74058.17309994855123 (code B ref 74058); Thu, 07 Nov 2024 17:12:02 +0000 Received: (at 74058) by debbugs.gnu.org; 7 Nov 2024 17:11:25 +0000 Received: from localhost ([127.0.0.1]:49437 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t962W-0001KY-TP for submit@debbugs.gnu.org; Thu, 07 Nov 2024 12:11:25 -0500 Received: from 1.mo550.mail-out.ovh.net ([178.32.127.22]:53909) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t962U-0001KN-64 for 74058@debbugs.gnu.org; Thu, 07 Nov 2024 12:11:23 -0500 Received: from director4.ghost.mail-out.ovh.net (unknown [10.108.25.74]) by mo550.mail-out.ovh.net (Postfix) with ESMTP id 4XkpWY0NdSz1SfK for <74058@debbugs.gnu.org>; Thu, 7 Nov 2024 17:11:20 +0000 (UTC) Received: from ghost-submission-5b5ff79f4f-thzfn (unknown [10.110.164.49]) by director4.ghost.mail-out.ovh.net (Postfix) with ESMTPS id 91DF71FD60; Thu, 7 Nov 2024 17:11:18 +0000 (UTC) Received: from ngraves.fr ([37.59.142.98]) by ghost-submission-5b5ff79f4f-thzfn with ESMTPSA id WWliL7X0LGfZRgEAgK2MkQ (envelope-from ); Thu, 07 Nov 2024 17:11:18 +0000 Authentication-Results: garm.ovh; auth=pass (GARM-98R002079cba8f-c5eb-4836-a118-a35709a42dc8, 2B264539C56665297410E0ABC0C486ED03F6DD63) smtp.auth=ngraves@ngraves.fr X-OVh-ClientIp: 80.215.103.88 Date: Thu, 7 Nov 2024 18:10:00 +0100 Message-ID: <20241107171006.14868-2-ngraves@ngraves.fr> X-Mailer: git-send-email 2.46.0 In-Reply-To: <20241107171006.14868-1-ngraves@ngraves.fr> References: <20241107171006.14868-1-ngraves@ngraves.fr> MIME-Version: 1.0 X-Ovh-Tracer-Id: 17633844342502056674 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeefuddrtdeggdeljecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvvefufffkofgjfhggtgfgsehtkeertdertdejnecuhfhrohhmpefpihgtohhlrghsucfirhgrvhgvshcuoehnghhrrghvvghssehnghhrrghvvghsrdhfrheqnecuggftrfgrthhtvghrnhepveejheeugfehhfejvdettdeigeektdejteffgeejuedvtdetgfduvdehgffhgeegnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepuddvjedrtddrtddruddpkedtrddvudehrddutdefrdekkedpfeejrdehledrudegvddrleeknecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehinhgvthepuddvjedrtddrtddruddpmhgrihhlfhhrohhmpehnghhrrghvvghssehnghhrrghvvghsrdhfrhdpnhgspghrtghpthhtohepuddprhgtphhtthhopeejgedtheekseguvggssghughhsrdhgnhhurdhorhhgpdfovfetjfhoshhtpehmohehhedtmgdpmhhouggvpehsmhhtphhouhht DKIM-Signature: a=rsa-sha256; bh=O7FtLML3cFF3B1NsUvIsFghtof3lna8NjCbmK1YguEA=; c=relaxed/relaxed; d=ngraves.fr; h=From; s=ovhmo4487190-selector1; t=1730999481; v=1; b=oOF1Tii6CTxjnobCqD9rHyMcKJ9nEwwExD3MPgBKDo265nP3H81+ubWvBV+hTvYnIEUw7luA njD3DxC8/DfvHwGWaeNbhhDVx2GwSzZ12bXwsQvDLpva7MMn/9t4mGuMjGapiBupTsy7sUy6JFb LepTwiNhNj5tTuahRbr/hmR71Rt9zPZhQYKvU9BzBMmtdA47QsMF1+Q3a4WoypU8jpPcadPIml+ BfiG8RLC4A3Dh77FVDq3Ir2Ks+s/qZdH7BmWoqScqTYQPUyxZ2o2N89JjJvgMXazb1K0mTVkrQh jnh3fzrDIzsYOMWYIEgAMoEHXNZeJnJ2ET4AA8DRfG6qg== X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: guix-patches@gnu.org List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Reply-to: Nicolas Graves X-ACL-Warn: , Nicolas Graves via Guix-patches X-Patchwork-Original-From: Nicolas Graves via Guix-patches via From: Nicolas Graves Errors-To: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org Sender: guix-patches-bounces+patchwork=mira.cbaines.net@gnu.org X-getmail-retrieved-from-mailbox: Patches * etc/news.scm: Add entry. --- etc/news.scm | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 43 insertions(+) diff --git a/etc/news.scm b/etc/news.scm index 4929fa2a9a..078adeefb1 100644 --- a/etc/news.scm +++ b/etc/news.scm @@ -25,6 +25,7 @@ ;; Copyright © 2024 Vivien Kraus ;; Copyright © 2024 Guillaume Le Vaillant ;; Copyright © 2024 Zheng Junjie <873216071@qq.com> +;; Copyright © 2024 Nicolas Graves ;; ;; Copying and distribution of this file, with or without modification, are ;; permitted in any medium without royalty provided the copyright notice and @@ -33,6 +34,48 @@ (channel-news (version 0) + (entry (commit "") ; fill-me based on the previous commit + (title (en "PostgreSQL service upgrade") + (fr "Mise à jour du service PostgreSQL")) + (body + (en "\ +This news entry concerns users of the @code{postgresql-service-type}. + +The default PostgreSQL used in @code{postgresql-configuration} has been +deprecated, and will be removed in a few months. However, the value of the +default @code{postgresql-configuration-postgresql} can't be directly changed +to a newer major version of PostgreSQL, because switching to a major version +currently requires a manual update of the database. + +Because of this, the default value of postgresql-configuration-postgresql has +been set to @code{'*no*}. Current users of the service will have to set it +manually. If it was unset, use @code{postgresql-10} and plan an upgrade in the +next month to a supported version of PostgreSQL. To upgrade, you will need to +either dump your database using your previous version of PostgreSQL and reload +it in the new version or use the @command{pg_upgrade} application. See +@url{https://www.postgresql.org/docs/current/upgrading.html} for more +info.") + (fr "\ +Ce message concerne les utilisateurs du service-type PostgreSQL. + +La précédente version par défaut de PostgreSQL utilisée dans +@code{postgresqsl-configuration} est obsolète et sera supprimée dans quelques +mois. Cependant, la valeur de la configuration par défaut +@code{postgresql-configuration-postgresql} ne peut pas être changée +directement pour une version majeure plus récente de PostgreSQL, car le +passage à une nouvelle version majeure nécessite actuellement une mise à jour +manuelle de la base de données. + +Pour cette raison, la valeur par défaut de +@code{postgresql-configuration-postgresql} est maintenant @code{'*no*} et les +utilisateurs actuels du service doivent la configurer manuellement. Si elle +n’était pas définie, utilisez @code{postgresql-10} et prévoyez une mise à jour +dans le mois à venir vers une version plus récente de PostgreSQL. Pour +effectuer la mise à jour, vous devrez soit exporter votre base de données sous +une version de PostgreSQL puis la réimporter sous une nouvelle version, soit +utiliser l'application @command{pg_upgrade}. Pour plus d'informations, +consultez @url{https://www.postgresql.org/docs/current/upgrading.html}."))) + (entry (commit "5966e0fdc78771c562e0f484a22f381a77908be0") (title (en "Daemon vulnerability allowing takeover of build users fixed")