From 9f7e67ff040ad7727130e61fcc9bac01dd3bd553 Mon Sep 17 00:00:00 2001
From: Gregor Kleen <gkleen@yggdrasil.li>
Date: Thu, 24 Feb 2022 21:27:28 +0100
Subject: surtr: ...
---
hosts/surtr/postgresql.nix | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)
(limited to 'hosts/surtr')
diff --git a/hosts/surtr/postgresql.nix b/hosts/surtr/postgresql.nix
index f4a122aa..a34bc675 100644
--- a/hosts/surtr/postgresql.nix
+++ b/hosts/surtr/postgresql.nix
@@ -5,7 +5,7 @@
enable = true;
package = pkgs.postgresql_14;
initialScript = pkgs.writeText "schema.sql" ''
- CREATE DATABASE "matrix-synapse" WITH ENCODING "UTF8" LOCALE "C";
+ CREATE DATABASE "matrix-synapse" WITH TEMPLATE "template0" ENCODING "UTF8" LOCALE "C";
CREATE USER "matrix-synapse";
GRANT ALL PRIVILEGES ON DATABASE "matrix-synapse" TO "matrix-synapse";
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "matrix-synapse";
--
cgit v1.2.3