[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
04/08: services: postgresql: Add more role fields.
From: |
guix-commits |
Subject: |
04/08: services: postgresql: Add more role fields. |
Date: |
Thu, 10 Aug 2023 18:54:34 -0400 (EDT) |
civodul pushed a commit to branch master
in repository guix.
commit 71aba798d3d586a42afe8a61e8e36b95ca41bc37
Author: Miguel Moreno <mmoreno@mmoreno.eu>
AuthorDate: Mon Mar 27 19:30:45 2023 +0200
services: postgresql: Add more role fields.
* gnu/services/databases.scm (postgresql-role): Add more role fields.
(postgresql-create-roles): Honor it.
* doc/guix.texi (Database Services): Document it.
Signed-off-by: Ludovic Courtès <ludo@gnu.org>
---
doc/guix.texi | 16 +++++++++++++++-
gnu/services/databases.scm | 19 ++++++++++++++++---
2 files changed, 31 insertions(+), 4 deletions(-)
diff --git a/doc/guix.texi b/doc/guix.texi
index 71f9f29169..409ca2ad62 100644
--- a/doc/guix.texi
+++ b/doc/guix.texi
@@ -25258,7 +25258,21 @@ The role permissions list. Supported permissions are
@code{bypassrls},
@code{superuser}.
@item @code{create-database?} (default: @code{#f})
-Whether to create a database with the same name as the role.
+whether to create a database with the same name as the role.
+
+@item @code{encoding} (default: @code{"UTF8"})
+The character set to use for storing text in the database.
+
+@item @code{collation} (default: @code{"en_US.utf8"})
+The string sort order locale setting.
+
+@item @code{ctype} (default: @code{"en_US.utf8"})
+The character classification locale setting.
+
+@item @code{template} (default: @code{"template1"})
+The default template to copy the new database from when creating it.
+Use @code{"template0"} for a pristine database with no system-local
+modifications.
@end table
@end deftp
diff --git a/gnu/services/databases.scm b/gnu/services/databases.scm
index e8e42d3b7b..7148971c1d 100644
--- a/gnu/services/databases.scm
+++ b/gnu/services/databases.scm
@@ -363,7 +363,15 @@ and stores the database cluster in @var{data-directory}."
(permissions postgresql-role-permissions
(default '(createdb login))) ;list
(create-database? postgresql-role-create-database? ;boolean
- (default #f)))
+ (default #f))
+ (encoding postgresql-role-encoding ;string
+ (default "UTF8"))
+ (collation postgresql-role-collation ;string
+ (default "en_US.utf8"))
+ (ctype postgresql-role-ctype ;string
+ (default "en_US.utf8"))
+ (template postgresql-role-template ;string
+ (default "template1")))
(define-record-type* <postgresql-role-configuration>
postgresql-role-configuration make-postgresql-role-configuration
@@ -392,7 +400,8 @@ and stores the database cluster in @var{data-directory}."
(append-map
(lambda (role)
(match-record role <postgresql-role>
- (name permissions create-database?)
+ (name permissions create-database? encoding collation ctype
+ template)
`("SELECT NOT(EXISTS(SELECT 1 FROM pg_catalog.pg_roles WHERE \
rolname = '" ,name "')) as not_exists;\n"
"\\gset\n"
@@ -402,7 +411,11 @@ rolname = '" ,name "')) as not_exists;\n"
";\n"
,@(if create-database?
`("CREATE DATABASE \"" ,name "\""
- " OWNER \"" ,name "\";\n")
+ " OWNER \"" ,name "\"\n"
+ " ENCODING '" ,encoding "'\n"
+ " LC_COLLATE '" ,collation "'\n"
+ " LC_CTYPE '" ,ctype "'\n"
+ " TEMPLATE " ,template ";")
'())
"\\endif\n")))
roles)))
- branch master updated (3775006f24 -> 56fddefc6d), guix-commits, 2023/08/10
- 01/08: gnu: libflame: Remove dependency on OpenBLAS., guix-commits, 2023/08/10
- 03/08: gnu: openfoam-org: Use 'git-fetch'., guix-commits, 2023/08/10
- 05/08: gnu: Add fritzing-parts., guix-commits, 2023/08/10
- 02/08: gnu: libflame: Remove input labels and use gexps., guix-commits, 2023/08/10
- 04/08: services: postgresql: Add more role fields.,
guix-commits <=
- 06/08: gnu: fritzing: Improve package style., guix-commits, 2023/08/10
- 07/08: gnu: Sort use-module alphabetically in (gnu packages engineering), guix-commits, 2023/08/10
- 08/08: services: syncthing: Use the new command line syntax., guix-commits, 2023/08/10