diff options
| author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-02-24 21:27:28 +0100 |
|---|---|---|
| committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-02-24 21:27:28 +0100 |
| commit | 9f7e67ff040ad7727130e61fcc9bac01dd3bd553 (patch) | |
| tree | eb97c4925f0068f4e7ed22be4b52ab8aba0074ba /hosts/surtr/postgresql.nix | |
| parent | af56019d0d2f4270440c10192c802c3fbdf28cb4 (diff) | |
| download | nixos-9f7e67ff040ad7727130e61fcc9bac01dd3bd553.tar nixos-9f7e67ff040ad7727130e61fcc9bac01dd3bd553.tar.gz nixos-9f7e67ff040ad7727130e61fcc9bac01dd3bd553.tar.bz2 nixos-9f7e67ff040ad7727130e61fcc9bac01dd3bd553.tar.xz nixos-9f7e67ff040ad7727130e61fcc9bac01dd3bd553.zip | |
surtr: ...
Diffstat (limited to 'hosts/surtr/postgresql.nix')
| -rw-r--r-- | hosts/surtr/postgresql.nix | 2 |
1 files changed, 1 insertions, 1 deletions
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 @@ | |||
| 5 | enable = true; | 5 | enable = true; |
| 6 | package = pkgs.postgresql_14; | 6 | package = pkgs.postgresql_14; |
| 7 | initialScript = pkgs.writeText "schema.sql" '' | 7 | initialScript = pkgs.writeText "schema.sql" '' |
| 8 | CREATE DATABASE "matrix-synapse" WITH ENCODING "UTF8" LOCALE "C"; | 8 | CREATE DATABASE "matrix-synapse" WITH TEMPLATE "template0" ENCODING "UTF8" LOCALE "C"; |
| 9 | CREATE USER "matrix-synapse"; | 9 | CREATE USER "matrix-synapse"; |
| 10 | GRANT ALL PRIVILEGES ON DATABASE "matrix-synapse" TO "matrix-synapse"; | 10 | GRANT ALL PRIVILEGES ON DATABASE "matrix-synapse" TO "matrix-synapse"; |
| 11 | GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "matrix-synapse"; | 11 | GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "matrix-synapse"; |