postgresql: give postgres user a shell

(cherry picked from commit 82feb4b66ebd841389d00ca7b3d5e9b4c3ea61c8)
Signed-off-by: Domen Kožar <domen@dev.si>

1 files changed, 2 insertions, 0 deletions

diff --git a/nixos/modules/services/databases/postgresql.nix b/nixos/modules/services/databases/postgresql.nix
index f59fb1c817726..de2a757196a5d 100644
--- a/nixos/modules/services/databases/postgresql.nix
+++ b/nixos/modules/services/databases/postgresql.nix
@@ -188,6 +188,8 @@ in
         uid = config.ids.uids.postgres;
         group = "postgres";
         description = "PostgreSQL server user";
+        home = "${cfg.dataDir}";
+        useDefaultShell = true;
       };
 
     users.groups.postgres.gid = config.ids.gids.postgres;