Skip to content
Announcing BigAnimal: Fully managed PostgreSQL in the Cloud
Contact usDocsPlans

Video: PostgreSQL Security Features - Password Profiles

Marc Linster1/5/2021
PostgreSQL

A password profile is a named set of password attributes that allow a DBA to easily manage a group of Postgres roles (or users) that share comparable password requirements. Each profile can be associated with one or more users. When a user connects to the server, the server enforces the profile that is associated with the login role. 

Profiles can be used for several important security best practices, including:

  • specifying the number of allowable failed login attempts. 
  • locking an account due to excessive failed login attempts.
  • marking a password for expiration.
  • defining a grace period after a password expiration.
  • defining rules for password complexity, and 
  • defining rules that limit password reuse. 

Watch the video below to learn more!

You can download our whitepaper here to read more about PostgreSQL security best practices.
 

Marc Linster, Ph.D., is EDB’s Chief Technology Officer. Marc is committed to EDB being an accelerator to providing architectural “know how” to help customers take advantage of Postgres without significant risk and cost. Marc believes that although new customer adoption of open source is easier than ...