{ config, ... }: let dataDir = "/media/draupner/postgresql/${config.services.postgresql.package.psqlSchema}"; in { services.postgresql = { enable = true; enableJIT = true; inherit dataDir; ensureUsers = [ { name = "mathias"; ensureClauses.superuser = true; ensureClauses.login = true; } ]; authentication = '' local all postgres peer local all all peer map=m ''; identMap = '' m mathias all m /^(.*)$ \1 ''; }; systemd.tmpfiles.rules = [ "d ${dataDir} 750 postgres postgres" ]; }