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 kJatCBMOGWBOXQAA0tVLHw (envelope-from ) for ; Tue, 02 Feb 2021 08:32:19 +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 OMFmBBMOGWANRQAAbx9fmQ (envelope-from ) for ; Tue, 02 Feb 2021 08:32:19 +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 AA92C940355 for ; Tue, 2 Feb 2021 08:32:18 +0000 (UTC) Received: from localhost ([::1]:39626 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1l6r6f-0001Yq-E5 for larch@yhetil.org; Tue, 02 Feb 2021 03:32:17 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:55616) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6r6Q-0001YO-BT for guix-patches@gnu.org; Tue, 02 Feb 2021 03:32:02 -0500 Received: from debbugs.gnu.org ([209.51.188.43]:50663) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1l6r6Q-0000x3-3N for guix-patches@gnu.org; Tue, 02 Feb 2021 03:32:02 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1l6r6Q-0007Hq-0U for guix-patches@gnu.org; Tue, 02 Feb 2021 03:32:02 -0500 X-Loop: help-debbugs@gnu.org Subject: [bug#46249] [PATCH] Update documented default PostgreSQL socket-directory Resent-From: Mathieu Othacehe Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Tue, 02 Feb 2021 08:32:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 46249 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 46249@debbugs.gnu.org X-Debbugs-Original-To: guix-patches--- via Received: via spool by submit@debbugs.gnu.org id=B.161225470227968 (code B ref -1); Tue, 02 Feb 2021 08:32:01 +0000 Received: (at submit) by debbugs.gnu.org; 2 Feb 2021 08:31:42 +0000 Received: from localhost ([127.0.0.1]:33973 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6r66-0007H2-Kt for submit@debbugs.gnu.org; Tue, 02 Feb 2021 03:31:42 -0500 Received: from lists.gnu.org ([209.51.188.17]:33758) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6r63-0007Gs-Ap for submit@debbugs.gnu.org; Tue, 02 Feb 2021 03:31:42 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:55558) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6r63-0001WG-4P for guix-patches@gnu.org; Tue, 02 Feb 2021 03:31:39 -0500 Received: from fencepost.gnu.org ([2001:470:142:3::e]:41957) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1l6r62-0000m4-LQ; Tue, 02 Feb 2021 03:31:38 -0500 Received: from [2a01:e0a:19b:d9a0:cc2b:41f6:b1d8:bba6] (port=42958 helo=cervin) by fencepost.gnu.org with esmtpsa (TLS1.2:RSA_AES_256_CBC_SHA1:256) (Exim 4.82) (envelope-from ) id 1l6r60-0003st-VX; Tue, 02 Feb 2021 03:31:38 -0500 From: Mathieu Othacehe References: <87wnvrtjpv.fsf@sturm.com.au> Date: Tue, 02 Feb 2021 09:31:35 +0100 In-Reply-To: <87wnvrtjpv.fsf@sturm.com.au> (guix-patches@gnu.org's message of "Tue, 02 Feb 2021 11:08:12 +1100") Message-ID: <87y2g6an14.fsf@gnu.org> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/27.1 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain 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: , Cc: Ben Sturmfels , 46249-done@debbugs.gnu.org Errors-To: guix-patches-bounces+larch=yhetil.org@gnu.org Sender: "Guix-patches" X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.86 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=pass (policy=none) header.from=gnu.org; spf=pass (aspmx1.migadu.com: domain of guix-patches-bounces@gnu.org designates 209.51.188.17 as permitted sender) smtp.mailfrom=guix-patches-bounces@gnu.org X-Migadu-Queue-Id: AA92C940355 X-Spam-Score: -2.86 X-Migadu-Scanner: scn0.migadu.com X-TUID: 93qZgfk0TUf4 Hey Ben, > It looks like the documented default for PostgreSQL's socket-directory > variable should be "/var/run/postgresql", when it's currently > "/var/lib/postgresql" (the data directory). I've attached a patch. > Here's the original commit (thanks lfam for the IRC help): That's a dumb mistake on my part, thanks for fixing it. > https://git.savannah.gnu.org/cgit/guix.git/commit/?id=6c0679215f4ffa534c1eb2e8c8a6e043a0c993fe > > Also noticed that since a recent reconfigure, my `psql` and `createdb` > commands now need an explicit `-h /var/run/postgresql` argument to > connect to the local database where one wasn't needed before - they look > in /tmp by default. Yes when the socket directory is enabled in PostgreSQL those tools try to use it but with the default directory set to "/tmp". I have pushed a patch on core-updates to set the default socket directory to "/var/run/postgresql" like most of the other distributions. In the meantime you can set the "socket-directory" field of "postgresql-config-file" to #f to restore the previous behaviour. Thanks, Mathieu