From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp1 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id 4B6WHwwX4V/RDQAA0tVLHw (envelope-from ) for ; Mon, 21 Dec 2020 21:43:40 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp1 with LMTPS id sPVNGwwX4V+xPwAAbx9fmQ (envelope-from ) for ; Mon, 21 Dec 2020 21:43:40 +0000 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 C4EC7940355 for ; Mon, 21 Dec 2020 21:43:39 +0000 (UTC) Received: from localhost ([::1]:56062 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1krSxt-0008Mx-Gq for larch@yhetil.org; Mon, 21 Dec 2020 16:43:37 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:34178) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1krSxk-0008MS-BR for help-guix@gnu.org; Mon, 21 Dec 2020 16:43:28 -0500 Received: from mx1.dismail.de ([78.46.223.134]:42482) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1krSxi-0001aL-26 for help-guix@gnu.org; Mon, 21 Dec 2020 16:43:28 -0500 Received: from mx1.dismail.de (localhost [127.0.0.1]) by mx1.dismail.de (OpenSMTPD) with ESMTP id 67088939; Mon, 21 Dec 2020 22:43:21 +0100 (CET) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed; d=dismail.de; h=from:to:cc :subject:references:date:in-reply-to:message-id:mime-version :content-type; s=20190914; bh=/nePlojyWQwvpzAXoiN0fSbzxBUZ/RwzRf Axjp0hqJ8=; b=ZSDLG82C+WDDaS0moShMfmQ7LasMT3xTpsXhAZtC4aGJtJ8aGp ZAWLxeFcByM08IBl2rSl9hAE8WJAs0lNHwbuvMX3qkhLr5ZYU24V0iBNQCmFaKfX LbCBgS5sKf08AU4vaeXwaLeGJYn3jxsERgSXZURkn1+s8IbyHDHfFxNVpnOWby7f a6OyUp9jS8NTx75QJCq0I+MtNSvZxEKNVPk9x0WZDi07hNR7eP4DhD6I/4gwSe/L GegKrVZ8bol/zcCiEvo5CVOORWZoIlDySikNwBuFra0QD5Y5dp68ig8wa0qLtI47 xgtDLqo+XL809dvoqo6juBNqMdu1DoY1gpfg== Received: from smtp1.dismail.de ( [10.240.26.11]) by mx1.dismail.de (OpenSMTPD) with ESMTP id 23aa89f0; Mon, 21 Dec 2020 22:43:20 +0100 (CET) Received: from smtp1.dismail.de (localhost [127.0.0.1]) by smtp1.dismail.de (OpenSMTPD) with ESMTP id 4bd68672; Mon, 21 Dec 2020 22:43:20 +0100 (CET) Received: by dismail.de (OpenSMTPD) with ESMTPSA id f97b7b6f (TLSv1.3:AEAD-AES256-GCM-SHA384:256:NO); Mon, 21 Dec 2020 22:43:19 +0100 (CET) From: Joshua Branson To: Carlo Holl Subject: Re: Running postgres with shepherd as user-level service? References: <20201211090718.euypj7n2sqd62jeh@cehdev> Mail-Followup-To: Carlo Holl , help-guix@gnu.org Date: Mon, 21 Dec 2020 16:43:17 -0500 In-Reply-To: <20201211090718.euypj7n2sqd62jeh@cehdev> (Carlo Holl's message of "Fri, 11 Dec 2020 01:07:18 -0800, Fri, 11 Dec 2020 09:07:19 GMT") Message-ID: <878s9qzvgq.fsf@dismail.de> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=78.46.223.134; envelope-from=jbranso@dismail.de; helo=mx1.dismail.de X-Spam_score_int: -43 X-Spam_score: -4.4 X-Spam_bar: ---- X-Spam_report: (-4.4 / 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_DNSWL_MED=-2.3, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-BeenThere: help-guix@gnu.org X-Mailman-Version: 2.1.23 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Cc: help-guix@gnu.org Errors-To: help-guix-bounces+larch=yhetil.org@gnu.org Sender: "Help-Guix" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.02 Authentication-Results: aspmx1.migadu.com; dkim=pass header.d=dismail.de header.s=20190914 header.b=ZSDLG82C; dmarc=pass (policy=reject) header.from=dismail.de; spf=pass (aspmx1.migadu.com: domain of help-guix-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=help-guix-bounces@gnu.org X-Migadu-Queue-Id: C4EC7940355 X-Spam-Score: -2.02 X-Migadu-Scanner: scn0.migadu.com X-TUID: Uh3jXan2HZ+f Hey Carlo, I am SUPER NOT a guix developer, but I figured I'd respond to your email. Please bear in mind I am making this up as I go along. :) It sounds like your user postgresql service is not even generating a postgresql config file. It sounds like it is error-ing out before anything useful happens. Specifically in while I assume in a guile procedure call to "fport_write". You may need to get into debugging the shepherd. The GNU Guile manual has a section of debugging the shepherd. It's not as pretty as debugging elisp code. (I really hope someone making the debugging guile code as awesome as debugging elisp). Let's test the assumption that your user service of postgresql is NOT generating any postgresql config file. I would ensure that /gnu/store has NO postgresql config files. To do this, remove postgresql from your user profile, and ensure that you DO not have a running postgresql service definition in config.scm. Then do a guix gc. Now do something like: I think this is the right syntax for a recursive grep... #+BEGIN_SRC sh grep -r postgresql /gnu/store #+END_SRC Check for any files and directories that grep shows. Do you see any postgresql configuration files? I would try to load the service as you did before via 'herd load root postgres.scm' and then do a #+BEGIN_SRC sh cat /var/log/messages #+END_SRC You could also try looking at where postgresql logs files, but again it doesn't sound like postgresql is even generating the config file... https://www.postgresql.org/docs/9.1/runtime-config-logging.html When I was debugging my system nginx service, I found it useful to discover what nginx file guix generated. Currently the shepherd doesn't have a way to show you the generated file, but you can do a recursive grep and try to find said config file. You can also try to take a look at the system postgresql service definition in guix-src/gnu/services/databases.scm. Best of luck, Joshua P.S. If the above fails, try dipping an orange in a big barrel of pickle juice, speak the incantation "Relational Databases are fantastic" 5 times, and gently pat your computer thinking the positive affirmation "you are adorable". :) -- Joshua Branson Sent from Emacs and Gnus https://gnucode.me https://video.hardlimit.com/accounts/joshua_branson/video-channels https://propernaming.org "You can have whatever you want, as long as you help enough other people get what they want." - Zig Ziglar