Get Postgres Tips and Tricks
Subscribe to get advanced Postgres how-tos.
![]() |
![]() |
![]() |
2 SQL Tutorial : 2.3 Profile Management
Advanced Server 9.5 allows a database superuser to create named profiles. Each profile defines rules for password management that augment password and md5 authentication. The rules in a profile can:Advanced Server 9.5 creates a profile named default that is associated with a new role when the role is created unless an alternate profile is specified. If you upgrade to Advanced Server 9.5 from a previous server version, existing roles will automatically be assigned to the default profile. You cannot delete the default profile.FAILED_LOGIN_ATTEMPTS UNLIMITEDPASSWORD_LOCK_TIME UNLIMITEDA database superuser can use the ALTER PROFILE command to modify the values specified by the default profile. For more information about modifying a profile, see Section 2.3.2.
2 SQL Tutorial : 2.3 Profile Management
![]() |
![]() |
![]() |