Postgres initdb cannot be run as root, making it impossible to use postgres in a container

[mcdonc]

With a devenv.nix that contains:

  services.postgres = {
    enable = true;
    package = pkgs.postgresql_16;
    initialDatabases = [ { name = "climo"; } { name = "assetdbmock"; } ];
    initdbArgs = [ "--locale=en_US.utf8" "--encoding=UTF8" ];
  };

Upon devenv container processes --docker-run:

"level":"warn","error":"user: lookup userid 0: no such file or directory","time":"2024-01-28T07:08:17Z","message":"Failed to retrieve user info."}
[postgres	] initdb: error: cannot be run as root
[postgres	] initdb: hint: Please log in (using, e.g., "su") as the (unprivileged) user that will own the server process.

This is a postgres "feature".

[mcdonc]

This will be fixed via #963

[mcdonc]

#963 was merged into the Python rewrite branch.