From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from mp0 ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by ms11 with LMTPS id cE/eEQE9lV/lLgAA0tVLHw (envelope-from ) for ; Sun, 25 Oct 2020 08:53:21 +0000 Received: from aspmx1.migadu.com ([2001:41d0:2:4a6f::]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits)) by mp0 with LMTPS id GHjBDQE9lV8EFQAA1q6Kng (envelope-from ) for ; Sun, 25 Oct 2020 08:53:21 +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 8C3499403CC for ; Sun, 25 Oct 2020 08:53:20 +0000 (UTC) Received: from localhost ([::1]:40060 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kWbmA-00070J-1b for larch@yhetil.org; Sun, 25 Oct 2020 04:53:18 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:35338) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kWblu-000706-TE for guix-patches@gnu.org; Sun, 25 Oct 2020 04:53:03 -0400 Received: from debbugs.gnu.org ([209.51.188.43]:52423) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1kWblu-00027H-KB for guix-patches@gnu.org; Sun, 25 Oct 2020 04:53:02 -0400 Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1kWblu-00079L-He for guix-patches@gnu.org; Sun, 25 Oct 2020 04:53:02 -0400 X-Loop: help-debbugs@gnu.org Subject: [bug#44207] [PATCH] doc: Document the postgresql-config-file. Resent-From: Christopher Baines Original-Sender: "Debbugs-submit" Resent-CC: guix-patches@gnu.org Resent-Date: Sun, 25 Oct 2020 08:53:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 44207 X-GNU-PR-Package: guix-patches X-GNU-PR-Keywords: patch To: 44207@debbugs.gnu.org X-Debbugs-Original-To: guix-patches@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.160361593527421 (code B ref -1); Sun, 25 Oct 2020 08:53:02 +0000 Received: (at submit) by debbugs.gnu.org; 25 Oct 2020 08:52:15 +0000 Received: from localhost ([127.0.0.1]:35736 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kWbl9-00078B-Be for submit@debbugs.gnu.org; Sun, 25 Oct 2020 04:52:15 -0400 Received: from lists.gnu.org ([209.51.188.17]:57058) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1kWbl7-000783-3O for submit@debbugs.gnu.org; Sun, 25 Oct 2020 04:52:14 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:35296) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1kWbl6-0006xO-Pq for guix-patches@gnu.org; Sun, 25 Oct 2020 04:52:12 -0400 Received: from mira.cbaines.net ([212.71.252.8]:59964) by eggs.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1kWbl4-0001ou-Cp for guix-patches@gnu.org; Sun, 25 Oct 2020 04:52:12 -0400 Received: from localhost (92.41.179.191.threembb.co.uk [92.41.179.191]) by mira.cbaines.net (Postfix) with ESMTPSA id 6975827BBF0 for ; Sun, 25 Oct 2020 08:51:37 +0000 (GMT) Received: from localhost (localhost [local]) by localhost (OpenSMTPD) with ESMTPA id fc906c77 for ; Sun, 25 Oct 2020 08:51:34 +0000 (UTC) From: Christopher Baines Date: Sun, 25 Oct 2020 08:51:34 +0000 Message-Id: <20201025085134.14378-1-mail@cbaines.net> X-Mailer: git-send-email 2.28.0 MIME-Version: 1.0 Content-Transfer-Encoding: 8bit Received-SPF: pass client-ip=212.71.252.8; envelope-from=mail@cbaines.net; helo=mira.cbaines.net X-detected-operating-system: by eggs.gnu.org: First seen = 2020/10/25 04:51:37 X-ACL-Warn: Detected OS = Linux 2.2.x-3.x [generic] [fuzzy] X-Spam_score_int: -18 X-Spam_score: -1.9 X-Spam_bar: - X-Spam_report: (-1.9 / 5.0 requ) BAYES_00=-1.9, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001, UNPARSEABLE_RELAY=0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: -1.3 (-) X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-Spam-Score: -2.3 (--) 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" X-Scanner: scn0 Authentication-Results: aspmx1.migadu.com; dkim=none; dmarc=none; 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-Spam-Score: 3.99 X-TUID: aCIxHg907ASI * doc/guix.texi (PostgreSQL): Document the postgresql-config-file record. --- doc/guix.texi | 48 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 48 insertions(+) diff --git a/doc/guix.texi b/doc/guix.texi index b5061877e2..726906c77d 100644 --- a/doc/guix.texi +++ b/doc/guix.texi @@ -18553,6 +18553,54 @@ required to add extensions provided by other packages. @end table @end deftp +@deftp {Data Type} postgresql-config-file +Data type representing the PostgreSQL configuration file. As shown in +the following example, this can be used to customise the configuration +of PostgreSQL. Note that you can use any G-expression or filename in +place of this record, if you already have a configuration file you'd +like to use for example. + +@lisp +(service postgresql-service-type + (postgresql-configuration + (config-file + (postgresql-config-file + (log-destination "stderr") + (hba-file + (plain-file "pg_hba.conf" + " +local all all trust +host all all 127.0.0.1/32 md5 +host all all ::1/128 md5")) + (extra-config + '(("session_preload_libraries" "'auto_explain'") + ("random_page_cost" "2") + ("auto_explain.log_min_duration" "'100ms'") + ("work_mem" "'500MB'") + ("logging_collector" "on") + ("log_directory" "'/var/log/postgresql'"))))))) +@end lisp + +@table @asis +@item @var{log-destination} (default: @code{"syslog"}) +The logging method to use for PostgreSQL. Multiple values are accepted, +separated by commas. + +@item @var{hba-file} (default: @code{%default-postgres-hba}) +Filename or G-expression for the host-based authentication +configuration. + +@item @var{ident-file} (default: @code{%default-postgres-ident}) +Filename or G-expression for the user name mapping configuration. + +@item @var{extra-config} (default: @code{'()}) +List of additional keys and values to include in the PostgreSQL config +file. Each entry in the list should be a list where the first element +is the key, and the remaining elements are the values. + +@end table +@end deftp + @subsubheading MariaDB/MySQL @deffn {Scheme Procedure} mysql-service [#:config (mysql-configuration)] -- 2.28.0