services.postgresql.ensureUsers.*.ensureClauses ‐ NixOS ‐ Searchix

services.postgresql.ensureUsers.*.ensureClauses

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

{
  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=";
}

Declared