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 | |
| 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')
| -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" '' |
