From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp2 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id TRRsLSiYGGAqYwAA0tVLHw (envelope-from ) for ; Tue, 02 Feb 2021 00:09:12 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp2 with LMTPS id YLDkKCiYGGDsSgAAB5/wlQ (envelope-from ) for ; Tue, 02 Feb 2021 00:09:12 +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 C3CC2940250 for ; Tue, 2 Feb 2021 00:09:09 +0000 (UTC) Received: from localhost ([::1]:42458 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1l6jFk-0002vT-Op for larch@yhetil.org; Mon, 01 Feb 2021 19:09:08 -0500 Received: from eggs.gnu.org ([2001:470:142:3::10]:40054) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1l6jFe-0002v7-7P for guix-patches@gnu.org; Mon, 01 Feb 2021 19:09:02 -0500 Received: from debbugs.gnu.org ([209.51.188.43]:50260) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1l6jFd-0003Fr-Uf for guix-patches@gnu.org; Mon, 01 Feb 2021 19:09:01 -0500 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1l6jFd-0007cy-OP for guix-patches@gnu.org; Mon, 01 Feb 2021 19:09:01 -0500 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 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-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: , Errors-To: guix-patches-bounces+larch=yhetil.org@gnu.org Sender: "Guix-patches" Reply-to: Ben Sturmfels X-ACL-Warn: , Ben Sturmfels via Guix-patches From: guix-patches--- via X-Migadu-Flow: FLOW_IN X-Migadu-Spam-Score: -2.86 Authentication-Results: aspmx1.migadu.com; dkim=fail ("headers rsa verify failed") header.d=sturm.com.au header.s=fm2 header.b=IUTsHvBr; dkim=fail ("headers rsa verify failed") header.d=messagingengine.com header.s=fm1 header.b=cIgWAmeo; 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: C3CC2940250 X-Spam-Score: -2.86 X-Migadu-Scanner: scn0.migadu.com X-TUID: VirQgkzA0a05 --=-=-= 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 --=-=-=--