From patchwork Wed Nov 6 17:04:28 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Nicolas Graves X-Patchwork-Id: 69927 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 4A36F27BBEC; Wed, 6 Nov 2024 17:06:32 +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 55C7027BBE9 for ; Wed, 6 Nov 2024 17:06:31 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t8jTp-00048V-DA; Wed, 06 Nov 2024 12:06: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 1t8jTn-000481-9C for guix-patches@gnu.org; Wed, 06 Nov 2024 12:06: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 1t8jTm-0004FB-Ty for guix-patches@gnu.org; Wed, 06 Nov 2024 12:06: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=KOfIQMHh8iBcscdEBO25J5DsEKQ2fU80Z7zTzL2g3Ck=; b=S32orHQGPh0lU1shUM/C5ja02y9aPLTj1JUy/7pM4+FtcAKwUPzU6Gq98ZGSRo3nkl8b61Awwn13as27r9mngQDctMgm/+FIQqkyqOjWEuei0iUAMofNaoxXkunCKz0HtWvNG6Hq73kpVBa5MnaJ9xwMNOqaguZRUfi+2rtVn3ghF8phRXlCpavkMU/SHVRpVHktPzq6N0IE+3VTd8lMyqelTgEGJcu5pN/Sd4Q/mUjrQEwRJ48WiL0bmwmXYRPTXJbMcH7ptprTsjDZnksAwJ2H7lim047LOFXQcv5Tt92xcod/KJ+Vtg7Gmrnx5/1FcFSNOAG3lwayEYo9UfX6og==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1t8jTm-0001rj-Gb for guix-patches@gnu.org; Wed, 06 Nov 2024 12:06:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#74058] [PATCH v2 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: Wed, 06 Nov 2024 17:06: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.17309127056748 (code B ref 74058); Wed, 06 Nov 2024 17:06:02 +0000 Received: (at 74058) by debbugs.gnu.org; 6 Nov 2024 17:05:05 +0000 Received: from localhost ([127.0.0.1]:45294 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t8jSq-0001kN-Rh for submit@debbugs.gnu.org; Wed, 06 Nov 2024 12:05:05 -0500 Received: from 7.mo582.mail-out.ovh.net ([46.105.59.196]:52497) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t8jSm-0001jB-WB for 74058@debbugs.gnu.org; Wed, 06 Nov 2024 12:05:03 -0500 Received: from director3.ghost.mail-out.ovh.net (unknown [10.109.176.8]) by mo582.mail-out.ovh.net (Postfix) with ESMTP id 4XkBQg3Cjsz1Std for <74058@debbugs.gnu.org>; Wed, 6 Nov 2024 17:04:59 +0000 (UTC) Received: from ghost-submission-5b5ff79f4f-rrbh9 (unknown [10.111.182.135]) by director3.ghost.mail-out.ovh.net (Postfix) with ESMTPS id E29441FD39; Wed, 6 Nov 2024 17:04:58 +0000 (UTC) Received: from ngraves.fr ([37.59.142.104]) by ghost-submission-5b5ff79f4f-rrbh9 with ESMTPSA id utvKILqhK2eUhwAAyaLHaA (envelope-from ); Wed, 06 Nov 2024 17:04:58 +0000 Authentication-Results: garm.ovh; auth=pass (GARM-104R005de71380d-deee-484b-a029-7d6ef1c27d0d, 7DA11F85E05AC71F4B07BAB71687C1137F5318AF) smtp.auth=ngraves@ngraves.fr X-OVh-ClientIp: 86.246.19.221 Date: Wed, 6 Nov 2024 18:04:28 +0100 Message-ID: <20241106170439.22888-1-ngraves@ngraves.fr> X-Mailer: git-send-email 2.46.0 MIME-Version: 1.0 X-Ovh-Tracer-Id: 11653908463056577250 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeefuddrtddvgdelgecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvvefufffkofgggfestdekredtredttdenucfhrhhomheppfhitgholhgrshcuifhrrghvvghsuceonhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrqeenucggtffrrghtthgvrhhnpeekffegteffgfffjeegjedvfffgtddvueeutefgfeeuvdejgedvgeejjeevueeuveenucfkphepuddvjedrtddrtddruddpkeeirddvgeeirdduledrvddvuddpfeejrdehledrudegvddruddtgeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeduvdejrddtrddtrddupdhmrghilhhfrhhomhepnhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrpdhnsggprhgtphhtthhopedupdhrtghpthhtohepjeegtdehkeesuggvsggsuhhgshdrghhnuhdrohhrghdpoffvtefjohhsthepmhhoheekvdgmpdhmohguvgepshhmthhpohhuth DKIM-Signature: a=rsa-sha256; bh=KOfIQMHh8iBcscdEBO25J5DsEKQ2fU80Z7zTzL2g3Ck=; c=relaxed/relaxed; d=ngraves.fr; h=From; s=ovhmo4487190-selector1; t=1730912699; v=1; b=dkBNruDaJ+8s5vByAtX6Ev6Qj3MH3ne3emByWyyyNLZPAXPhNYEdc4UqF5G3zXdl8i4cYM1o WxNRbZd/YDWJzsfSZjWt6leiOmHn7r9Eu/EpkUGTFY7sJFsW5cK9ggdeUHpO5Ws2hpG14IBqAAc LtZiOSCzSkMAS7AhymkHVBY6TMeHqZQQZ5cV3B/1dsthYowtWoWQf6McHE2w5NRA77len/G4/JB WTdpnStEBTYr25KuCHoeeCzXTU/Ke1Xnsqyip/VIKKPCUdS5AK+8oTz7XppYc0/lFKjzowHY130 xhvWktuEVsI26JYUhoLmgJ0b8IgTjUGiOS7NyC6bgmw+Q== 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..05e2c5f996 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 Wed Nov 6 17:04:29 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Nicolas Graves X-Patchwork-Id: 69928 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 9A00A27BBE2; Wed, 6 Nov 2024 17:06:33 +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=unavailable 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 5639927BBEA for ; Wed, 6 Nov 2024 17:06:31 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t8jTq-000491-86; Wed, 06 Nov 2024 12:06:06 -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 1t8jTn-000485-EI for guix-patches@gnu.org; Wed, 06 Nov 2024 12:06: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 1t8jTn-0004FH-5i for guix-patches@gnu.org; Wed, 06 Nov 2024 12:06: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:References:In-Reply-To:Date:From:To:Subject; bh=nSGI6J5TmIHKfmyWlWLzhK6FnwRvCy+LudMhmyjcmrE=; b=l2bibVx/1fUboqmdxu+fyQPVyVa/LYwXgDTEf2JKWQ21HmmnclB7IvrUwktUVNv4gKgHzJcZBW5yb9HWkykJznzj74dLjWjUebWyP+qAkjRsHpQozkzLYw2VshT4NcoQ/WThC2Z9WSMbFwcu9LuhmO6h6McRtXXAHCbhR0vefgvv+2UWpW5AcRLreILhqyUqiDUUs53f44n5Q9DqDo+nS4OqWzaeDYPndfqw5AqSFxTjEYPzWqVbVIuxa/C7xehKZVazcrH/7A8LE6+rROVERp0IgTaBci5ZmtzSvAX/mQ8FubrnS4qbqJugYT0nBZHsQw2ID9eg/sDqtraeLjYCmw==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1t8jTn-0001rq-09 for guix-patches@gnu.org; Wed, 06 Nov 2024 12:06:03 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#74058] [PATCH v2 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: Wed, 06 Nov 2024 17:06: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.17309127086870 (code B ref 74058); Wed, 06 Nov 2024 17:06:02 +0000 Received: (at 74058) by debbugs.gnu.org; 6 Nov 2024 17:05:08 +0000 Received: from localhost ([127.0.0.1]:45297 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t8jSt-0001lo-B8 for submit@debbugs.gnu.org; Wed, 06 Nov 2024 12:05:07 -0500 Received: from 15.mo584.mail-out.ovh.net ([91.121.62.11]:58921) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t8jSq-0001je-4Z for 74058@debbugs.gnu.org; Wed, 06 Nov 2024 12:05:05 -0500 Received: from director9.ghost.mail-out.ovh.net (unknown [10.109.176.8]) by mo584.mail-out.ovh.net (Postfix) with ESMTP id 4XkBQk4rNrz1B7n for <74058@debbugs.gnu.org>; Wed, 6 Nov 2024 17:05:02 +0000 (UTC) Received: from ghost-submission-5b5ff79f4f-9qq8c (unknown [10.110.188.182]) by director9.ghost.mail-out.ovh.net (Postfix) with ESMTPS id CD8AF1FEB1; Wed, 6 Nov 2024 17:05:01 +0000 (UTC) Received: from ngraves.fr ([37.59.142.108]) by ghost-submission-5b5ff79f4f-9qq8c with ESMTPSA id 4+kWIL2hK2dFQwEALUP6tQ (envelope-from ); Wed, 06 Nov 2024 17:05:01 +0000 Authentication-Results: garm.ovh; auth=pass (GARM-108S0028d6b954f-895c-475a-bdd1-ddc55db96063, 7DA11F85E05AC71F4B07BAB71687C1137F5318AF) smtp.auth=ngraves@ngraves.fr X-OVh-ClientIp: 86.246.19.221 Date: Wed, 6 Nov 2024 18:04:29 +0100 Message-ID: <20241106170439.22888-2-ngraves@ngraves.fr> X-Mailer: git-send-email 2.46.0 In-Reply-To: <20241106170439.22888-1-ngraves@ngraves.fr> References: <20241106170439.22888-1-ngraves@ngraves.fr> MIME-Version: 1.0 X-Ovh-Tracer-Id: 11654752886253085410 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeefuddrtddvgdelgecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvvefufffkofgjfhggtgfgsehtkeertdertdejnecuhfhrohhmpefpihgtohhlrghsucfirhgrvhgvshcuoehnghhrrghvvghssehnghhrrghvvghsrdhfrheqnecuggftrfgrthhtvghrnhepveejheeugfehhfejvdettdeigeektdejteffgeejuedvtdetgfduvdehgffhgeegnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepuddvjedrtddrtddruddpkeeirddvgeeirdduledrvddvuddpfeejrdehledrudegvddruddtkeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeduvdejrddtrddtrddupdhmrghilhhfrhhomhepnhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrpdhnsggprhgtphhtthhopedupdhrtghpthhtohepjeegtdehkeesuggvsggsuhhgshdrghhnuhdrohhrghdpoffvtefjohhsthepmhhoheekgegmpdhmohguvgepshhmthhpohhuth DKIM-Signature: a=rsa-sha256; bh=nSGI6J5TmIHKfmyWlWLzhK6FnwRvCy+LudMhmyjcmrE=; c=relaxed/relaxed; d=ngraves.fr; h=From; s=ovhmo4487190-selector1; t=1730912702; v=1; b=VHD72fP3MsgiJ2AHqlFKwePOFe86w4uIJG3tv2hv2rD5l07bB7BLxgA/JsFnq6Lk+1bT9Gdc ZXGe+uXA4PWoOEC7cBjT1r/XyTcHFdVXpFdbM8DMJOo9TnAcdwkZ8FhXFtYKuncNXQ1kzd174Ty nclR9ZFGYdTmxFeOMoeEHhYnV/qgmHJCIvZF6K8n8izHkh3DyMg1Ggfy5If90BEXwRnBwrF4xtA qYR7IpqcETFgWq3jeQWtM2wkaZPgrhA+n7eIMaoyOB9tqwDjenZKlbCxYdbBGPKVFcg2sGPG35/ /YsBeFWgT9ktIYkP3rJQ8mf+6zHhqjugz4ni+PdHMTDKQ== 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..1dc8e64a72 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")