diff options
author | Gregor Kleen <gkleen@yggdrasil.li> | 2022-12-18 19:11:49 +0100 |
---|---|---|
committer | Gregor Kleen <gkleen@yggdrasil.li> | 2022-12-18 19:11:49 +0100 |
commit | affd561853323be51b4bef9c8a9841e7b90899ce (patch) | |
tree | 894405ec10e1982d1405e5cd85bd15a8975b7340 /hosts/surtr/postgresql | |
parent | 2b92f10ae5dab7c78718db4b701e866ac85d99cb (diff) | |
download | nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar.gz nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar.bz2 nixos-affd561853323be51b4bef9c8a9841e7b90899ce.tar.xz nixos-affd561853323be51b4bef9c8a9841e7b90899ce.zip |
...
Diffstat (limited to 'hosts/surtr/postgresql')
-rw-r--r-- | hosts/surtr/postgresql/default.nix | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix index b9086e73..f0edfbac 100644 --- a/hosts/surtr/postgresql/default.nix +++ b/hosts/surtr/postgresql/default.nix | |||
@@ -242,6 +242,12 @@ in { | |||
242 | 242 | ||
243 | GRANT UPDATE ON "mailbox_mapping" TO "spm"; | 243 | GRANT UPDATE ON "mailbox_mapping" TO "spm"; |
244 | COMMIT; | 244 | COMMIT; |
245 | |||
246 | BEGIN; | ||
247 | SELECT _v.register_patch('010-spm-delete-mapping', ARRAY['000-base', '002-citext', '003-extensions'], null); | ||
248 | |||
249 | GRANT DELETE ON "mailbox_mapping" TO "spm"; | ||
250 | COMMIT; | ||
245 | ''} | 251 | ''} |
246 | 252 | ||
247 | psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' | 253 | psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' |