summaryrefslogtreecommitdiff
path: root/hosts/surtr/postgresql
diff options
context:
space:
mode:
Diffstat (limited to 'hosts/surtr/postgresql')
-rw-r--r--hosts/surtr/postgresql/default.nix8
1 files changed, 7 insertions, 1 deletions
diff --git a/hosts/surtr/postgresql/default.nix b/hosts/surtr/postgresql/default.nix
index 3640ff12..e29da0b8 100644
--- a/hosts/surtr/postgresql/default.nix
+++ b/hosts/surtr/postgresql/default.nix
@@ -297,7 +297,6 @@ in {
297 297
298 COMMIT; 298 COMMIT;
299 299
300
301 BEGIN; 300 BEGIN;
302 SELECT _v.register_patch('014-relay', ARRAY['000-base'], null); 301 SELECT _v.register_patch('014-relay', ARRAY['000-base'], null);
303 302
@@ -308,6 +307,13 @@ in {
308 ); 307 );
309 308
310 COMMIT; 309 COMMIT;
310
311 BEGIN;
312 SELECT _v.register_patch('015-relay-unique', ARRAY['000-base', '014-relay'], null);
313
314 CREATE UNIQUE INDEX relay_unique ON relay_access (mailbox, domain);
315
316 COMMIT;
311 ''} 317 ''}
312 318
313 psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" '' 319 psql etebase postgres -eXf ${pkgs.writeText "etebase.sql" ''