services.postgresql.ensureUsers.*.ensureClauses
NixOS option
An attrset of clauses to grant to the user. Under the hood this uses the ALTER USER syntax for each attrName where the attrValue is true in the attrSet: ALTER USER user.name WITH attrName
type: open submodule of attribute set of (string or signed integer or boolean)Default
{ }Example
declared in: nixos/modules/services/databases/postgresql.nixView source on NixOS/nixpkgs →{
superuser = true;
createrole = true;
createdb = true;
connection_limit = 5;
# SCRAM-SHA-256 hashed password for "password"
# Generate hashes using PostgreSQL or a dedicated script rather than storing passwords in plain text.
password = "SCRAM-SHA-256$4096:SZEJF5Si4QZ6l4fedrZZWQ==$6u3PWVcz+dts+NdpByPIjKa4CaSnoXGG3M2vpo76bVU=:WSZ0iGUCmVtKYVvNX0pFOp/60IgsdJ+90Y67Eun+QE0=";
}