Postgresql schema

1 files changed, 6 insertions, 3 deletions

diff --git a/bragi.nix b/bragi.nix
index c4a10e83..ed60b241 100644
--- a/bragi.nix
+++ b/bragi.nix
@@ -360,9 +360,12 @@ in rec {
   services.postgresql = {
     enable = true;
     authentication = lib.mkForce ''
-      local sameuser all peer
-      local postgres all peer
-      local all root,@admins peer
+      local all all peer
+    '';
+    initialScript = ''
+      CREATE DATABASE thermoprint;
+      CREATE USER thermoprint;
+      GRANT ALL ON DATABASE thermoprint TO thermoprint;
     '';
   };