When you create a database user with CREATE ROLE, the database user is assigned the default profile. For the default profile, all parameters are disabled, so change the parameter values to suit your policy. Change the value with the pgx_alter_profile function.

Users with CREATEROLE privilege can modify the contents of a profile.

Refer to "B.3.1 Profile Management Functions" for functions.

[Example]

SELECT pgx_alter_profile('default',
‘{
    "PASSWORD_LIFE_TIME": 50,
    "PASSWORD_GRACE_TIME": "10"
    "PASSWORD_REUSE_MAX": 5,
    "PASSWORD_LOCK_TIME": 0.5,
    "PASSWORD_ALLOW_HASHED": true
}’);