From unknown Sat Sep 06 14:23:35 2025 X-Loop: help-debbugs@gnu.org Subject: [bug#46249] [PATCH] Update documented default PostgreSQL socket-directory Resent-From: Ben Sturmfels Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Tue, 02 Feb 2021 00:09:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 46249 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 46249@debbugs.gnu.org X-Debbugs-Original-To: guix-patches@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.161222450429272 (code B ref -1); Tue, 02 Feb 2021 00:09:01 +0000 Received: (at submit) by debbugs.gnu.org; 2 Feb 2021 00:08:24 +0000 Received: from localhost ([127.0.0.1]:33573 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6jF2-0007c4-62 for submit@debbugs.gnu.org; Mon, 01 Feb 2021 19:08:24 -0500 Received: from lists.gnu.org ([209.51.188.17]:36600) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6jEz-0007bv-7P for submit@debbugs.gnu.org; Mon, 01 Feb 2021 19:08:22 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:39980) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6jEz-0002r6-2K for guix-patches@gnu.org; Mon, 01 Feb 2021 19:08:21 -0500 Received: from out4-smtp.messagingengine.com ([66.111.4.28]:48187) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6jEx-0002wC-6D for guix-patches@gnu.org; Mon, 01 Feb 2021 19:08:20 -0500 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 975465C01B0 for ; Mon, 1 Feb 2021 19:08:17 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Mon, 01 Feb 2021 19:08:17 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sturm.com.au; h= from:to:subject:date:message-id:mime-version:content-type; s= fm2; bh=N6XIdeTIKPbMa0dgQwqcSyIqStUJVVmfXAK4gFNF2Og=; b=IUTsHvBr Pf2avW3pGhfXQbfejuMlAk/wLKbZAY9k1jJTKuYlRfhbxXZlsCpShZWfrTeVDycj +n3eib5bWY4FUARNi9HQDR+OzGMekG+DyZQvuiWMcatsrGS95Y0C0q74A/bPn0KI 9rjaQCdW+yKdLXX/3huzsW39ygOwzSerXSF5F3o6x20pLHnvDjYPCLo7N6c3io/K jWDotX7S4v1XjfHgkHXZrdgO6Dvwz30szrwFEnmE1NKfDPWo/bZnauBR8GIqo+ui jI/ABAQ9y8x1JC6MSKo4+A7bUuWsTh+gRfkcClpw0R7pQZBA7lAzJbKoJNICYY9q ALrG3yd6DBLy/A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; bh=N6XIdeTIKPbMa0dgQwqcSyIqStUJV VmfXAK4gFNF2Og=; b=cIgWAmeozlAZt63how/BSIXieHacwFKEhUNdAilwKmO/n 72hGEFtLXEKUz8XBUMONQsxrbZ7PYO1lEpoXM87S5uXmCNLiAVJc4Mm+C8vKtdag m00OPl/Xj7znNH0W09VfvhKD2SjAhagOwoRdRqrvMwo8oF1ovPpGq0Yx7ED/Xzbt MIGxuL4mcsIr2k6STJnkjE7/eCi2qsMxfZjKsmmPU6IaPDNl91weZz5CGW2A5W9U 2uiR/jk8p2W6NXt2BobHY1/DGRiLYIx0H4bZJ2gYh0BVew53MPFxuK2b/FVaADRZ 7vxv1D14SjuLOIRHB8F9k6af19TlEgiFTtxxvld6g== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrfeelgdduvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfgfhvffufffkgggtsehmtderredtre dtnecuhfhrohhmpeeuvghnucfuthhurhhmfhgvlhhsuceosggvnhesshhtuhhrmhdrtgho mhdrrghuqeenucggtffrrghtthgvrhhnpedvffeffeekfeffleekjeetfeeiffffiedvve ffieevvddthfffffekieekfeekueenucffohhmrghinhepghhnuhdrohhrghenucfkphep vddtfedrvddugedrudefvddrudejtdenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpegsvghnsehsthhurhhmrdgtohhmrdgruh X-ME-Proxy: Received: from Marseille (203-214-132-170.perm.iinet.net.au [203.214.132.170]) by mail.messagingengine.com (Postfix) with ESMTPA id 7459A24005D for ; Mon, 1 Feb 2021 19:08:16 -0500 (EST) User-agent: mu4e 1.4.14; emacs 27.1 From: Ben Sturmfels Date: Tue, 02 Feb 2021 11:08:12 +1100 Message-ID: <87wnvrtjpv.fsf@sturm.com.au> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Received-SPF: pass client-ip=66.111.4.28; envelope-from=ben@sturm.com.au; helo=out4-smtp.messagingengine.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.6 (-) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.6 (--) --=-=-= Content-Type: text/plain Hi Folks, 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): 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. Regards, Ben --=-=-= Content-Type: text/x-patch Content-Disposition: inline; filename=postgres_update_socket_directory.patch >From bfd7c9f015718eadd62bac0e85aa4a3b38a556d4 Mon Sep 17 00:00:00 2001 From: Ben Sturmfels Date: Tue, 2 Feb 2021 10:49:21 +1100 Subject: [PATCH] services: postgresql: Update documented socket directory to match code. * doc/guix.texi (Database Services): Update it. --- doc/guix.texi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/guix.texi b/doc/guix.texi index beff276f9d..b75c4f505c 100644 --- a/doc/guix.texi +++ b/doc/guix.texi @@ -19531,7 +19531,7 @@ configuration. @item @code{ident-file} (default: @code{%default-postgres-ident}) Filename or G-expression for the user name mapping configuration. -@item @code{socket-directory} (default: @code{"/var/lib/postgresql"}) +@item @code{socket-directory} (default: @code{"/var/run/postgresql"}) Specifies the directory of the Unix-domain socket(s) on which PostgreSQL is to listen for connections from client applications. If set to @code{#false} PostgreSQL does not listen on any Unix-domain sockets, in -- 2.30.0 --=-=-=-- From unknown Sat Sep 06 14:23:35 2025 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 Cc: Ben Sturmfels , 46249-done@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-Spam-Score: -2.3 (--) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) 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 From unknown Sat Sep 06 14:23:35 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: Ben Sturmfels Subject: bug#46249: closed (Re: [bug#46249] [PATCH] Update documented default PostgreSQL socket-directory) Message-ID: References: <87y2g6an14.fsf@gnu.org> <87wnvrtjpv.fsf@sturm.com.au> X-Gnu-PR-Message: they-closed 46249 X-Gnu-PR-Package: guix-patches X-Gnu-PR-Keywords: patch Reply-To: 46249@debbugs.gnu.org Date: Tue, 02 Feb 2021 08:32:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1612254722-28020-1" This is a multi-part message in MIME format... ------------=_1612254722-28020-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #46249: [PATCH] Update documented default PostgreSQL socket-directory which was filed against the guix-patches package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 46249@debbugs.gnu.org. --=20 46249: http://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D46249 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1612254722-28020-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at 46249-done) by debbugs.gnu.org; 2 Feb 2021 08:31:49 +0000 Received: from localhost ([127.0.0.1]:33976 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6r6C-0007HM-Sl for submit@debbugs.gnu.org; Tue, 02 Feb 2021 03:31:49 -0500 Received: from eggs.gnu.org ([209.51.188.92]:37694) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6r68-0007Gr-3Y for 46249-done@debbugs.gnu.org; Tue, 02 Feb 2021 03:31:47 -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 To: guix-patches--- via Subject: Re: [bug#46249] [PATCH] Update documented default PostgreSQL socket-directory 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-Spam-Score: -0.0 (/) X-Debbugs-Envelope-To: 46249-done Cc: Ben Sturmfels , 46249-done@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -1.7 (-) 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 ------------=_1612254722-28020-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit Received: (at submit) by debbugs.gnu.org; 2 Feb 2021 00:08:24 +0000 Received: from localhost ([127.0.0.1]:33573 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6jF2-0007c4-62 for submit@debbugs.gnu.org; Mon, 01 Feb 2021 19:08:24 -0500 Received: from lists.gnu.org ([209.51.188.17]:36600) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6jEz-0007bv-7P for submit@debbugs.gnu.org; Mon, 01 Feb 2021 19:08:22 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:39980) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6jEz-0002r6-2K for guix-patches@gnu.org; Mon, 01 Feb 2021 19:08:21 -0500 Received: from out4-smtp.messagingengine.com ([66.111.4.28]:48187) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6jEx-0002wC-6D for guix-patches@gnu.org; Mon, 01 Feb 2021 19:08:20 -0500 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 975465C01B0 for ; Mon, 1 Feb 2021 19:08:17 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Mon, 01 Feb 2021 19:08:17 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sturm.com.au; h= from:to:subject:date:message-id:mime-version:content-type; s= fm2; bh=N6XIdeTIKPbMa0dgQwqcSyIqStUJVVmfXAK4gFNF2Og=; b=IUTsHvBr Pf2avW3pGhfXQbfejuMlAk/wLKbZAY9k1jJTKuYlRfhbxXZlsCpShZWfrTeVDycj +n3eib5bWY4FUARNi9HQDR+OzGMekG+DyZQvuiWMcatsrGS95Y0C0q74A/bPn0KI 9rjaQCdW+yKdLXX/3huzsW39ygOwzSerXSF5F3o6x20pLHnvDjYPCLo7N6c3io/K jWDotX7S4v1XjfHgkHXZrdgO6Dvwz30szrwFEnmE1NKfDPWo/bZnauBR8GIqo+ui jI/ABAQ9y8x1JC6MSKo4+A7bUuWsTh+gRfkcClpw0R7pQZBA7lAzJbKoJNICYY9q ALrG3yd6DBLy/A== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=content-type:date:from:message-id :mime-version:subject:to:x-me-proxy:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; bh=N6XIdeTIKPbMa0dgQwqcSyIqStUJV VmfXAK4gFNF2Og=; b=cIgWAmeozlAZt63how/BSIXieHacwFKEhUNdAilwKmO/n 72hGEFtLXEKUz8XBUMONQsxrbZ7PYO1lEpoXM87S5uXmCNLiAVJc4Mm+C8vKtdag m00OPl/Xj7znNH0W09VfvhKD2SjAhagOwoRdRqrvMwo8oF1ovPpGq0Yx7ED/Xzbt MIGxuL4mcsIr2k6STJnkjE7/eCi2qsMxfZjKsmmPU6IaPDNl91weZz5CGW2A5W9U 2uiR/jk8p2W6NXt2BobHY1/DGRiLYIx0H4bZJ2gYh0BVew53MPFxuK2b/FVaADRZ 7vxv1D14SjuLOIRHB8F9k6af19TlEgiFTtxxvld6g== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrfeelgdduvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfgfhvffufffkgggtsehmtderredtre dtnecuhfhrohhmpeeuvghnucfuthhurhhmfhgvlhhsuceosggvnhesshhtuhhrmhdrtgho mhdrrghuqeenucggtffrrghtthgvrhhnpedvffeffeekfeffleekjeetfeeiffffiedvve ffieevvddthfffffekieekfeekueenucffohhmrghinhepghhnuhdrohhrghenucfkphep vddtfedrvddugedrudefvddrudejtdenucevlhhushhtvghrufhiiigvpedtnecurfgrrh grmhepmhgrihhlfhhrohhmpegsvghnsehsthhurhhmrdgtohhmrdgruh X-ME-Proxy: Received: from Marseille (203-214-132-170.perm.iinet.net.au [203.214.132.170]) by mail.messagingengine.com (Postfix) with ESMTPA id 7459A24005D for ; Mon, 1 Feb 2021 19:08:16 -0500 (EST) User-agent: mu4e 1.4.14; emacs 27.1 From: Ben Sturmfels To: guix-patches@gnu.org Subject: [PATCH] Update documented default PostgreSQL socket-directory Date: Tue, 02 Feb 2021 11:08:12 +1100 Message-ID: <87wnvrtjpv.fsf@sturm.com.au> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=-=-=" Received-SPF: pass client-ip=66.111.4.28; envelope-from=ben@sturm.com.au; helo=out4-smtp.messagingengine.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.6 (-) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.6 (--) --=-=-= Content-Type: text/plain Hi Folks, 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): 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. Regards, Ben --=-=-= Content-Type: text/x-patch Content-Disposition: inline; filename=postgres_update_socket_directory.patch >From bfd7c9f015718eadd62bac0e85aa4a3b38a556d4 Mon Sep 17 00:00:00 2001 From: Ben Sturmfels Date: Tue, 2 Feb 2021 10:49:21 +1100 Subject: [PATCH] services: postgresql: Update documented socket directory to match code. * doc/guix.texi (Database Services): Update it. --- doc/guix.texi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/doc/guix.texi b/doc/guix.texi index beff276f9d..b75c4f505c 100644 --- a/doc/guix.texi +++ b/doc/guix.texi @@ -19531,7 +19531,7 @@ configuration. @item @code{ident-file} (default: @code{%default-postgres-ident}) Filename or G-expression for the user name mapping configuration. -@item @code{socket-directory} (default: @code{"/var/lib/postgresql"}) +@item @code{socket-directory} (default: @code{"/var/run/postgresql"}) Specifies the directory of the Unix-domain socket(s) on which PostgreSQL is to listen for connections from client applications. If set to @code{#false} PostgreSQL does not listen on any Unix-domain sockets, in -- 2.30.0 --=-=-=-- ------------=_1612254722-28020-1-- From unknown Sat Sep 06 14:23:35 2025 X-Loop: help-debbugs@gnu.org Subject: [bug#46249] [PATCH] Update documented default PostgreSQL socket-directory Resent-From: Ben Sturmfels Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Tue, 02 Feb 2021 11:21:02 +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: Mathieu Othacehe Cc: 46249-done@debbugs.gnu.org, 46249@debbugs.gnu.org, ben@sturm.com.au X-Debbugs-Original-Cc: 46249-done@debbugs.gnu.org, guix-patches--- via , Ben Sturmfels Received: via spool by submit@debbugs.gnu.org id=B.16122648324842 (code B ref -1); Tue, 02 Feb 2021 11:21:02 +0000 Received: (at submit) by debbugs.gnu.org; 2 Feb 2021 11:20:32 +0000 Received: from localhost ([127.0.0.1]:34240 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6tjT-0001Fw-Qe for submit@debbugs.gnu.org; Tue, 02 Feb 2021 06:20:32 -0500 Received: from lists.gnu.org ([209.51.188.17]:44276) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1l6tjQ-0001Fd-62 for submit@debbugs.gnu.org; Tue, 02 Feb 2021 06:20:30 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:59176) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6tjP-00045J-Vc for guix-patches@gnu.org; Tue, 02 Feb 2021 06:20:28 -0500 Received: from out2-smtp.messagingengine.com ([66.111.4.26]:58221) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6tjN-00029S-QV; Tue, 02 Feb 2021 06:20:27 -0500 Received: from compute6.internal (compute6.nyi.internal [10.202.2.46]) by mailout.nyi.internal (Postfix) with ESMTP id 4E65D5C01E9; Tue, 2 Feb 2021 06:20:23 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Tue, 02 Feb 2021 06:20:23 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=sturm.com.au; h= references:from:to:cc:subject:in-reply-to:date:message-id :mime-version:content-type; s=fm2; bh=K5xJUC9KJmOc07iYRaClaEUp2q jbg0u93ide2zG42pI=; b=bwspldJGkTOzI54RmbVupVlAtnNVyST7cmBIQf7ANk r4J8SdH2BKdNiub5zU2f8GXReGPpM+7qnEGvqam1IYnxPbnHK6dH4svVSfCytyIe 4IMrw9BJC6+2WgUQ61IHeMMBMlzDB+T14fAef50jV5VNMwinILoiB51dLCuI/u5+ u2mbYUDcs4rPdi9wSRbW44LQbuNrpf/0j9cfRQG0SYl0i6SLj0i1LSYPbEXDRjM3 sZsO8lvkaaJ8tzdcjLis+X2uUKx51kxb/dX16qHYP8ebPE2DBiLn7ge8S9F0igsG wH0UBgpHWHRpO6Y2UhAIdcmxQ6VdCFC6Gsxdm9hXucjQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-proxy :x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm2; bh=K5xJUC 9KJmOc07iYRaClaEUp2qjbg0u93ide2zG42pI=; b=sNliKO3DoAgx3p3XYcHanw KtExGe1+HIVAVD9pwNE/1j1bnxf1YEgp8XGeLBHEefE1may4GG4sZXYfEJj0506u sfqdF1IbSK8fs5KgCpTO/0B9mdoPWSydjQzc1dlpdllPQCmp9PLRxKTWLlAgJ/es t7KWHjz69YZPM+TLwZkB/Xhfyejwl5Y54lNkxHuBe2+mubbIMslmT9rQ6S3bkOvC K9sqIBlO37j1Rkf9ZBd4sphjyxykx2R/0TC80CmAjd0muFNJddjZKH21qSXVHhxi 5o2X2D9cWig0ZdsE0M2tbh9wjo9BfpkASwQ7oR5z92ldOdOtCrEC4MtR1E9kFBAg == X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeduledrgedtgddviecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpehffgfhvffujgffkfggtgesthdtredttdertdenucfhrhhomhepuegvnhcuufht uhhrmhhfvghlshcuoegsvghnsehsthhurhhmrdgtohhmrdgruheqnecuggftrfgrthhtvg hrnhepvefggfehtdfhleevvdekleehtdfgteetueeuueffhedvteehfeejgeekgeegtdet necuffhomhgrihhnpehgnhhurdhorhhgnecukfhppeegledrudelledrjedrvdeinecuve hluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepsggvnhesshht uhhrmhdrtghomhdrrghu X-ME-Proxy: Received: from Marseille (pa49-199-7-26.pa.vic.optusnet.com.au [49.199.7.26]) by mail.messagingengine.com (Postfix) with ESMTPA id F3D09240057; Tue, 2 Feb 2021 06:20:20 -0500 (EST) References: <87wnvrtjpv.fsf@sturm.com.au> <87y2g6an14.fsf@gnu.org> User-agent: mu4e 1.4.14; emacs 27.1 From: Ben Sturmfels In-reply-to: <87y2g6an14.fsf@gnu.org> Date: Tue, 02 Feb 2021 22:20:18 +1100 Message-ID: <87r1lyu365.fsf@sturm.com.au> MIME-Version: 1.0 Content-Type: text/plain Received-SPF: pass client-ip=66.111.4.26; envelope-from=ben@sturm.com.au; helo=out2-smtp.messagingengine.com X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.6 (-) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -2.6 (--) On Tue, 02 Feb 2021, Mathieu Othacehe wrote: > 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 for the quick follow-up Mathieu, that's very helpful. While I'm bothering you, those comments "XXX: Remove when postgresql default socket directory is changed to /var/run/postgresql" looked like they could be might be redundant now. Is that the case? Thanks again, Ben