From patchwork Mon Oct 28 11:13:29 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Nicolas Graves X-Patchwork-Id: 69590 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 D6E5A27BBE9; Mon, 28 Oct 2024 11:21:37 +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 1E2C627BBE2 for ; Mon, 28 Oct 2024 11:21:36 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t5NoO-0003Si-6Q; Mon, 28 Oct 2024 07:21:28 -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 1t5NoN-0003SZ-32 for guix-patches@gnu.org; Mon, 28 Oct 2024 07:21:27 -0400 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 1t5NoM-0004s2-RC for guix-patches@gnu.org; Mon, 28 Oct 2024 07:21:26 -0400 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=aDklrjzmLwPtio4Eydo9FRO+xug6xzki2yuAeqASQWs=; b=n8UvLYi4nR9y/WcCObuHN4sFm1J0GHt6k5271zg+Ht+5K+5D4nl98sUUe0WnmlhgA2vYEqFUI90mLlOpYcJf7W0fORoFL9XrZ62/qLnbV2k7GtVDh3osmqPYa9RV77LASbQbcp9+OzZx4PaOVjA589TNGUeWsR8NvriIjP+lEiL9FdWB/0H09LrF0QUt0y1qXwYU1Ab72ApABeG5HKHKwbwHq7Bh1WpsqSIOfIG54sWk1yT9pv0WxWZCsYSC6qRhF3+RpMcCU/4yzPd8pNtXqFJDBOIxQgkfUwwQ/v+txeZOSaJt/l7dqwkg6eFA5ERSCXMYgwYg/URRLrOuRzVrhA==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1t5Now-0002ih-Px for guix-patches@gnu.org; Mon, 28 Oct 2024 07:22:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#74058] [PATCH 1/2] gnu: postgresql-configuration: Set default postgresql to #f. 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: Mon, 28 Oct 2024 11:22: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.173011446810347 (code B ref 74058); Mon, 28 Oct 2024 11:22:02 +0000 Received: (at 74058) by debbugs.gnu.org; 28 Oct 2024 11:21:08 +0000 Received: from localhost ([127.0.0.1]:52742 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t5No3-0002gk-PJ for submit@debbugs.gnu.org; Mon, 28 Oct 2024 07:21:08 -0400 Received: from 9.mo581.mail-out.ovh.net ([46.105.60.248]:47171) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t5No1-0002ga-Ft for 74058@debbugs.gnu.org; Mon, 28 Oct 2024 07:21:06 -0400 Received: from director1.ghost.mail-out.ovh.net (unknown [10.108.2.55]) by mo581.mail-out.ovh.net (Postfix) with ESMTP id 4XcWCH6m5mz1Mh9 for <74058@debbugs.gnu.org>; Mon, 28 Oct 2024 11:20:27 +0000 (UTC) Received: from ghost-submission-5b5ff79f4f-llldq (unknown [10.110.96.131]) by director1.ghost.mail-out.ovh.net (Postfix) with ESMTPS id 1F1C11FFD7; Mon, 28 Oct 2024 11:14:03 +0000 (UTC) Received: from ngraves.fr ([37.59.142.97]) by ghost-submission-5b5ff79f4f-llldq with ESMTPSA id GQCtAPtxH2f9SAAAjYQwFA (envelope-from ); Mon, 28 Oct 2024 11:14:03 +0000 Authentication-Results: garm.ovh; auth=pass (GARM-97G0024046836c-8710-42ba-89d6-535d35668c98, 2EBFFEBE9A2CEA4974D3D0C7E73B7B071B2C9EDA) smtp.auth=ngraves@ngraves.fr X-OVh-ClientIp: 89.85.243.20 Date: Mon, 28 Oct 2024 12:13:29 +0100 Message-ID: <20241028111340.17913-1-ngraves@ngraves.fr> X-Mailer: git-send-email 2.46.0 MIME-Version: 1.0 X-Ovh-Tracer-Id: 8214284247020135138 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeeftddrvdejlecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvvefufffkofgggfestdekredtredttdenucfhrhhomheppfhitgholhgrshcuifhrrghvvghsuceonhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrqeenucggtffrrghtthgvrhhnpeekffegteffgfffjeegjedvfffgtddvueeutefgfeeuvdejgedvgeejjeevueeuveenucfkphepuddvjedrtddrtddruddpkeelrdekhedrvdegfedrvddtpdefjedrheelrddugedvrdeljeenucevlhhushhtvghrufhiiigvpedtnecurfgrrhgrmhepihhnvghtpeduvdejrddtrddtrddupdhmrghilhhfrhhomhepnhhgrhgrvhgvshesnhhgrhgrvhgvshdrfhhrpdhnsggprhgtphhtthhopedupdhrtghpthhtohepjeegtdehkeesuggvsggsuhhgshdrghhnuhdrohhrghdpoffvtefjohhsthepmhhoheekuddpmhhouggvpehsmhhtphhouhht DKIM-Signature: a=rsa-sha256; bh=aDklrjzmLwPtio4Eydo9FRO+xug6xzki2yuAeqASQWs=; c=relaxed/relaxed; d=ngraves.fr; h=From; s=ovhmo4487190-selector1; t=1730114428; v=1; b=bULHRHGswQFsR5w+1Fcko58lbDkKST2eCqvWjB8oaney6aMAOKWupE8Xdz592OXxeD+SAcOH nC1z/7BRBzCYwopGqNs9Z2A32a4j9V4BMvckd9MNAdf0w9DRH/h3UucOoNvuh0Fhxpumun4mVc4 +EmfIQK7A9poCghZYcqTPQfSnBLgrsSs+7LJADwN+7lqPqrewWAJYWdl0kGHIdHP6oCiARYgQjV Tvb2punAJyFrIzqmUg4RrIy15h6Nx7zVFnWyIn3UAWWlbc5XarajBtMZDdFWdtqhFHFUUtVQUDv 62/uqsZ1UjRwwSR+WvXPsBepoO8NgCvamv0zMvKEXkdqg== 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 #f. (postgresql-services): 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 | 10 +++++++--- 1 file changed, 7 insertions(+), 3 deletions(-) diff --git a/gnu/services/databases.scm b/gnu/services/databases.scm index 0933eb5e79..f8ae085339 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? - (postgresql postgresql-configuration-postgresql ;file-like - (default postgresql)) + ;; Setting it to #f 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 or #f + (default #f)) (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 Mon Oct 28 11:13:30 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Nicolas Graves X-Patchwork-Id: 69589 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 1793A27BBEA; Mon, 28 Oct 2024 11:21:01 +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 4082527BBE2 for ; Mon, 28 Oct 2024 11:21:00 +0000 (GMT) Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1t5NnT-0003KE-M6; Mon, 28 Oct 2024 07:20:31 -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 1t5NnQ-0003JY-Vh for guix-patches@gnu.org; Mon, 28 Oct 2024 07:20:29 -0400 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 1t5NnO-0004og-IU for guix-patches@gnu.org; Mon, 28 Oct 2024 07:20:26 -0400 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=ek/VHRxZaFVgVCnB5dapJvc+GHSjl0Ib+7hYCdvaC70=; b=LdtjilfdbhWaIe65mez7NfO1PpiuMBBmHgA+1kv7WMQOG1ma3/KY9aO5R0fcg6qtL4T2aWM9GYFZl1IWM80+qe90Dspg+0KGIZiUoJnDUPxqXWMIg/jMKfzdkMGp0QCS/h1qBj6e/57BpEnyAYoUuv4UtPc8Xh9rqmuz1fJaVc4cj/CP+G97uR5q/Z8uTsEfXBRO8jQMKqeLOPmpHsYRJCmli6fvI3IgE4IO1yyr1wF9DMPmqIKVlduB3NB3hs2Ji5Hv34drcKgQYIpy7nNZQnIoNC4n0sPvPDYbMHaCXjT1e/g7v48xCoVyn0cSopMAGJFs6Yiof6HbwFAfzdRofA==; Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1t5Nny-0002gF-7F for guix-patches@gnu.org; Mon, 28 Oct 2024 07:21:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#74058] [PATCH 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: Mon, 28 Oct 2024 11:21: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.17301144329897 (code B ref 74058); Mon, 28 Oct 2024 11:21:02 +0000 Received: (at 74058) by debbugs.gnu.org; 28 Oct 2024 11:20:32 +0000 Received: from localhost ([127.0.0.1]:52733 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t5NnU-0002ZZ-3J for submit@debbugs.gnu.org; Mon, 28 Oct 2024 07:20:32 -0400 Received: from 8.mo583.mail-out.ovh.net ([178.32.116.78]:32989) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1t5NnQ-0002ZO-I5 for 74058@debbugs.gnu.org; Mon, 28 Oct 2024 07:20:30 -0400 Received: from director3.ghost.mail-out.ovh.net (unknown [10.109.176.101]) by mo583.mail-out.ovh.net (Postfix) with ESMTP id 4XcWBY2HSzz1MtD for <74058@debbugs.gnu.org>; Mon, 28 Oct 2024 11:19:49 +0000 (UTC) Received: from ghost-submission-5b5ff79f4f-crrqw (unknown [10.110.168.145]) by director3.ghost.mail-out.ovh.net (Postfix) with ESMTPS id E53CC20454; Mon, 28 Oct 2024 11:14:49 +0000 (UTC) Received: from ngraves.fr ([37.59.142.101]) by ghost-submission-5b5ff79f4f-crrqw with ESMTPSA id 0dajJylyH2fbdgAAaB9TbA (envelope-from ); Mon, 28 Oct 2024 11:14:49 +0000 Authentication-Results: garm.ovh; auth=pass (GARM-101G00465719d3c-f5d7-4d8a-80b6-60296efad945, 2EBFFEBE9A2CEA4974D3D0C7E73B7B071B2C9EDA) smtp.auth=ngraves@ngraves.fr X-OVh-ClientIp: 89.85.243.20 Date: Mon, 28 Oct 2024 12:13:30 +0100 Message-ID: <20241028111340.17913-2-ngraves@ngraves.fr> X-Mailer: git-send-email 2.46.0 In-Reply-To: <20241028111340.17913-1-ngraves@ngraves.fr> References: <20241028111340.17913-1-ngraves@ngraves.fr> MIME-Version: 1.0 X-Ovh-Tracer-Id: 8226387669740413666 X-VR-SPAMSTATE: OK X-VR-SPAMSCORE: 0 X-VR-SPAMCAUSE: gggruggvucftvghtrhhoucdtuddrgeeftddrvdejlecutefuodetggdotefrodftvfcurfhrohhfihhlvgemucfqggfjpdevjffgvefmvefgnecuuegrihhlohhuthemucehtddtnecunecujfgurhephffvvefufffkofgjfhggtgfgsehtkeertdertdejnecuhfhrohhmpefpihgtohhlrghsucfirhgrvhgvshcuoehnghhrrghvvghssehnghhrrghvvghsrdhfrheqnecuggftrfgrthhtvghrnhepveejheeugfehhfejvdettdeigeektdejteffgeejuedvtdetgfduvdehgffhgeegnecuffhomhgrihhnpehpohhsthhgrhgvshhqlhdrohhrghenucfkphepuddvjedrtddrtddruddpkeelrdekhedrvdegfedrvddtpdefjedrheelrddugedvrddutddunecuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehinhgvthepuddvjedrtddrtddruddpmhgrihhlfhhrohhmpehnghhrrghvvghssehnghhrrghvvghsrdhfrhdpnhgspghrtghpthhtohepuddprhgtphhtthhopeejgedtheekseguvggssghughhsrdhgnhhurdhorhhgpdfovfetjfhoshhtpehmohehkeefpdhmohguvgepshhmthhpohhuth DKIM-Signature: a=rsa-sha256; bh=ek/VHRxZaFVgVCnB5dapJvc+GHSjl0Ib+7hYCdvaC70=; c=relaxed/relaxed; d=ngraves.fr; h=From; s=ovhmo4487190-selector1; t=1730114389; v=1; b=PYfYlMqrImX/ug8FKMNvo/90HHDG291h63Z19c8pWcmDYvQdGplWY54/dIZL0ZIeJPLBRKG0 Nl8JwL3Eo0hEAYFSGm8xSjBkgfixRGD3A707yzERac+RInKIpfzYYwgRMoEuK16t9RWW41A+DkV VeoC1hJS5/qhq0mqbc9RQhObd5JsH8DOr8/n2wqBPBHUYHq+5+aGGjOLh4VLF0E3QUpaptDL6t/ 1aVmmWISF0f6RxJunJbUYBnEp5iBRDgr7PAEdxCofs7H9o5H/Vtz5yUGTNpUtV2azETRuNYoR9V JZXCCRGMUhZS1bYpTu+SDQyuFm+xvEtJXVexq/o8IU5fA== 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 | 41 +++++++++++++++++++++++++++++++++++++++++ 1 file changed, 41 insertions(+) diff --git a/etc/news.scm b/etc/news.scm index 4929fa2a9a..8dc209495a 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,46 @@ (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 postgresql-service-type. + +The default postgresql used in @code{postgresql-configuration} has been +deprecated, and will be removed from Guix 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{#f}. 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 de Guix 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{#f} et les +utilisateurs actuels du service doivent maintenant 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")