From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp12.migadu.com ([2001:41d0:403:4789::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms9.migadu.com with LMTPS id 8DJyKeT0t2QyZQAASxT56A (envelope-from ) for ; Wed, 19 Jul 2023 16:36:20 +0200 Received: from aspmx1.migadu.com ([2001:41d0:403:4789::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp12.migadu.com with LMTPS id MPIEKeT0t2QUNgAAauVa8A (envelope-from ) for ; Wed, 19 Jul 2023 16:36:20 +0200 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 684CE3A8A8 for ; Wed, 19 Jul 2023 16:36:19 +0200 (CEST) Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=baulig.is header.s=protonmail2 header.b="UG3zXR/z"; 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=pass (policy=none) header.from=baulig.is ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=yhetil.org; s=key1; t=1689777380; 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: content-transfer-encoding:content-transfer-encoding: in-reply-to:in-reply-to:references:references:list-id:list-help: list-unsubscribe:list-subscribe:list-post:dkim-signature; bh=X0TBhkBGY2UaqAXJfUqgOaWKAXf7c0wAnQI+YGRiVpU=; b=L9bf21cuXnQT3N3Nem6UgvoT7I5XariaQXMXunPnW6ODLl3KnYrps/uzXFBsWTJN/YL7zN Tah7DxtA/afxl90csdSojtsNiwJuSJgIKs5tZQp7xQnlDduY2SvjHg1VXETsq5Tk8Yd9ze vyQovc94YMKFs/Yo4osNn41/9UdwqLC0Xzyjgp1LchZNuhhLtAMWsuoLgviS49HTdQ7Vnk EGyZ0lC/B2EADSPE8EXQM3qBzE1t564BgHeolSxn3o+zTeEMdtttBnqALK2wqRiYxuHs5s i319gVuPHugkQtfbBjBajM5jzE+oE/mA6zAq4Jvu51NcCKRyhOkqMejli/+Wcw== ARC-Seal: i=1; s=key1; d=yhetil.org; t=1689777380; a=rsa-sha256; cv=none; b=uetxLcXpamIcABRFwvlJK2qWaqeasWUqjkWmnbp4lreCdSISa7PEzCjaKRurmXhTA1Zevs thyorS8XJlsJzV0kEeRBAFXg0Ae7WH19efuD1xhROw0j1sqEB3D6o/Vw39tbFm4SuPUXAP n8lnepcB0ipHPS7G+LSZLuQMYUhkb2fGvQiIiNpGa+JtcR3QsRervimSf2gMfmvA1Fnxi0 cfYN31YVGXMsxDhjWmY59pb4kg4NDc4ONPONLOLoN73MyNk5JpwR9sneoxm0eseFzE7Xjv svKmUTan4vViMGLWKqJO1ZQZsHGF73Q/ual12RvHfWGwKZTKhgwi9SSnBIElWA== ARC-Authentication-Results: i=1; aspmx1.migadu.com; dkim=pass header.d=baulig.is header.s=protonmail2 header.b="UG3zXR/z"; 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=pass (policy=none) header.from=baulig.is Received: from localhost ([::1] helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1qM8HT-0002fk-9G; Wed, 19 Jul 2023 10:35:55 -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 1qM8HQ-0002fH-BM for guix-devel@gnu.org; Wed, 19 Jul 2023 10:35:52 -0400 Received: from mail-4018.proton.ch ([185.70.40.18]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1qM8HN-00083X-9E for guix-devel@gnu.org; Wed, 19 Jul 2023 10:35:51 -0400 Date: Wed, 19 Jul 2023 14:35:19 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=baulig.is; s=protonmail2; t=1689777332; x=1690036532; bh=X0TBhkBGY2UaqAXJfUqgOaWKAXf7c0wAnQI+YGRiVpU=; h=Date:To:From:Cc:Subject:Message-ID:In-Reply-To:References: Feedback-ID:From:To:Cc:Date:Subject:Reply-To:Feedback-ID: Message-ID:BIMI-Selector; b=UG3zXR/zEU5HvB3QDNYgAGm4SmNzk4dIpHNYkTV+vA6c6i20cyXn+Xa9Oy8x9Yc9a xPDzKuEnla8kqdJwVEbtx3sA9aD029079lygSr3QUsOkaN1dAXWfzjzjUDwjCEgQQR x7H0HowMSPoyV9N/2XDvjbziQmMAHC35s3XIcOjIszDUoiRAlGdQ4bfJ2AXHraPEKU 3ruCzTySlcCzP+DktSSkTRjV1+LiUiZR3svfpMRO1Eh9xMiuimEO1YDog0kdPfjjzC lQxN/pHi2ww4itlc5L7qKtcz27kCLuik9TALNDYEk8NDv7ibjN+enEjA6CAsW46r6i GMOrAjAu4/PFw== To: Denis 'GNUtoo' Carikli From: Martin Baulig Cc: "guix-devel@gnu.org" Subject: Re: Postgres user UID and GID Message-ID: In-Reply-To: <20230719001038.4232a249@primary_laptop> References: <20230717214920.32382c6b@primary_laptop> <20230719001038.4232a249@primary_laptop> Feedback-ID: 66823742:user:proton MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=185.70.40.18; envelope-from=martin@baulig.is; helo=mail-4018.proton.ch X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_MSPIKE_H5=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, T_SCC_BODY_TEXT_LINE=-0.01 autolearn=ham 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: -9.59 X-Spam-Score: -9.59 X-Migadu-Queue-Id: 684CE3A8A8 X-Migadu-Scanner: mx1.migadu.com X-TUID: poqXR7Z2hPfi Hello, I played around a little bit with that, and it seems like you'll end up get= ting two entries for the 'postgres' user in your /etc/passwd if you just ignore the warning. And th= e order doesn't seem to be consistent. Here in my current patch: https://gitlab.com/martin-baulig/forks/guix/-/commit/5710b3bff17f4edaa7af39= 7108e08f4dc842adef And my current config is here: https://gitlab.com/martin-baulig/config-and-setup/guix-packages/-/blob/work= -postgres/packages/baulig/config/lothlorien/postgresql.scm#L25 I wasn't sure whether the (create-accout?) is really needed, probably not b= ecause you really need that postgres service account. Already wanted to remove that and submit a patch, but then got distracted b= y my new "secrets service". I'm running some complex packages on GNU Guix - Bacula, Loki / Promtail and= the GitLab Runner - and am currently cleaning up things nicely, to possibly upstream some of that. Best regards, Martin ------- Original Message ------- On Tuesday, July 18th, 2023 at 10:10 PM, Denis 'GNUtoo' Carikli wrote: >=20 >=20 > On Mon, 17 Jul 2023 21:35:00 +0000 > Martin Baulig martin@baulig.is wrote: >=20 > > If I use the unmodified service and with the (operating-system (user > > ...)) entry, it works sometimes, but not reliably due to having two > > conflicting entries for the 'postgres' user. >=20 > I see. So if I touch too much my system it could break at any time then. >=20 > Denis.