Nix configurations for my homelab
yemou.pink
1{ lib, ... }:
2{
3 environment.persistence."/data/persistent".directories = [ "/var/lib/postgresql" ];
4
5 services.postgresql = {
6 enable = true;
7 identMap = ''
8 # MapName SystemUser DBUser
9 myMap root postgres
10 myMap postgres postgres
11 myMap /^(.*)$ \1
12 '';
13 authentication = lib.mkOverride 10 ''
14 # type database dbUser authMethod optionalIdentMap
15 local all postgres peer map=myMap
16 local sameuser all peer map=myMap
17 '';
18 };
19}